Restricting selection of members belonging to a business division

Question

HiI have a list of business divisions (business divisions table) within an organization like, 'Large Projects', 'Innovation', 'Small Projects', 'Government Projects' etc.There is a employee master (employees table) where in each employee is mapped against a business division. One division can have multiple employees linkedThere is a need to create new project(projects table) for a division  and select an employee for the project. While selecting the employee (a linked field in projects table pointing to employees), is there any way to restrict the employees that are belonging to the business division selected (a linked field in projects table pointing to business divisions table)If there are any alternates please suggestThanksSri

ScottWorld · Accepted Answer

Unfortunately, this is one of the biggest and most frustrating limitations of Airtable that users have been requesting for 10 years.

That will give you an idea of how responsive Airtable is to their customers’ requests. 🙄

However, this can be done with one of these external tools:

Fillout or Noloco

Sri1 · Answer

Thanks a lot Scott for the confirmation and alternates, it helpsThanksSri

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded