Forum Replies Created
-
Posts
-
Hi,
I’m not able to recreate the problem where a vLookup table number field shows the “raw” data with 10 digits. Can you send me some screenshots of your config?Regarding documentation for vLookup:
No, there is no separate documentation. The user manual shows some examples for vLookup – like how to get the list of items when the vLookup table has loaded. I’ll try to find time to update the documentation in the user manual with more information.Regarding available functions you can use in Custom JS:
There are less built in functions you can access in the Modern DFFS version compared with the Classic DFFS version. This is because it is built as an SPFx solution using React, and the source files are not exposed in the global window-namespace.The functions that are available are listed in this forum thread (linked from the user manual Custom JS section): https://spjsblog.com/forums/topic/custom-js-examples/
In addition you can – as you mention – use any custom code you write yourself interacting with other SharePoint lists using the REST API.
Regarding triggering rules from custom js:
The latest version (v1.0.65.0) added a new trigger in the rules section where you can create a rule that can be triggered from Custom JS. Please note that you cannot trigger any rules, but only the ones configured with this trigger.Alexander
Hi,
I’m not able to recreate this issue – can you please email me some screenshots of your configuration so I can try to replicate it?Alexander
The problem with the new UI is entirely up to Microsoft to fix. They have not added support for field or list customizers in the new IU yet, and they have therefore disable it for all lists where a field or list customizer is present.
Microsoft are working on it, and when they are ready I’ll make any changes necessary to make the Modern DFFS work in the new UI.
When that is said, there is no way to only activate the modern DFFS in some lists.
Just send me your requests by email and please include some business cases that I can prepare for a future demonstration.
Alexander
There is no functionality built in to select multiple child items and do “something”, but you can do that using Custom JS.
If you migrate to the Modern DFFS, vLookups must be reconfigured (you cannot import the config from the Classic version) as the configuration is different. The Modern version uses REST API and not CAML queries.
Alexander
When you check the “Show a totals row below the vLookup child table” checkbox all columns that can be counted or summed will be included unless you exclude them in the “Special configuration” field like this:
{"showTotals":false}You can find this configuration example by clicking the contextual help icon after the “Show a totals row below the vLookup child table” field.
To have a prefix on the sum for a column you must use the parameter “totalsPrefix” in the “Special configuration” as shown in the contextual help.
The “Grand total label” is only used when you group the vLookup table and use the “Show a grand totals row below the grouped items”.
I’m not sure I understand what you mean by “build a vLookup with multiple values”, but you can have more than two filter conditions if you use the “Write your own CAML-query” textarea to construct you own query.
You can find information on how to write a CAML-query by searching the web, but please note that it is only the Where-part that is used here – like this:
<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>The value to search for</Value></Eq></Where>
Alexander
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
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
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
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
When using spjs.utility.queryItems you are only supposed to use <Where>…</Where> in the query part – not <Query><Where>…</Where></Query>
Alexander
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
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"); }
