[Steve]

Thank you Alex for the explanation.
I have deployed the solution on the dev tenant and it works.
Looks very nice.
Steo

[Steve]

Oh, I am sorry then. Do you use Modern DFFS on SharePoint 2019? It does not work for me unfortunately.

[Steve]

Hi Tony, don’t you have to allow in the “Site collection features” / “site features”?
Steo

[Steve]

Hi Alex,
when uploading the.sppkg to App Catalog, I am getting this error:
Sharepoint 2019.

• This reply was modified 2 years, 5 months ago by Steve.

Attachments:

1. 

   error.png
   

[Steve]

Now I have the data source set as described:
1Level – Provoz
2Level – Brno
3Level – Other|Construction Work
4Level – Under 100|Over 100 and under 500

So I had to duplicate it, but for each option I needed I made a new list item:
Provoz – Brno – Other – Under 100
Provoz – Brno – Construction Work – Under 100|Over 100 and under 500

The solution described in the second paragraph works.
I think there is no other way, how to do it with no “duplicates”?
Thank you Alex for your advice.
Steo

[Steve]

Hi,
yes, you were right. As I said, I was trying to do something else all the time than to use the basic functionality of cascading dropdown. For the explanation, I send some pictures, how I figured it out. Thank you so much.

I have also understood the description when the vLookup column is type of vLookup.
FieldInternalName/Property – I got it!

Steve

Attachments:

1. 

   Solution.jpg
   

[Steve]

Hi Alex,
that’s perfect solution for deleting child items in the parent folder, but I’d like to ask you how to delete the parent folder. I’m also sending the attachment where you can see the folder and child item inserted. When I click on “Smazat” it’s asking me if I am aware of deleting the item – I press OK and the child item is deleted.
But, I’d like to delete also the parent folder.
Would you help me with that?
Thank you
Steo

Attachments:

1. 

   Delete_folderparent.png
   

[Steve]

Hi,
it is OK. Thank you for your advice.
It’s working

Steo

[Steve]

Thank you, it works like a charm. As I can see, you often use your functions like spjs.dffs.utility – is there any documentation for SPJS-Utility functions and others?
Because some times I need to create an alert with some columns to be displayed for the user and do not know how to use it. And there are more cases in which I’d like to use the documentation.
Thank you,
Steo

[Steve]

One little thing to think about. I’ve already rated the product with the code “123” – then I went to the source list and changed the code to “12345” and I cannot rate because the product was already rated, but under a different “kod”. Is there a way how to get around that?
Thank you.
STEO

[Steve]

Perfect work! I used as a key the column “vyrobek” and it works perfectly. I hope it’s going to be okay. Thank you so much.

function dffs_PreSaveAction() {
    var searchVal = getFieldValue("vyrobek"); // Change field name to match your field here and in the query below
    var res = spjs.utility.queryItems({
        "listName": _spPageContextInfo.pageListId,
        "query": "<Where><And><Eq><FieldRef Name='Author' LookupId='TRUE' /><Value Type='Integer'>" + _spPageContextInfo.userId + "</Value></Eq><Eq><FieldRef Name='vyrobek' /><Value Type='Text'>" + searchVal + "</Value></Eq></And></Where>",
        "viewFields": ["ID"]
    });
    if (res.items.length === -1) {
        spjs.dffs.alert({
            "title": "Chyba v dotazu na výrobky",
            "msg": res.errorText
        });
        return false;
    } else {
        if (res.items.length > 0) {
            spjs.dffs.alert({
                "title": "Tento výrobek jste již hodnotil/a",
                "msg": "Tento produkt: \"" + searchVal + "\" jste již hodnotil/a."
            });
            return false;
        }
    }
    return true;
}

[Steve]

Hi,
Yes, you cannot, as “Alex”, add another 123-Apple if it already exists in the list created by your name.

Steo

[Steve]

You got it! 🙂
Yes, I was calling the function from a rule set to “form is saved”.
Thank you Alex for your time, I love DFFS more and more for its features that are necessary for some projects we build.

Thanks
Steo

[Steve]

This rule.
If the name in the data field is changed or filled, it should trigger the function.

Steo

Attachments:

1. 

   zadatelInfo_function.png
   

[Steve]

Here it is, I think my frontEnd version is OK, don’t you think?
See the attachment. I also attach custom code in the Custom JS section in DFFS.
Steo

Attachments:

1. 

   DFFS_version_customCode.png
   

[Author]

Posts