BenR

Forum Replies Created

Viewing 14 posts - 16 through 29 (of 29 total)
  • Author
    Posts
  • in reply to: Rules: Set field value post 4.4.4.0 thru 4.4.4.2 #26467
    BenR
    Participant

    Alexander,

    Your suggestion to investigate the Trigger Map led to more information…

    What I noted: I have four Rules 1, 2, 3, & 4. Each rule triggers on Load and field change, and each rule is non-reversing.

    • Rule 1 clears the value of CommodityType
    • Rule 3 sets the value of CommodityType

    If Rule 3 is true, and the rules are fired in that order, I should find a value in CommodityType. My symptom is that Rule 3 is true, but I find no value in CommodityType.

    Setting each of the rules to debug, I load a form and set the field that makes Rule 3 true. The attached images display debug Rule trigger order.

    For 4.4.3.65, you see 8 rule triggers, 4 on load, 4 on change. Further, you see the order of 1,2,3,4 on load, and 1,2,3,4 on change.

    For 4.4.4.4, you see 3 on load, 4 on change. Note the order of 2,3,4 on load, and 2,4,3,1 on change – this places Rule 3 (set value to CommodityType) before Rule 1 (clear value from CommodityType) – which matches my symptom.

    From this, I believe the root cause is that Rule execution order in 4.4.4.4 is in error.

    R’grds – Ben.

    BenR
    Participant

    Alexander,

    Thank you – you never disappoint! This method is exactly what I needed, and a good lesson. As always, I appreciate your support and efforts!

    R’grds – Ben.

    BenR
    Participant

    Alexander,

    Sorry – I have been unclear… The problem is in the formatting of the result as a string.

    In this example, the resultant string is correct – but formatted poorly:

    setFieldValue("mySPFieldText",getFieldValue("mySPFieldUserMulti");

    If mySPFieldUserMulti contains two names, that value is set to the string field mySPFieldText separated by a comma and is where the poor formatting comes in. Like this: mySPFieldUserMulti contains two names:

    • Doe, Jane
    • Public, John

    The result in mySPFieldText will be:

    Doe, Jane,Public, John

    Note that there is no space after the comma between Jane and Public. This is the same result if I use a rule to set the field value.

    What I would like to achieve is the result string to be formatted as

    Doe, Jane; Public, John

    Note that there is semicolon-and-space used to separate the two values.

    Thank you for your consideration.

    R’grds – Ben.

    in reply to: If no child exists, create child from parent… #24790
    BenR
    Participant

    Alexander,

    Okay – just drop the mic! Beautiful, beautiful work – worked on my first try, and filled my every requirement.

    You, sir, are the maestro!

    Many thanks, R’grds – Ben.

    • This reply was modified 1 year, 1 month ago by BenR.
    • This reply was modified 1 year, 1 month ago by BenR.
    BenR
    Participant

    Alexander,

    Nicely done! This suits my application perfectly!

    Hats off to you sir – I always appreciate your support and efforts!

    R’grds – Ben.

    BenR
    Participant

    Alexander,

    I am still using this method, though I am on all current versions… I would like to change the format of the date & time to match what is displayed in the Created and Modified fields – for me, I see: “Created at 3/25/2019 11:06 AM”

    I am using: c = spjs.dffs.buildValStr(“{timestamp[M/d/yyyy hh:mm]}”); which gives me: 3/29/2019 3:07.

    How can I get the AM / PM portion?

    As always, I’m so appreciate your support and efforts!

    R’grds – Ben.
    Reference: Dynamic Forms for SharePoint v4.4.3.64 – March 13, 2019|CSS version: 4.46 / 4.46|spjs-utility version: 1.332

    in reply to: Cascade Plugin plus Required field… #24467
    BenR
    Participant

    Alexander,

    I’ve followed your instructions, and returned the CASC/SBS configuration to my preferred layout – success! Nicely done!

    As always, your support and efforts are greatly appreciated!

    R’grds – BenR.

    • This reply was modified 1 year, 2 months ago by BenR.
    in reply to: SBS – Unequal items per row… #24429
    BenR
    Participant

    Alexander,

    This worked really well! I’ve used this method across each row in the table, and the layout is specific to only this one section of the overall form.

    Really appreciate your support and efforts!

    R’grds – Ben.

    in reply to: Cascade Plugin plus Required field… #24425
    BenR
    Participant

    Alexander,

    I’ve continued to troubleshoot… First, an answer to your last question: If all Rules are disabled, does it work – No.

    Continuing to troubleshoot, I’ve disabled one DFFS feature at a time, and have found a repeatable symptom – When the Cascading fields are placed on a row with other fields using SBS, the results become very unpredictable when Hide the dropdowns when they have no available options is turned on.

    The symptom is that the top-tier cascade field will not display (though a screen refresh may bring it back), the second-tier will not display.

    I kept SBS on, but moved the two tiers onto separate rows without any other fields, and the Cascade functions all worked perfectly.

    When I returned to my preferred layout, where top-tier, second-tier, and another non-Cascade field align on a single row, the symptom returned.

    In the attached screencaps, the fields LOB and SubLOB are Cascading.

    As always, your support and efforts are greatly appreciated!

    Reference:
    Dynamic Forms for SharePoint v4.4.3.64 – March 13, 2019|CSS version: 4.46 / 4.46|spjs-utility version: 1.332|SPJS Cascading dropdowns v3.7.25

    in reply to: SBS – Unequal items per row… #24408
    BenR
    Participant

    Alexander,

    The addition of the Custom CSS did bring all the fields to the left, it is also affecting all the fields on three tabs… I’ve attached a screenshot that shows the result.

    However, in my case, the other sections of this and the other tabs are affected too much to use.

    Is there such a thing as a dummy field? In HTML, you would use a “spacer.gif” to force table rows into alignment… In my case, I would put two more fields at the end of the fourth row.

    R’grds – Ben.

    in reply to: Cascade Plugin plus Required field… #24402
    BenR
    Participant

    Alexander,

    If I disable all rules, the top-level field is displayed… Then –

    1. If I select a top-level value that has an associated level-2 value, top-level is still displayed.
    2. If I select a top-level value that does not have an associated level-2 value (this is the no available options case) the top-level field disappears.

    R’grds – Ben.

    in reply to: SBS – Unequal items per row… #24397
    BenR
    Participant

    Alexander,

    The following is on my Custom CSS tab, attached is a screenshot of setup.

    R’grds – Ben.
    Reference:
    Custom CSS:
    /* Remove padding below fieldlabel and increase the size of the formlabel when using side-by-side */
    .sbs_FieldLabel{
    height:auto;
    }
    .sbs_FieldLabel .ms-formlabel{
    padding:2px 2px 0 2px;
    }

    /* Selected tab color */
    li.tabSelected a {
    color: #ffffff !important;
    background-color: #5fa364 !important;
    border-bottom-color: transparent;
    }

    /* Position tooltip icon to left */
    .customTooltip{
    float:left!important;
    display:inline;
    margin-right:5px;
    }

    /* Header of tooltip call-out */
    div.tooltipHolderHead {
    background-color: #5fa364;
    }

    /* Color of Alert dialog */
    div.dffs_dlg_header {
    background-color: #5fa364;
    }

    input.spjs-dlg-btnOK {
    background-color: #5fa364;
    border: 1px #5fa364 solid;
    }

    /* Border color of tooltip call-out */
    span.tooltipContents {
    border: 1px #5fa364 solid;
    }

    BenR
    Participant

    Alexander,

    Perfect! Thank you for solving my problem!

    R’grds – Ben.

    BenR
    Participant

    Alexander,

    Unfortunately, I am at dffs_min – v3.352, where [The form is saved] trigger only executes the [Set field value] section, and does not executes [Run these functions].

    You mention that two rules could accomplish the same (though not as cleanly), but I don’t see how as a rule cannot be created for a [Multiple Lines of Text] field. Can you guide me to the less-clean solution?

    Greatly appreciate your effort! R’grds – Ben.
    My Environment: SharePoint 2013, dffs_min – v3.352, spjs-utility – v1.257, jquery-1.10.2.min

Viewing 14 posts - 16 through 29 (of 29 total)