Restricting selection of members belonging to a business division

[Sri1]

Hi

I 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 linked

There 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 suggest

Thanks

Sri

[ScottWorld · Accepted solution]

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]

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

Thanks

Sri