[Alexander Bautz]

Thanks for the feedback – I’m glad you got it up and running.

Alexander

[Alexander Bautz]

Hi,
If you can show me the code you use, and tell me what kind of field it is I can show you how to trigger a change after you use setFieldValue.

Alexander

[Alexander Bautz]

When using spjs.utility.queryItems you are only supposed to use <Where>…</Where> in the query part – not <Query><Where>…</Where></Query>

Alexander

[Alexander Bautz]

Not sure, what kind of error are you getting?

Alexander

[Alexander Bautz]

I have fixed the error in the code (I mixed up the format of the returned data).

Alexander

[Alexander Bautz]

Hi,
I have confirmed this bug (saving a space) and will fix it in the next version.

To fix it you must open this list: /sites/your_site/Lists/DFFS_LICENSE

I suspect you have multiple items in the list – delete all and then add the license code again.

Alexander

[Alexander Bautz]

This function is supposed to be used like this:

var PreferredName = "your_variable_input";
var query = "<Where><Eq><FieldRef Name='Name' /><Value Type='User'>" + PreferredName + "</Value></Eq></Where>";
var camlViewFields = ["Reports_x0020_To", "Department", "Position", "Job_x0020_Title", "Hire_x0020_Date", "Perm_x0020_Date", "Status", "ADP_x0020_File_x0020__x0023_", "Location", "Company", "ADP_x0020_File_x0020__x0023_", "Sprout_x0020_Employee_x0020_ID"];
var TeamLeadr_str = "";
var res = spjs.utility.queryItems({
    "listName": "Staff Master List", // List display name or GUID
    "listBaseUrl": "/sites/site_name",
    "query": query,
    "viewFields": camlViewFields
});
if(res.count > 0){
    console.log(res.items);
}else{
    console.log("no items found");
}

• This reply was modified 4 months, 3 weeks ago by Alexander Bautz. Reason: Fixed code snippet
• This reply was modified 4 months, 2 weeks ago by Alexander Bautz. Reason: Fixed code snippet

[Alexander Bautz]

You would have to use the DFFS installer to uninstall DFFS. The configuration is not affected by the uninstall so if you reinstall DFFS in the form again, your configuration will pop back.

Alexander

[Alexander Bautz]

If you can show me the code you have written using spjs.utility I’ll help you get the syntax correct.

Alexander

[Alexander Bautz]

From what I have seen this will not affect Content Editor Web Parts that have already been added to a page.

This means that lists where DFFS has already been installed will not be affected, but installing DFFS to a new list will require that “scripting” is turned on in the site using the admin-center or PowerShell.

This setting will most likely be automatically reverted within 24 hours so in that case DFFS must then be installed on the new list in that 24-hour window.

Updating DFFS for lists that are already installed is not affected as this doesn’t require any modifications on the Content Editor Web Parts in the list forms.

This is the link to Microsoft’s article describing how to enable custom scripting: https://learn.microsoft.com/en-us/sharepoint/allow-or-prevent-custom-script

PS: The new modern DFFS version for SharePoint online is not affected – only the Classic version of DFFS.

Alexander

[Alexander Bautz]

You can use something like this:

var today = new Date();
var datePlusOffset = null;
var offset = 6; // The offset number of business days
var ticker = 0;
while(ticker < offset){
    datePlusOffset = new Date(today.setDate(today.getDate() + 1));
    let day = datePlusOffset.getDay();
    if(day !== 6 && day !== 0){
        ticker += 1;
    }
}
spjs.utility.setDateFieldFromDateObject("DateColumn1", datePlusOffset);

Alexander

[Alexander Bautz]

If the field starts with underscore you must prefix it with OData_ like this:

OData__DFFSID
OData__vLookupProjectID

Alexander

[Alexander Bautz]

No problem, use something like this

var today = new Date();
var datePlus6 = new Date(today.setDate(today.getDate() + 6));
spjs.utility.setDateFieldFromDateObject("Your_date_column_fin", datePlus6);

Alexander

[Alexander Bautz]

I referred to jQuery as the jQuery JavaScript library and not jQuery.SPServices so your setup should be OK.

I guess that the $ namespace (alias for jQuery) used in the SPServices library for some reason is not populated when jQuery is loaded. I have seen that SharePoint or other third party code uses the same namespace.

You can try adding something like this in the top of your Custom JS to fix it:
$ = jQuery;
I still recommend using the built in spjs.utility functionality linked in my previous answer instead of SPServices.

Alexander

[Alexander Bautz]

I forgot to mention that jQuery is automatically loaded with DFFS so you must not load it again – that can cause problems.

Alexander

[Author]

Posts