[Alexander Bautz]

Hi,
Yes, vLookup will still work in the forms, but if you use the “modern list views” displaying the vLookup field in the list view will not work.

What kind of problem are you experiencing?

Alexander

[Alexander Bautz]

The callback from “vlookupChildAddedCallback” does not have any information about the form it return from, but you can use “vlookupAddChildPreCheck” to keep track of it – like this:

var current_vLookup_fin = "";

function vlookupAddChildPreCheck(fin){
    current_vLookup_fin = fin;
    return true;
}

function vlookupChildAddedCallback(){
    if(current_vLookup_fin === "vLookupTasks"){
        // The fin is vLookupTasks - do shomething
    }
}

Alexander

[Alexander Bautz]

Hi,
I’m not able to recreate this issue. Can you give me some more details?

I did fix a similar bug in v1.0.41.0 – are you sure this site has the latest version?

Alexander

[Alexander Bautz]

Thanks for the feedback – I’m glad you got it fixed.

Alexander

[Alexander Bautz]

The “This field has been deleted or is not in the current content type” message most likely means that the field is not in the content type you are currently using.

Go to List Settings > Advanced Settings and ensure Allow management of content types is set to “Yes” (if it is No you must turn it on temporarily, but can change it back to No again after this procedure is done).

Now you can go back to list settings and under “Content types” click on the content type you want to address (most likely “Item”).

If the Title field is not shown you can click the “Add from existing site or list columns” at the bottom of the list of fields and under “List columns” find the Title field and add it to the content type.

When this is done you can turn off handling of content types again if it was initially set to “No”.

Alexander

[Alexander Bautz]

The license information is validated by reading the license file from my AZURE tenant. Does the user not have internet access on the computer where the form is used?

If they have, it might be a temporary network / AZURE issue that resolves itself. If they do not have internet access you can contact me to get a license code that is validated without having to read the license information from AZURE.

If they can see the DFFS configured form they have the necessary rights to the SPJS document library.

The error does not prevent saving the form data.

Let me know if you have any further questions.

Best regards,
Alexander

[Alexander Bautz]

Hi,
You must pass an unique value from the “parent” to the “child” when creating the new item, and then use this value to filter the records to only show the items created from this “parent”.

See this setup example: https://spjsblog.com/vlookup-for-sharepoint/vlookup-setup-example-for-sp-2010-and-2013/

Alexander

[Alexander Bautz]

Hi,
v4.4.1 is from 2016 so you won’t have the latest version features.

You might be able to upgrade to the lates version, but I cannot guarantee that this will work when you upgrade from a 8 year old version.

To do a proper upgrade, you must delete the DFFS folder in your SPJS document library and upload the new version of DFFS.

This will not affect your configurations as these are stored in a separate list.

When you have uploaded the new DFFS version and configured the DFFS installer you must uninstall and reinstall DFFS in the forms for your list.

If this works you are good to go, if not you must downgrade the DFFS version and try to do a step by step upgrade a few versions at the time (you must open the config and save it in each version to ensure you apply the features from this version) – not sure how this will work out as you have such an old version…

Let me know if you have any questions.

Best regards,
Alexander

[Alexander Bautz]

The only way to do this if you don’t want to use the built in method is to have a query that runs pre-save to check for duplicate values. This is pretty straight forward if the list does have to many items. If you exceed a few thousands items, the query would slow down the save process because it has to wait for the query to return.

Basically you can use something like this in your custom js:

function dffs_PreSaveAction(){
    var res = spjs.utility.queryItems({
        "listName": _spPageContextInfo.pageListId,
        "query": ""+getFieldValue("Title")+""
    });
    if(res.count > 0){
        spjs.dffs.alert({
            "title": "Duplicate value",
            "msg": "An item with this title already exist, please change the value and try again.",
            "ok": function(){
                // Close dialog
            }
        });
        return false;
    }
    return true;
}

Alexander

[Alexander Bautz]

I’m glad you figured it out.

Alexander

[Alexander Bautz]

Sorry, but I don’t have any method of overriding this message as it is a built in message in the out-of-the-box sharepoint.

Alexander

[Alexander Bautz]

Hi,
Can you show me the rest of the configuration under the “Render field as autocomplete search box” – are you sure you have the same setup in NewForm as you have in EditForm?

Alexander

[Alexander Bautz]

It might be a similar issue related to using an underscore – try changing the name of the _vLookupParentID field to not start with an underscore (you must delete it and recreate it without the underscore) and see if that helps.

Alexander

[Alexander Bautz]

No problem – I forgot a little quirk when using a field that starts with an underscore in a rest filter – you must prefix the field name with OData_ like this:

OData__vLookupParentID eq '[[fieldValue:_vLookupID]]'

Alexander

[Alexander Bautz]

The filter value must be in single quotes like this:

_vLookupParentID eq '[[fieldValue:_vLookupID]]'

Alexander

[Author]

Posts