Forms Designer Forum

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?

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.

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

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.