Hello,
I’m trying to restrict the options available in a Grist form according to the access rights of the connected user.
Specifically, I have a Properties table and a Parcels table, where each parcel is linked to a property. When creating a parcel via a form, I’d like the user to be able to select only those properties to which he has access (rights defined in an Access table with Mail and Authorization_Level columns).
Is there a native method for filtering the values of a reference field in a form according to these access rules? Or do I need to use a custom widget?
Thanks in advance for your help!