Search Results for 'list form'

[Sarah O]

Hi Alexander,

I’d like to redirect the user to our homepage instead of the default list when a form is saved or cancelled. I tested the following codes in the custom JS tab on all forms and I am still being redirected to a list instead of the intended URL. (used google URL for confidentiality purposes). Can you please take a look at the codes I’m using for any errors?

function dffs_PostCancelAction() {
location.href = “https://google.com”;
}

function dffs_PostSaveAction() {
location.href = “https://google.com”;
}

Currently operating on the following versioning of DFFS:
Dynamic Forms for SharePoint v4.4.5.27 – July 30, 2023
CSS version: 4.51 / 4,51
spjs-utility version: 1.356
Loader version: v2

[Jon Whisman]

Hello again!

Is there a pre-built function I can leverage that I can use to run a custom JS function only AFTER the DFFS overlay has gone away?

I have a function that is doing the below, but I’m having to put a setTimeout on it to wait some time because the form is not fully rendered yet.

Purpose of code: In the edit form: auto click the “Add New Folder” for the users. This form heavily relies on DFFS vLookup documents functionality.

window.console && console.log(“Now attempting to Auto create folder and expand folder”);
spjs.vLookup.initAddNewFolder(“vLookupAttachments”);
spjs.vLookup.addNewFolder(“vLookupAttachments”, jQuery_documentationList, “/sites/siteName/SubSiteNamen”);

[Wendi Watson]

Hello Alexander,

I have noticed when I use the time field that the time on the record in the SharePoint list is different than the time on the form. I tested this to make sure it was not a setting on my SP site and it does not seem to be so I am wondering if it is in the DFFS code? I am attaching examples for you to check.

Attachments:

1. Time-From-DFFS-EDIT.docx

[Alexander Bautz]

I got this excellent tip (thanks Michelle) that can hide the original form and show a message to the user if DFFS hasn’t completed loading before the user hits either the New item button or tries to view or edit an item.

This is done through the standard “List formatting” functionality – see this link for details on how to open the configure layout panel: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-configuration

Add this to the header

{
    "elmType": "div",
    "style": {
        "margin-bottom": "100vh",
        "padding": "20px 15%"
    },
    "children": [
        {
            "elmType": "div",
            "attributes": {
                "class": "ms-fontColor-neutralSecondary ms-fontWeight-bold ms-fontSize-24"
            },
            "style": {
                "box-sizing": "border-box",
                "width": "100%",
                "text-align": "left",
                "padding": "21px 12px",
                "overflow": "hidden"
            },
            "children": [
                {
                    "elmType": "div",
                    "txtContent": "The Modern DFFS is not ready. Please wait a few seconds after a page load before you click to open the form."
                },
                {
                    "elmType": "div",
                    "style": {
                        "margin-top": "20px"
                    },
                    "txtContent": "Close this panel and try again."
                }
            ]
        }
    ]
}

Add this to the body

{
    "sections": []
}

See attached image.

Alexander

Attachments:

1. 

   image_2023-07-27_104621611.png
   

[Alexander Bautz]

There is no way to allow for simultaneously editing by multiple users in a SharePoint list item.

I don’t think locking the form to one user when multiple users is supposed to work on it at the same time will work for your users (they would be fighting for access and will sit and refresh the screen to see when it is unlocked).

From my point of view, the only way to make this work is to split the information out in separate lists.

Alexander

[Alexander Bautz]

1. You can use the vLookup functionality in the Classic DFFS and the Modern DFFS (see page 13 or user manual) versions to connect the responses to each project record, but this will not show in a list view – only when you click into DispForm or EditForm or a project record.

2. No, this is unfortunately not possible. If two users open the same record for editing the user who saves last will get a save conflict and cannot save the changes.

Alexander

[Marcus Khoo]

Hi Alexander,

Overview

My form defines a “mapping” between a source “property” and a destination “property”
A property will belong to an “Entity”
An Entity will belong to an “Adapter”

My lists

List 1 is called “Adapters”. There are 17 items in this list.

List 2 is called “Entities”. It has a lookup column in it that looks up the Adatpers list and returns the “Title” of the adapter. There are 100 items in this list
A custom JS on this second list concatenates the Entity Name and the Adapter iname
into a text field called “EntityAdapter”

List 3 is called “Properties”. It has a lookup column that looks up the “£ntities” list and pulls back the “EntityAdatper” field from the second list (i.e. NOT the Title). This list also has a column called “DataType” (just a choice column). There are 560 items in this list.
A custom JS on the third list concatenates the DataType-Property-Entity-Adapter in single column

List 4 is called “Mapping”.

Column 1 (source entity/Adapter) is a lookup to “Entities” and allows me to pick an Entity-Adapter combination. It pulls back the column “EntityAdapter”

Column 2 (source property) is the one I am trying to filer. It is a lookup to the “Properties” list and pulls back the DateType-Property-Enty-Adapter column. I need it to filter on the “EntityAdapter” column

Column 3 (destination entity/adapter) is also a lookup to “Entities” and allows me to again pick an Entity-Adapter combination from the field “EntityAdapter” on the Entities list (i.e. I am not pulling the Title field).

Column 4 (destination property) i ALSO need to filer but this one needs to filter on column 3. It is a lookup to the “Properties” list and pulls back DataType-Property-Entity-Adapter. I need it to filter on the value in Column 3

Hope this makes sense
Best regards
/Marcus

[Marcus Khoo]

Just a thought, would it be possible to load in a “light” version of the list set extension that just disables the existing standard form mechanisms and then waits for the real DFFS to load? If DFSS has not yet loaded, the “light” version could give a link which, by the time it is displayed will have loaded DFSS?

[Marcus Khoo]

Hi Jorah, thanks for the tip but my users need to access the forms from SharePoint lists using the standard SharePoint “New, Edit, Open” functions.

🙁

[Alexander Bautz]

I have tested changing the time zone in the SharePoint site to another time zone than I have on my computer and this gives me the same problem as you describe. Please note that changing the timezone has a delay before it takes effect so that might be the reason you didn’t see any change.

The reason for this issue is that SharePoint automatically “corrects” the time to use the UTC format when saving it in the database – and then formats the date to the correct time zone when showing the date in a list view or a form.

I’ll look into it and hopefully be able to fix this in the upcoming release (hopefylly during this weekend).

Alexander

[Michael Sabby]

When the users enter a date in a date field in the DFFS edit form what is saved to the SP list is different. This occurred with both version 1.0.26.0 and with 1.0.27.0. I have 4 examples where the dates were saved as 6/30/2023 between 8:52 and 9:34 AM UTC/Pacific time zone and all 4 records wrote to SP with a date of 6/29/23 and a time of exactly 10:00 PM. I tried changing my time zone on the SP site setting to Central at the suggestion of a peer and the behavior is still occurring. Any suggestions on how to solve the issue?

[Alexander Bautz]

The modern DFFS is designed to work for the following listBaseTemplate id’s:
100, 101, 103, 104, 105, 106, 107, 150, 170, 171 and 1100.

The very first versions (before 1.0.3.0) only worked for listBaseTemplateId 100 (custom list). I’m wondering if you should completely uninstall and reinstall it to see if it may register correctly.

Configurations for your forms will not be affected by uninstalling and reinstalling as they are stored in a custom list in the site.

Alexander

[Jorah Lavin]

Alexander, I’m working with 1.0.26.0, and I’m seeing odd behavior that I haven’t fully nailed down as to when I see it, nor possible triggers. One is that sometimes when I’ve created an item and am back on the list view, refreshing the page launches a New Item form again. It seems that sometimes just visiting the form, without having created, viewed, or edited an item, the New Item dialog opens with no prompting.
-=-
The other behavior seems to have started with my switch from 1.0.22.0 to 1.0.26.0. When opening New, View, or Edit forms that have been working fine, the form is completely empty. It acts as if all fields are hidden. I’ve found a simple solution, which is to write a rule saying ‘on form load, show element: (and put the row ID in the element field)’. It’s an easy fix, but it’s not something we’ve ever needed previously.

I’m hoping that by sharing on your forum, someone else who may have seen the behavior might be able to give more detail.

[Aglika Tilev]

Hi Alexander,

we have updated the .sppkg to the latest version, but we can see the DFFS button only in the banner of lists, but not in libraries.
Can you advise how we can enable the forms for doc-libs as well?
Thank you.
Aglika

[Alexander Bautz]

Thanks,
The URL looks OK so I’m still not sure what could cause it.

Are you using the functionality where the form should open as a side-panel in a list view, or are you using the web-part-page-webpart to create a form that you can link to?

If you have any more information you can email it to me – you can find my email address in the About me tab in the top of the page.

Alexander