Skip to main content
Solved

Show / hide field based on condition

  • May 27, 2020
  • 6 replies
  • 270 views
C
Forum|alt.badge.img+5

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

Best answer by ScottWorld

2025 Update: Airtable now offers conditional hiding of fields on interface detail pages, but only if you pay extra to upgrade to a Business or Enterprise plan.

————————————-

ORIGINAL RESPONSE:

Welcome to the community, @Crispin_Giles!

  1. Conditional hiding & showing of fields is only possible on a form, which always creates new records in your base. If you want to edit existing records, you would need to create additional views or interface pages — each one only showing the fields you want to see, 
  1. However, a great option for you might be to use Fillout’s advanced forms for Airtable because it allows you to conditionally show or hide fields on the form — and it lets you either create or update existing Airtable records via a form.

    Fillout is 100% free, and I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

    - Using Fillout to create an eSignature approval process with PDF file creation
    -     Using Fillout to create an order entry form with line items.

    Even better, Fillout also offers tons of other features that you can’t get with Airtable’s native forms, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
     
  2. Alternatively, for something even more advanced (i.e. a full blown app that supports conditional hiding), you can turn to a 3rd-party portal for Airtable.

    The most popular portals that are currently available for Airtable are:
    Noloco, JetAdmin, Softr, Pory, Glide, and MiniExtensions.

    I gave an entire one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.

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! 🙂

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld 

6 replies

ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9808 replies
  • Answer
  • May 27, 2020

2025 Update: Airtable now offers conditional hiding of fields on interface detail pages, but only if you pay extra to upgrade to a Business or Enterprise plan.

————————————-

ORIGINAL RESPONSE:

Welcome to the community, @Crispin_Giles!

  1. Conditional hiding & showing of fields is only possible on a form, which always creates new records in your base. If you want to edit existing records, you would need to create additional views or interface pages — each one only showing the fields you want to see, 
  1. However, a great option for you might be to use Fillout’s advanced forms for Airtable because it allows you to conditionally show or hide fields on the form — and it lets you either create or update existing Airtable records via a form.

    Fillout is 100% free, and I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

    - Using Fillout to create an eSignature approval process with PDF file creation
    -     Using Fillout to create an order entry form with line items.

    Even better, Fillout also offers tons of other features that you can’t get with Airtable’s native forms, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
     
  2. Alternatively, for something even more advanced (i.e. a full blown app that supports conditional hiding), you can turn to a 3rd-party portal for Airtable.

    The most popular portals that are currently available for Airtable are:
    Noloco, JetAdmin, Softr, Pory, Glide, and MiniExtensions.

    I gave an entire one-hour webinar on Noloco called Building a Client Portal on Noloco powered by Airtable.

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! 🙂

p.s. If you have a budget for your project and you’d like to hire an expert Airtable consultant to help you with any of this, please feel free to contact me through my website: Airtable consultant — ScottWorld 

M
Forum|alt.badge.img+3
  • mmmm
  • Participating Frequently
  • 5 replies
  • December 14, 2022

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. 

R
Forum|alt.badge.img+2
  • Rive
  • New Participant
  • 1 reply
  • September 21, 2023

With Kanban behaviors like collapsing there are controllers for field configuration, And filter conditions in the UI interface that hide columns in other views like grids.  How is the feature missing for Kanban views? 

This would be a huge help to our organization to avoid duplication of tickets for tracking of tasks that go through a long pipeline process (40-60 stages).  We have clear disciplines working on only a section of the process.  Complexity of ticket field population.  And encourage multiple disciplines beyond production to utilize Airtable. 

Our options are to either use multiple grouping fields for small view kanbans which cause a lot of empty fields and ticket entry complexity. Or duplication of tickets, where notes and history are lost for fast review.

O
Forum|alt.badge.img+10
  • OfficeOurs
  • Inspiring
  • 26 replies
  • October 23, 2023

Use Grid like a kanban!

Like @ScottWorld said, the solution here is to create many views with the appropriate hidden fields.

But you don't need to "manually" switch between them, you can make a next button that dynamically brings you to the next step (view) with the record already open.

 

 

IF({Onboarding Stage} = "1 - Client Info", IF(Service_type = "Workstation", "https://airtable.com/appBVZT7eTAiepPPu/tblr1h1OIqnW4JEui/viwdnipbPFUy78Len/"&RECORD_ID(), IF(Service_type = "Combo", "https://airtable.com/appBVZT7eTAiepPPu/tblr1h1OIqnW4JEui/viw5Smqwh1pgHJtR7"&RECORD_ID(), IF(Service_type = "Babysitting", "https://airtable.com/appBVZT7eTAiepPPu/tblr1h1OIqnW4JEui/viwLQirtl3CLJL7rE"&RECORD_ID()))), IF({Onboarding Stage} = "2 - Contract", "https://airtable.com/appBVZT7eTAiepPPu/tblr1h1OIqnW4JEui/viw3G2bvJB2D5HsnB/"&RECORD_ID()))

 

 @Yaron_Avramov can you mark this as a solution?

DougL
Forum|alt.badge.img+4
  • DougL
  • New Participant
  • 3 replies
  • February 4, 2024

Looks like they have since added the functionality in Interface Builder, but you have to be on the Business plan to use it. Shame on you AirTable! Please allow this necessary functionality on the Team plan.

 

 

CristianCG
Forum|alt.badge.img+15
  • CristianCG
  • Participating Frequently
  • 122 replies
  • October 18, 2024

Hi there!

To give you even more options to work with conditional fields, at miniExtensions, we've created a third-party form that integrates seamlessly with Airtable. With our form, you can create individual or grouped conditions to show or hide fields based on the values of other fields. Plus, with our versatile Save & Continue mode, you can calculate formula fields and use them to control field visibility as well!

You can calculate the formulas manually before submitting the form or periodically every few seconds:

Feel free to try out these features with a free account on miniExtensions 👍


Terms & ConditionsAccessibility statement