[Hao Wang]

Ok. I already bought a site collection license for the modern version of the DFFS. We will rewrite our own app and retire the SP app using the old version of the DFFS soon. You showed me how to put the JavaScript in the Custom JS editor window, which is better than putting it in the HTML snippet. We had thought that Custom JS did not work at all. Thanks.

[Hao Wang]

Alexander, thanks. I recreated the installer, installed DFFS on a new list, and then imported your config. How you configured it works by including the script in the editor window of the Custom JS tab.

Instead of pasting the JavaScript into the Custom JS editor window, I used the text area above to include my script as a file, and the file path verified OK. It stopped working.

I included your inline editing script as a file; it works there. I am curious what is going on.

Hao

By the way, how can I recover the production license installed by SP Services? While I tried to recreate the classic installer, the message of the trial period appeared in the configuration window for the new test list. The old lists still work with the production license.

[Hao Wang]

Alexander; it is embarrassing that my site now lost the ability for us to create a new list and install the classic DFFS. The column type DFFS Loader by SPJSBlog.com is now missing from my site. Creating a column with that name won’t bring up the configuration I need. Any advice on how I can bring that configuration back? Thanks. Hao

[Hao Wang]

I suspect it is the script loading issue, though we handled your inline editing Javascript in the same manner, and they work!

[Hao Wang]

The sample Javascripts I sent you in those Txt files were used as the “entire” custom JS codes, yet we cannot call the functions in them from a button or a rule. You are right; they were not in the global window namespace. We tried to modify the function definition using a window.XXX, it did not work either. Thanks though. Now they are running in my embedded HTML sections, so we are okay with that.

[Hao Wang]

I tried many ways. I tried using button clicks to call functions, entering the function name in a tab that allows me to run on clicking on the tab, and calling the function(s) in the rules “when the form is ready…” They all said that, in one way or another, the functions were not defined or found. There were no logs after I plugged in some console.log inside the scripts. These were when I put the files in the Custom JS and verified the paths were good.

However, the inline editing javascript you wrote ran seamlessly when I put it there. I scratched my head and believed I must have missed something.

Thanks for helping.

[Hao Wang]

Here are the scripts in txt files.

Attachments:

1. sampleScriptOne.txt
2. sampleScriptTwo.txt

[Hao Wang]

Thank you, Alex. I have attached two simple scripts. Neither worked in the Custom JS section, but both work if I include them in an HTML snippet.

For now it works for me but it would be better if we can put them in Custom JS instead of HTML sections.

Hao

[Hao Wang]

Thanks. My code worked in the HTML snippet, so I am set for now. However, when I put in the Custom JS, it fails to run for unknown reasons, probably due to the timing issue. When I call the functions, it says they are not defined yet. I tried delay, polling, or window.onload, none worked.

[Hao Wang]

Thank Alex. I figured.
I am new to DFFS, so I have built a separate SharePoint page to accomplish all that. In the future I will leverage DFFS styles and functions to make it nicer.

[Hao Wang]

Thank you, Alex. Your tips on “show totals” and “totalsPrefix” are correct, and they are working as expected.

I will give the CAML query a try. I want to list not only Child items but also related items, such as the Child’s cousin items. For example, if I want to book tickets on the same flight, I want to list not only my children but also their friends and cousins. It is like Column eq ‘Child’ or Column eq ‘Friends” or … As long as I can pass dynamic contents to CAML-query, it will work for me. Thanks.

By the way, when I have a child list, may I put a checkbox next to each child item so that I can select a subset of children to proceed to the next step?

I appreciate you created this tool. I hope the migration to the modern version works as well, if not better. Best.

[Hao Wang]

BTW, I want to build a vlookup with multiple values, for example, ID = 1 or ID =2 or ID =3, or Title in {one; two; three}. is it allowed? I could not find the config route to build a query with dynamic variables.

[Hao Wang]

Thanks I will check out the posts.

Here are my config screenshots for the vlookup.

Attachments:

1. 

   Screenshot-2024-08-08-at-2.58.24 PM.png
   

2. 

   Screenshot-2024-08-08-at-2.58.37 PM.png
   

3. 

   Screenshot-2024-08-08-at-2.58.54 PM.png
   

[Author]

Posts