Skip to main content
Solved

How to update visibility of form fields, given boolean values from another table

J

First using airtable but profecient in Python, SQL and some JavaScript/Vue3.js for house needs. I dont consider this a "complex problem", but havent been able to crack it in Airtable env. only.

I have a scenario where i want to dynamically control form field visibility based on "boolean" values from another table. I am aware that form defaults to communicate with one record at a time given the table it belongs to.

I have a table named "application" and another "analysis" and fieldsnames are generally the same. once "application" has a PDF file attached, analysis makes a "lookup" and a python script executes 16 rather complex regex patterns and saves the output as boolean values, could be "1 or 0", "yes or no" and "ja or nej".

From the analysis output, the idea is/was to use these booleans as a condition to manage visibility and nothing else. Because, as you can see in the bool_update_flow.png attachment, the users are to upload specific images.

If it is, can i utilize a JavaScript in order to accomplish this scenario? If so, some pointers to the correct documentation to do so.

I am wondering, if it would be easier to seperate it differently, and they first form would stop after "upload" and then the next form will come on a new page, with the updated 

the overall flow:

TBL(Application) ---> "name, surname, mail, upload PDF file" --> TBL(analysis) --> extract text patterns as booleans --> TBL(Application) show relevant fields.

Any help would be valued, thanks heaps!

Kind regards,

Jannik

 

Best answer by ScottWorld

@JMangabat 

This is not possible with Airtable's forms. You would only be able to do this with Fillout’s advanced forms for Airtable, as long as you have a linked record field on your form that links to the appropriate record in another table (i.e. the record where you will be pulling your boolean values from).

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update visibility of fields based on linked records in other tables, the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, and so much more. 

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

View original
2 Attachments
Did this topic help you find an answer to your question?

5 replies

ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Inspiring
  • 8693 replies
  • Answer
  • January 3, 2025

@JMangabat 

This is not possible with Airtable's forms. You would only be able to do this with Fillout’s advanced forms for Airtable, as long as you have a linked record field on your form that links to the appropriate record in another table (i.e. the record where you will be pulling your boolean values from).

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update visibility of fields based on linked records in other tables, the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, and so much more. 

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Expert Airtable Consultant at ScottWorld.com
J
1 person likes this
  • J
    JMangabat
J
  • JMangabat
  • Author
  • New Participant
  • 1 reply
  • January 3, 2025
ScottWorld wrote:

@JMangabat 

This is not possible with Airtable's forms. You would only be able to do this with Fillout’s advanced forms for Airtable, as long as you have a linked record field on your form that links to the appropriate record in another table (i.e. the record where you will be pulling your boolean values from).

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update visibility of fields based on linked records in other tables, the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, set advanced field validations & limitations, and so much more. 

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld


Thank you very much for this clarification, much appriciated!
I give it a deep dive and go in that direction instead.

Happy new year !

ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Inspiring
  • 8693 replies
  • January 3, 2025

Glad I could help! Happy New Year! 🙂

Expert Airtable Consultant at ScottWorld.com
TheTimeSavingCo
Forum|alt.badge.img+18

Hmm, try putting a helper field into the forms table, and then prefilling it with a formula field? 

For example, the two fields in the screenshot below would be '1' or '0', 'Yes' or 'No' like you mentioned:

And this would the forms table:

The 'Prefill formula' field outputs the following links, in order:

Show show: https://airtable.com/appXXkadOzcua5LcS/pagdFoAscTG09qPK6/form?prefill_Fields+to+display=Field+1%2CField+2%2C

Show Hide: https://airtable.com/appXXkadOzcua5LcS/pagdFoAscTG09qPK6/form?prefill_Fields+to+display=Field+1%2C

Hide Show: https://airtable.com/appXXkadOzcua5LcS/pagdFoAscTG09qPK6/form?prefill_Fields+to+display=Field+2%2C

Link to base

---

And so after extracting the text patterns, you could get an automation to email the prefilled link to the user so that they could upload the requried documents

Adam, Consultant @ The Time Saving Co
ScottWorld
Forum|alt.badge.img+20
  • ScottWorld
  • Inspiring
  • 8693 replies
  • January 4, 2025

I would not recommend that approach, as it requires consistently creating new form links to send to people whenever the data changes, and if the people accidentally use an old form link, then they would be getting outdated information.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Expert Airtable Consultant at ScottWorld.com

Reply


Most helpful members this week

Terms & Conditions