I have created a Softr form which creates new records in the “Jobs” table of my Airtable database but I got stuck with an important UX problem. To provide some context:
- The “Jobs” table comprises of various fields including the Location and the Job_Type fields, which are linked to the “Company_Locations” table and the “Job_Types” table respectively.
- The records of both the “Company_Locations” table and the “Job_Types” table include a “Company” field, which is linked to the “Companies” table.
- Each User belonging to the “Business” user group belongs to a “Company”; the Company field is part of the Users table and is linked to the “Companies” table.
- The Softr form prompts the User to select the Location and Job_Type from a dropdown synced with the datasource which is mapped to the corresponding fields in the Jobs table.
Problem: I’d like to hide the Location and Job_Type dropdown options which are not associated to the Company of the User that is filling in the form, so that the User won’t be able to see the Location and Job Type created by other users from other companies. Basically, I’d need to conditionally hide some dropdown options depending on which user is filling the form.
I have been trying to search around but it seems like not possible to do it with the existing Softr features. Do you know if there is any NoCode workaround?
Thank you for your replies in advance!