Dynamic CSL in quick edit

Discussions about Forms Designer for SharePoint 2013 / 2016 and Office 365.
Locked
Office365Guy
Posts: 21
Joined: Sun Feb 24, 2019

16 Apr 2019

We have a related items control in quick edit on the edit form of the parent. One of the columns is a cross site lookup. The lookup only needs 0 to 9 & a to z. As the each item is selected we would it to be unavailable for the next row in the related items.

The first row might have a user input of "Floor 1" and the CSL would be selected to "1"
The second row might have a user input of "Floor 2" and the CSL would be selected to "2". As the "1" was selected in the first row we would like it to not be available for use in the second row and so on.

Is this possible in any way?

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

17 Apr 2019

Hi!

Each time Lookup field is opened, the code in Request items is executed, you can do pretty much anything with it - get other field values, use them in requests, etc.
Screenshot_141.png
Screenshot_141.png (12.92 KiB) Viewed 2573 times

Caddes
Posts: 1
Joined: Wed Apr 24, 2019

25 Apr 2019

Do you have to modify that code depending on the use case at all, Alex?

User avatar
AlexZver
Posts: 232
Joined: Mon Aug 27, 2018

26 Apr 2019

Dear Caddes,

In most cases, the default advanced pre-settings of Cross-Site Lookup are enough, you can choose a lookup list and a displayed field in the standard settings and that's it, it works out-of-the-box. But if you want some custom adjustments, the advanced settings instrument allows you to implement pretty much anything.

Locked
  • Information
  • Who is online

    Users browsing this forum: No registered users and 11 guests