Forum Replies Created
-
AuthorPosts
-
Marcus KhooParticipant
Sorry, this is the question I meant to ask.
I have already created DFFS forms and they mostly work fine.
I have 40 lists and hence 120 DFFS forms
I can only add the JSON formatting suggested in this post, to the “original” SharePonit form.
How do I access the original form in order to put the JSON formatting in place when everytime I open the forms now I get the DFFS form?
Is there a quick way to temporary “disable” the DFFS form so I can add the JSON to the “original” form?
Thanks
Marcus KhooParticipantThis is a brilliant work around.
How do you easily get back to the original form though when there ARE DFFS forms defined?
Thanks
Marcus KhooParticipantHi Alexander,
Yes, all fixed for me. Many thanksMarcus KhooParticipantI’ll try to build a document for you over the weekend.
No errors – just no options in the “child” field
Best regards
/MarcusMarcus KhooParticipantHi 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 columnList 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
/MarcusMarcus KhooParticipantIt used to work but seemed to get some issues a way back and I was getting throttling messages. Then I decided to remove that funtion to keep going with my project. I have just revisted it and it no longer gives me throttling messages but unfortunately the “child” lookup shows blank after selecting a value in the “parent”
Marcus KhooParticipantJust 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 KhooParticipantHi Jorah, thanks for the tip but my users need to access the forms from SharePoint lists using the standard SharePoint “New, Edit, Open” functions.
๐
Marcus KhooParticipantGood find! Thanks Alexander. Great work here.
Best regards
/MarcusMarcus KhooParticipantReporting back:
I did get it working with
Title eq ”But I then get a message:
“There are no items matching this query”Marcus KhooParticipantI tried your Filter idea but it seems like vLookup always is epecting something –
otherwise it just shows a spinning disk forever..
๐Marcus KhooParticipantWonderful news about the new release too. ๐
Marcus KhooParticipantGood idea!
Marcus KhooParticipantStrangely I can’t repeat it now! Shelve it for the time being and I’ll report if I see it again.
Thanks AlexanderApril 14, 2023 at 08:30 in reply to: Strange effect using vLookup and EDIT with multiple colums #36678Marcus KhooParticipantPS no custom css
-
AuthorPosts