Question

Hide Lookup Value if already used

Hi,

Is there a way to hide a lookup value within a specific page if that value has already been used on another record? I want to to ensure that a lookup value is not selected more than once. Alternative solution could be stopping the user from selecting it again.

 

thanks

Like 0

Like

1 comments

I have resolved this by creating a column on Look up which gets updated when a record gets added/updated and that lookup values selected/removed. Then used filter to only display values in lookup accordingly.

Show all comments