avala

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 64 total)
  • Author
    Posts
  • in reply to: setFields multiple fields #16900
    avala
    Participant

    Yes, both are multiple line plain text fields. If it’s working for you, I’ll explore things further on my end.

    in reply to: setFields multiple fields #16895
    avala
    Participant

    Thanks, Alexander.

    Made a minor change in the code as the extra brackets around the Field Internal names prevent the set field action (see below). One thing I noticed is that this seems to force the (Plain Text) Multi-line text field (SendToAddress) act like a single line text field. Seems like carriage returns are disabled for both values entered in through the SetFields action and when I try to manually type text. Anyway to avoid this or is this built into the Autocomplete plugin?

    
    
    spjs.ac.textField({
    	"applyTo":"ShippingToProject",
    	"helpText":"Project number...",
    	"listGuid":"Project Information",
    	"listBaseUrl":"/sites/equip",
    	"showField":"Customer",
    	"enforceUniqueValues":true, // New in v1.33
    	"rowLimit":15,
    	"listOptionsOnFocus":true,
    	"minLengthBeforeSearch":3, // New in v 1.4.12
    	"reValidateOnLoad":true,
    	"allowAddNew":false, // New in v1.4
    	"isLookupInSelf":false, // New in v1.4
    	"filterCAML":"", // New in v1.4.3
    	"multiselect":false, // New in v1.4.4. If this is true, the "setFields section will not apply",
    	"multiselectSeparator":"; ", // New in v1.4.4.
    	"orderBy":[{"fin":"Customer","ascending":true}], // New in v1.4.5
    	"setFields":[
    		{
    			"fromFIN":"Title",
    			"toFIN":"ShippingToProjectName",
    			"parseFunction":"",
    			"skipIfEmpty":false
    		},
    		{
    			"fromFIN":"Address",
    			"toFIN":"SendToAddress",
    			"parseFunction":"",
    			"skipIfEmpty":false
    		},
    		{
    			"fromFIN":"Tax_x0020_Jurisdiction",
    			"toFIN":"TaxJurisdictionCode",
    			"parseFunction":"",
    			"skipIfEmpty":false
    		}
    	]
    });
    in reply to: General DFFS enhancement suggestions #16230
    avala
    Participant

    Thanks for making this a sticky post!

    If possible, I’d like the ability to restore a previous version of the DFFS configuration from the DFFS new/edit/display config page. I know we can use versioning in the SPJS-DynamicFormsForSharePoint list to restore a previous version, but I’ve had a few occasions where I’ve been in the config page and wished I could revert from there after testing a change.

    in reply to: Redirect to Edit form error #16149
    avala
    Participant

    Had to revert to our former solution since the one above kept refreshing the page too quickly and made the form look broken.

    I ended up placing a rule on a Yes/No dsropdown field that our On Creation workflow would update as its last step. On Form load, if this field was still “No,” the rule would hide the form tab and show a tab with some HTML and a loading .gif. This custom refresh function reloads the page after 25 seconds.

    
    
    function customReloadPage(){
    setTimeout("window.open(self.location, '_self');", 25000);
    }
    in reply to: Redirect to Edit form error #16145
    avala
    Participant

    Wow, that is WAY BETTER than what I was building. THANK YOU! The only improvement I would make is to customize the refresh time. Having the page reload 10 times makes it look broken.

    The BETA release also fixed the issue we had with the DFFS Installer not working in 2010. This is HUGE. All combined, the redirect feature, ReloadPage function, and installer package will save us 1-2 hours of deployment time per project!

    • This reply was modified 7 years ago by avala.
    in reply to: Redirect to Edit form error #16141
    avala
    Participant

    The Beta works perfectly in 2010 and does not require

    SPUpdatePage = function(){};

    Now I just need to figure out how to prevent the user from editing the form until the workflow has finished. Thanks, Alexander! When do you anticipate the DFFS production files will be updated?

    in reply to: Redirect to Edit form error #16125
    avala
    Participant

    I’ve added the above script to the custom JS tab. The button does submit the form and close the page, but it returns to the list view (default behavior).

    in reply to: Inline Editing #16107
    avala
    Participant

    Figured it out. Code to “toggle” a value in a vLookup column is thus.

    Custom JS tab

    
    
    function updateChildExample(a,item){
    	return "<span style='cursor:pointer' onclick='doUpdateChildExample(this,\""+item.get_item("ID")+"\")'>Update</span>";
    }
    
    function doUpdateChildExample(elm,id){
        var statusVar = spjs.utility.getItemByID({"listName":"TF Attendees","id":id,"viewFields":["Attendance"]});
            if(statusVar.Attendance == "Attended"){
                var attendVar = "Absent";
            }else if (statusVar.Attendance == "Absent"){
                var attendVar = "Attended";
            }
            
    	var res = spjs.utility.updateItem({"listName":"TF Attendees","id":id,"data":{"Attendance": attendVar}});
            if(res.success){
                $(elm).replaceWith("<span style='font-size:16px;color:green;font-weight:bold;'>✓</span>");
            }else{
                $(elm).replaceWith("<span title='"+res.errorText+"' style='font-size:16px;color:red;font-weight:bold;'></span>");
            }
        }

    vLookup column configuration
    Paste in the ID column

    {"function":"updateChildExample"}
    • This reply was modified 7 years ago by avala. Reason: removed alert from code
    in reply to: Inline Editing #15860
    avala
    Participant

    See attached image for how the vLookup table looks. This table is automatically populated ahead of time.

    One person, the meeting leader, updates the form throughout the meeting. In this instance, they mark each attendee as “Absent” or “Attended” as needed throughout the meeting. This means they would update multiple rows in the vLookup table per session.

    This script halfway works; I’m sure I’m missing something obvious. The first condition will alert correctly and update the vLookup value correctly. The second condition will alert correctly, but not update the vLookup value. This holds true if I switch conditional values or use an “Else” instead of “Else If” statement.

    It would be nice if clicking the link refreshes the vLookup table, but is not necessary.

    
    
    function doUpdateChildExample(elm,id){
        var statusVar = spjs.utility.getItemByID({"listName":"TF Attendees","id":id,"viewFields":["Attendance"]});
        alert(statusVar.Attendance);
        
        if (statusVar="Absent"){
            var attendVar= "Attended";
        } else if (statusVar="Attended"){
            var attendVar= "Absent";
        }
    	var res = spjs.utility.updateItem({"listName":"TF Attendees","id":id,"data":{"Attendance": attendVar}});
            if(res.success){
                $(elm).replaceWith("<span style='font-size:16px;color:green;font-weight:bold;'>✓</span>");
            }else{
                $(elm).replaceWith("<span title='"+res.errorText+"' style='font-size:16px;color:red;font-weight:bold;'></span>");
            }
        }
    • This reply was modified 7 years, 1 month ago by avala. Reason: minor text fix and new image
    in reply to: Inline Editing #15807
    avala
    Participant

    I’ve been traveling so no worries on the timing. Is there a way to get this to work on a dropdown field with just two values?-
    Never mind, this seems to work already. 🙂

    A couple new points.

    1. Is it possible to get the vLookup table to refresh after clicking the link?
    2. Is it possible to use one special configuration column to evaluation the value of Attendence field and, based on value currently in the field, use an if, then to toggle the value?

    For Example if Attendance field = Attended, clicking the link changes it to Did Not Attend and vice versa.

    • This reply was modified 7 years, 1 month ago by avala.
    in reply to: Inline Editing #15368
    avala
    Participant

    That’s great news! I may need your help on where to get started with that.

    in reply to: Inline Editing #15267
    avala
    Participant

    This is the #1 request I receive from users with DFFS vLookups. Excited for a potential release.

    In the meantime, is there a way to use the “delete button” solution in vLookup to update a child field from the parent? We have an attendance section in a few forms that users really just want to click a button to mark attendance from week to week.

    in reply to: Trying to install the installer #13287
    avala
    Participant

    Alexander,

    I did some testing and it looks like a IE Doc Mode 8 issue.

    I did a fresh install in a new SP 2010 and got the same error as described above. When I did a test in SP 2013, the installer worked correctly. Looking at the Dev Console I see our 2013 environment sets the document mode to 10. When I switched to IE 8 Document mode I received that same error as the 2010 sites. See below screenshots.

    in reply to: Trying to install the installer #13274
    avala
    Participant

    I’m having the same issues as Christine across all forms, lists and libraries. Image 1 shows the error while the file path name for the library and DFFS folder are correct (/sites/gwjayme/Sandy/SPJS/DFFS/js/DFFS_frontend_min.js). Receiving similar Console errors on all three forms in image 2.

      Environment:
      SharePoint 2010
      IE 11
      Document Mode 8(Default)
      User agent String IE 11 (Default)
      OS: Windows 10
    in reply to: Reload vLookup query based on parent field change #12765
    avala
    Participant

    Version info below.

Viewing 15 posts - 1 through 15 (of 64 total)