Search Results for 'list form'

[BenR]

Alexander,

Hello – I hope you are well.

I would like to create a Cascading Menu, where on Tier-1, a specific item is forced to the bottom of the list.

I have about 50 items, for which an Alphabetic list is great, however, I have one item – “Other” – which I would like to force to the bottom of the list… How can I do this? The client does not accept a character in front of the value to force it to do so.

What can I do to sort all items alphabetically and yet force this one item, Other, to the bottom of the list?

As always, we appreciate your support and efforts!

R’grds – Ben.
Reference:
Version information
Custom DFFS-folder: DFFS_v4.4.5.35_2021-10-31
DFFS Loader: v2
DFFS frontend: 4.4.5.35 – October 31, 2021
DFFS frontend CSS: 4.64 /
Autocomplete: 1.6.52 – April 25, 2021
Cascading dropdowns: 3.7.48 – September 22, 2021
jQuery: 1.12.4
Lookup: 1.1.20 – March 10, 2020
Resource management: 2.4.5 – August 29, 2019
SPJS-Utility: 1.354 – October 15, 2021
vLookup: 2.2.162 – October 12, 2021

[Tricia S.]

Hi Alexander,

Is there a way for me to load the overlay over the form?
I have a second Edit form that I want to to use the rules to set fields and then save.
I’m then using the Sp list formatting/gallery view to create checkbox that is a hyperlink. This works a lot better than an approve button/using a flow.
The only issue I’m having is that it is a little awkward with the overlay/form load.

This is what currently happens:
1. User Click on the hyperlink to the 2nd edit form.
2. User sees overlay.
3. The form flashes for a second.
4. The form closes and saves.

This is what I would like to happen:
1. User Click on the hyper link to the 2nd edit form.
2. User sees overlay.
2A. The form/rules run in the back without showing anything to the user.
3. Overlay closes user is returns to list view.

Lastly I will note that “Defer loading of DFFS” is set to 500ms. Without it the form will overwrite Peoplepickers as blanks. This is just for your informational awareness, no issues there, but unsure if it will affect as possible solution.

Any help to smooth this out would be much appreciated!

Attachments:

1. 

   Hyperlink-Tile.jpg
   

2. 

   Single-rule.jpg
   

[Harsh]

I come across scenario where i need to get ID to saved item from new list when spjs.dffs.triggerSave() event fire.

I need item id so i can call some rest api calls in to lists, how can it possible to call function after form save with item ID?

[Alexander Bautz]

This is a “classic” SharePoint problem where values are stored in the DB as UTC and shifted based on the regional settings when you view them in a normal list view or form. In this chart you are showing the raw db value.

I’m not 100% sure, but try formatting it as “date” in the chart config – it might help.

Alexander

[SteveE]

Are you sure you have the link set up correctly? It should be in your DFFS setup folder. Mine is in https://mysite.sharepoint.com/SPJS/DFFS/vLookup_ListView.html. That’s the link you have to add to the content link in your CEWP.

Then you have to add the vLookup column to the view so that it knows where to show the information.

[Phil Grant]

Hi,
I’ve noticed an issue with a date field, the listview shows the date as entered (left side of attached image) but the table view shows the date one day earlier and it is the same whether formatted as a date or a string.

Cheers
Phil

Attachments:

1. 

   Table-view-date-mismatch.png
   

[Phil Grant]

Can I get a better understanding of viewing vLookups in list views.
Should it be possible to see the child data when viewing the OOTB SP2019 moder list view of a the parent list? the information in the manual does seem to indicate that you can.
I’ve added a CEWP linked to the “vLookup_ListView.html” file (t wasn’t in the CEWP folder) and made sure the “Tabular view” option was selected but I don’t see any of the cild data in the standard list view.

Have I misunderstood anything?

Cheers,
Phil

[Alexander Bautz]

You can use the Misc tab Save and redirect functionality to save and redirect to EditForm, but I think a validation function will be better.

You can use this custom js to check that the selected value is unique:

function checkUniqueId(fin){
    var res = spjs.utility.queryItems({
        "listName": _spPageContextInfo.pageListId,
        "query": "<Where><Eq><FieldRef Name='"+fin+"' /><Value Type='Text'>"+getFieldValue(fin)+"</Value></Eq></Where>",
        "viewFields": ["ID"]
    });
    if(res.count > 0){
        spjs.modal.add({
            "title": "Not unique",
            "html": "The value in the field " + spjs.dffs.fieldData[fin].disp + " is not unique, please correct and try again.",
            "ok": function (){
                setFieldValue(fin, "");
            }
        });
    }
}

Add this button in a HTML section below the ID field to let them validate the ID manually (replace YOUR_FIELD_NAME with the actual internal name of your field):

<input type="button" value="Verify that this ID is unique" onclick="checkUniqueId('YOUR_FIELD_NAME');return false;">

It could also be attached on “blur” of the field if you like an automated method – in that case you skip the button, but add this to your custom js below the checkUniqueId function:

jQuery("#dffs_YOUR_FIELD_NAME input[type=text]").on("blur", function(){
    checkUniqueId("YOUR_FIELD_NAME");
});

Replace YOUR_FIELD_NAME with the actual internal name of your field.

Alexander

• This reply was modified 3 years, 7 months ago by Alexander Bautz.

[Phil Grant]

Hi,
Is it possible to change the background colour of a field in a vLookup list on a parent form based on it content i.e. red background if the value is “No” and Green if “Yes”?
I know you can give some “Special configurations” code to the field in the vLookup config but I don’t know if you can include If/Then statements?

Cheers,
Phil

[Phil Grant]

Hi,
I have used an HTML header to create a table to summarize some information for a record and I would like to to display a list of items from a vlookuptable linked to the record. This works fine when I use a normal field in a tab and it loads the child records but I would like to include the child data inside an HTML table.

Is this possible?

Cheers,
Phil

[Alexander Bautz]

Hi,
This is often caused by someone copy-pasting the HTML code of another DispForm into a rich text field in this list item.

I have tried to work around this problem in v4.4.5.31 on September 22, 2021.

If you don’t already have a later version installed you can try updating your DFFS version.

Alexander

[Travis Goodman]

Hello,

I can’t say it was any change you made in the last version, because this is something I only just now noticed. I have over 100 lists with DFFS, and I just upgraded to your new version. The version I was using before I upgraded is this: Dynamic Forms for SharePoint v4.4.3.64 – March 13, 2019|CSS version: 4.46 / |spjs-utility version: 1.332

So it could have been introduced in any version in between those. I just happened to notice it on this list. I haven’t upgraded all my lists to the new version, so I’ll follow up if I see it on any other lists.

[Alexander Bautz]

Hi,
The callbacks unfortunately only work in a form – not when used in list views. If you use variables you must include those in a CEWP in the list view.

Keep in mind that vLookup in a list view only work in classic view because you cannot add custom code to a modern list view.

Alexander

[Jonathan Stamper]

I’m looking to implement my vLookups to a view and I have 3…

• Document library that uses global variables in custom JS to generate the file path
• 2 lists that use the ID field for delete/send email buttons on the forms only

A couple questions I wanted to get your expertise on:

1. How or can I use the vLookupIsLoadedCallback function in the list view (script or CEWP) to kick off hiding the ID fields that are used for the buttons on the form? Or do I need to utilize the setTimeOut?
2. Since the document library references custom JS variables to create the folder structure what’s the best approach to recreating those variables on the list view or should I also bring in my custom JS file in a CEWP?

Hopefully those all make sense and thank you in advanced!

[Alexander Bautz]

Hi,
I looked into it and there is an issue with “The form is ready” rule – it is actually not triggered last if it is not placed as the last rule (highest index).

This is a bug that I think must have been introduced a long time ago – not actually sure which version I could have broken this in.

In any case I’ll get it fixed and release a new version later this weekend, but you should be able to work around it by moving the “The form is ready” rules to the bottom of your list of rules.

The rules triggering on user group membership does not reverse – if you look at the debug output it is marked as non-reversible (No reversing of this rule: true), but I’ll mention this in the contextual help also.

Alexander