[Alexander Bautz]

Thanks, can you also explain how / when you trigger the functions?

Alexander

[Alexander Bautz]

Can you export your vLookup config and attach it as a txt file so I can look at it?

Alexander

[Alexander Bautz]

Without looking at the code I’m not able to give you any recommendations on how to fix it.

If you can attach the code as a txt-file I’ll take a look.

Alexander

[Alexander Bautz]

If you can show me the code you use I can have a look at it.

Alexander

[Alexander Bautz]

Strange. Are you sure you use the same field / same config in those two forms?

If you do, are there any errors in the developer tools console (F12 > Console)?

Alexander

[Alexander Bautz]

I tested with a user with no email and got the same error. I’ll get this fixed in the next release.

Alexander

[Alexander Bautz]

I tested your config and also changed to CZECH language, but cannot reproduce the error.

I think the problem can be that the logged in user does not have an email address in the user profile – could that be the issue?

You can check it by typing this in the console when you have the form open:

dffs_userProfile

Alexander

[Alexander Bautz]

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

[Alexander Bautz]

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

[Alexander Bautz]

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

[Alexander Bautz]

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

• This reply was modified 4 months, 1 week ago by Alexander Bautz.

[Alexander Bautz]

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

[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

[Author]

Posts