Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Show / hide field based on condition

Topic Labels: Formulas
Solved
Jump to Solution
2013 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey all

I have a table where I have many hidden fields. I want to have a field only visible if a certain condition is true. Is there some kind of IF statement functionality that can conditionally toggle between showing/hiding the field if certain conditions are true?

Thanks
C

1 Solution

Accepted Solutions

Welcome to the community, @Crispin_Giles!

Conditional hiding & showing of fields is only possible on a form, and then when the user submits that form, a new record will be created in your table.

Otherwise, if you’re not looking to create new records via a form, you would need to manually create different views where each view would be manually set by you to have its own set of hidden fields. And then you would manually need to switch back & forth between those views to see the set of fields that are on each view.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:

See Solution in Thread

2 Replies 2

Welcome to the community, @Crispin_Giles!

Conditional hiding & showing of fields is only possible on a form, and then when the user submits that form, a new record will be created in your table.

Otherwise, if you’re not looking to create new records via a form, you would need to manually create different views where each view would be manually set by you to have its own set of hidden fields. And then you would manually need to switch back & forth between those views to see the set of fields that are on each view.

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. If not, please let me know what else you need help with! :slightly_smiling_face:

hey this is MAJORLY needed to look at: major feature issue for not only share view but also interface designer!!!

you need to allow for the feature show only "current user" to be applicable to fields and or views. 

e.g. if i add a grid to an interface:
option1: show only view assigned to current viewer (best option)
option2: show only records by current viewer AND show only FIELDs for current user 

two ways to get the same thing. option one can mean only 1 time assign a user to a view -- OK --- or offer gird view options available to current user. best option: control permissions of which views (that the current user can see) you want available to that current user in that specific interface element)

you basically have the feature (see pics) but you did it for edit record permissions, specific filters. just make this for VIEWING permissions, by a view, with control on selected total views available in element.