Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Simple Conditional setting not working for Lookup field?

Topic Labels: Data Formulas Views
771 1
cancel
Showing results for 
Search instead for 
Did you mean: 
halffrozen
5 - Automation Enthusiast
5 - Automation Enthusiast

I am attempting to make a Travel Sheet my Supervisors access through a Form view, that allows the selection of Employees (linked from our Employee Table) based on their current Employment Status (which is a dropdown selection on the other table). When I select the "Only include linked records from the Employees table that meet certain conditions" and have it to where: Employment - is - "Current Employee", however when the form is being previewed, the selection is pulling all employees, regardless if they're past or current. I have also tried the same conditioning filtering for Projects as well based on their "Status" as well, and it also doesn't work on filtering only what I want it to show. What am I doing incorrectly, as this seems like it should be a very basic and simple conditional request?

 

Thank you for your time.

1 Reply 1
Zack_S
8 - Airtable Astronomer
8 - Airtable Astronomer

I would setup a view that filters employees by their current employment status. Then in the form you can 'limit record selection to a view'


Zack_S_0-1693593975975.png