BenR

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 42 total)
  • Author
    Posts
  • in reply to: Cascading Menus – force one item to bottom of list… #35042
    BenR
    Participant

    Alexander,

    YES! Success!

    Thank you for your patience – I know you support many users, but you stayed with me and guided me to success.

    Stay well, R’grds – Ben.

    in reply to: Cascading Menus – force one item to bottom of list… #35038
    BenR
    Participant

    Alexander,

    Very good – now the sort is modified, but “Other” is moved to the top of the list instead of at the bottom.

    Is there another tweak you can recommend?

    R’grds – Ben.

    in reply to: Cascading Menus – force one item to bottom of list… #35034
    BenR
    Participant

    Alexander,

    I’m only part way successful. I have removed the this particular Cascade from the Cascading Dropdown tab, and manually invoked from the Custom JS tab. (Should I mention that I have two other Cascades specified in the Cascading Dropdown tab?).

    The cascade works, however the sort seems not to have an affect – the list still follows standard alphabetic sort.

    This is what I have assembled… The letter I would like to force to the bottom of the list is “O”, and tier-1’s internal name is “Title”

    
    
    //Manual invocation of Cascade for ProductLineL1
    spjs.casc.customSort.Title = function(a, b) {
        // Put O last in the dropdown
        if(a.text === "O" || b.text === "O"){
            return -1;
        }
        // Normal alphabetic sorting
        if(a.text < b.text){
            return -1;
        }
        if(a.text > b.text){
            return 1;
        }
        return 0;
    };
    
    spjs.casc.init(
     {
     "manualMode":true,
     "dataSource":"",
     "lookupList":"ProductLines",
     "lookupListBaseUrl":"https://sp.REDACTED.net/sites/spptdgsl/VPP",
     "lookupListFields":["Title","ProductLineL2","ProductLineGrouping"],
     "thisListFields":["ProductLineL1","ProductLineL2","ProductLineGrouping"],
     "setFields":[],
     "dropDownDefaultvalue":"- Select - ",
     "filter":"",
     "hideEmptyDropdowns":false,
     "autoselectSingleOption":true,
     "clearInvalidSelection":false,
     "addOwnValue":false,
     "addOwnValueMouseover":"",
     "cancelOwnValueMouseover":"",
     "sideBySide":true,
     "multichoiceDelimiter": ";" + String.fromCharCode(13, 10), // this represents a semicolon and a linefeed
     "debug":false
     }
    );

    Does this look right?

    As always, your support and efforts are appreciated!

    R’grds – Ben.

    in reply to: Rule issue introduced in DFFS_v4.4.5.19 & .20 #33195
    BenR
    Participant

    Alexander,

    Yes! Your fix has addressed my symptom, and I am now running v4.4.5.21 in production.

    As always, your support and efforts are greatly appreciated!

    R’grds – Ben.

    in reply to: Rule issue introduced in DFFS_v4.4.5.19 & .20 #33173
    BenR
    Participant

    Alexander,

    My SP platform is SharePoint 2013 on premises.

    R’grds – Ben.

    in reply to: Rule issue introduced in DFFS_v4.4.5.19 & .20 #33168
    BenR
    Participant

    Alexander,

    I’ve captured console errors only in the attached file, comparing DFFS_v4.4.5.18 (SUCCESSFUL) to DFFS_v4.4.5.20 (FAILING)

    R’grds – Ben.

    in reply to: Conditional Highlighting #32108
    BenR
    Participant

    Sooo… Alexander,

    Why have you not responded to my question? It’s a pretty simple request (I think) and I don’t find sufficient information to do this on my own. Your original solution, posted in 2014, is not working.

    I’ve found you highly responsive in the past – is this a sensitive subject? Frankly, I don’t ask if I know the answer – I really don’t understand, but am willing to try. I’ve learned from each answer you have provided.

    Okay, if you don’t solve my problem and answer my question – at least tell me why you won’t. As I’ve stated with each time I’ve reached out for your support, I sincerely appreciate your support and efforts!

    R’grds – Ben.

    in reply to: Conditional Highlighting #31911
    BenR
    Participant

    Alexander,
    I hope you are well.

    I am attempting a simple thing – I would like to highlight a field with background color while it is blank. My preference is not to make it a Required field, but maintain a highlight until it is populated. I’ve tried to use the top-most solution in this thread, but to no avail.

    Required: While SPFieldText: CompassID is blank, change it’s background color to “#fcd4dc”. Else, if populated, leave it white.

    Would this be triggered by a rule on CompassID?

    As always, your support and efforts are greatly appreciated!

    R’grds – Ben.
    Reference:
    Custom DFFS-folder: DFFS_v4.4.5.7_2020-08-30
    DFFS Loader: v2
    DFFS frontend: 4.4.5.7 – August 30, 2020
    DFFS frontend CSS: 4.62 / 4.62
    Autocomplete: 1.6.49 – June 28, 2020
    Cascading dropdowns: 3.7.41 – August 30, 2020
    jQuery: 1.12.4
    Lookup: 1.1.20 – March 10, 2020
    Resource management: 2.4.5 – August 29, 2019
    SPJS-Utility: 1.348 – June 28, 2020
    vLookup: 2.2.156 – June 28, 2020

    • This reply was modified 2 years, 11 months ago by BenR.
    in reply to: Pull user info from a people picker #31291
    BenR
    Participant

    Whoops! I embarrass myself – Err: .01% should be 1%.

    in reply to: Pull user info from a people picker #31289
    BenR
    Participant

    Alexander,

    I’ve gathered more statistics to judge effectiveness of my prior vs. current JS method…

    Assuming that a given function will never succeed 100% of the time, grouping eight operations into one function produced a 15% failure rate across 100 invocations (one per record).

    However, by breaking the eight operations into eight discrete functions each invoked once per record, the failure rate drops dramatically. The next 50 records (8×50=400 invocations) resulted in only four failures, or .01% – which is totally acceptable in my application.

    Thank you for your support, I think I have a solution!

    R’grds – Ben.

    in reply to: Pull user info from a people picker #31236
    BenR
    Participant

    Alexander,

    As my solution was to replicate the provided code eight times to address eight People Picker fields, plus the symptom is a failure of the bulk function, I’ve broken the bulk function into eight discreet functions…

    I hope to see a possible improvement, and am gathering statistics.

    R’grds – Ben.

    in reply to: Pull user info from a people picker #31232
    BenR
    Participant

    Alexander,

    I hope you are well and staying safe.

    I have applied this method to retrieve additional information from eight People Picker fields (all single selection fields). I have triggered this function to On-Save rules in both NewItem and EditItem forms. However, I find that it doesn’t always work, where none of the destination fields are populated – this is in 15 of 100 sampled records.

    I cannot find a pattern across the 15 failed records

    • Some created via NewItem, some subsequently edited in EditItem
    • Different users either create or edit failed records
    • My firm uses IE, Chrome, and Firefox – but I can’t tell what my users use, but my tests show all three browsers work

    Is there something in my code that you see that could cause this 15% failure rate?

    
    
    function acquireRoleDetail(){
     jQuery.each(spjs.utility.getFieldValue({"fin":"Compass_x0020_Delivery_x0020_Man","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("DeliveryManagerSIP",ppData.SipAddress);
      setFieldValue("DeliveryManagerSID",ppData.Name.slice(-7).toUpperCase());
     });
     jQuery.each(spjs.utility.getFieldValue({"fin":"ExecutiveSponsor","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("ExecutiveSponsorSIP",ppData.SipAddress);
      setFieldValue("ExecutiveSponsorSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"FinalApprover","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("FinalApproverSIP",ppData.SipAddress);
      setFieldValue("FinalApproverSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"FinanceManager","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("FinanceManagerSIP",ppData.SipAddress);
      setFieldValue("FinanceManagerSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"LegalContact","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("LegalContactSIP",ppData.SipAddress);
      setFieldValue("LegalContactSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"SourcingCategoryDirector","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("SourcingCategoryDirectorSIP",ppData.SipAddress);
      setFieldValue("SourcingCategoryDirectorSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"SourcingManager","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("SourcingCategoryManagerSIP",ppData.SipAddress);
      setFieldValue("SourcingCategoryManagerSID",ppData.Name.slice(-7).toUpperCase());
     });
      jQuery.each(spjs.utility.getFieldValue({"fin":"VendorManager","key":"loginName"}),function(i,login){
     var ppData = spjs.utility.userInfo(login);
      setFieldValue("VendorManagerSIP",ppData.SipAddress);
      setFieldValue("VendorManagerSID",ppData.Name.slice(-7).toUpperCase());
     });
    }

    As always, your support and efforts are greatly appreciated!

    R’grds – Ben.
    Reference:
    Version information
    Custom DFFS-folder: DFFS_v4.4.5.4_2020-07-04
    DFFS Loader: v2
    DFFS frontend: 4.4.5.4 – July 04, 2020
    DFFS frontend CSS: 4.61 / 4.61
    Autocomplete: 1.6.49 – June 28, 2020
    Cascading dropdowns: 3.7.40 – June 1, 2020
    jQuery: 1.12.4
    Lookup: 1.1.20 – March 10, 2020
    Resource management: 2.4.5 – August 29, 2019
    SPJS-Utility: 1.348 – June 28, 2020
    vLookup: 2.2.156 – June 28, 2020

    in reply to: Rules issues introduced DFFS_v4.4.5.0_2020-06-01… #30513
    BenR
    Participant

    Alexander,

    Yes! SPJS-utility_v1.348 fixed my issue.

    Aside from clearing the cache, I found I had to Update loader file in DFFSInstaller_V2 (… If you have updated DFFS to a new version you should hit the button to write a new timestamp to the loader file to prevent the browser from caching the script files.).

    Once done, SPJS-utility_v1.348 loaded correctly, and my symptom is resolved.

    Again, your support and efforts are greatly appreciated!

    R’grds – Ben.

    in reply to: Inconsistant result of Member of Group Rule… #30399
    BenR
    Participant

    Alexander,

    v4.4.5.0_2020-06-01 has addressed this issue.

    Thank you so much for your support and efforts!

    R’grds – Ben.

    in reply to: Inconsistant result of Member of Group Rule… #30352
    BenR
    Participant

    Alexander,

    Further investigation… I’ve found that the symptom occurs with my Tabs configuration with the target field (ContractualPayment) placed on all three of my Tabs. To illustrate, please see attachments – one shows the symptom occurring when Tabs are selected after initial form load, and the second shows the three Tabs configuration and placement of the target field.

    1. I’ve confirmed that no other rule addresses the target field
    2. I’ve removed the first rule, and now only the NOT Member of Group Rule, Hide Field with allowed reversing remains
    3. The symptom persists with v4.4.4.32_2020-05-10
    4. The symptom DOES NOT occur with v4.4.4.23_2020-02-13
    5. If I remove the target field from two of the three tabs (so it appears only on one Tab), the symptom DOES NOT occur

    So, a temporary work around is to remove the target field from two of the three tabs. However, I would not consider this a fix.
    As always, thank you for your support and efforts!
    R’grds – Ben.

    • This reply was modified 3 years, 3 months ago by BenR.
Viewing 15 posts - 1 through 15 (of 42 total)