[Alexander Bautz]

Hi,
I’m happy to hear you like DFFS!

Can you share a screenshot of the configuration for your vLookup field?

Enabling inline editing in vLookup is possible, but requires that you use Custom JS. You can find some examples here: https://spjsblog.com/2019/08/31/vlookup-inline-editing-examples/

You will find other forum threads also if you search the forum for “inline editing”.

Alexander

[Alexander Bautz]

If your site is using https you must specify the baseurl using https if you specify the full url. In any case you should have it as a realative url like this:

"listBaseUrl": "/teams/XYZ",


It looks like the format of the code is a bit mangled so I’m not sure if there is anything else wrong.

Alexander

[Alexander Bautz]

The functions listed at the top of the page is about it. Is there anything specific you are looking for?

Please note that to interact with other SharePoint list you can use any JavaScript code that uses the REST API.

Alexander

[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 7 months, 1 week ago by Alexander Bautz. Reason: Fixed code snippet
• This reply was modified 7 months 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

[Author]

Posts