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

[JMangabat]

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

[ScottWorld · Accepted solution]

@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

[JMangabat]

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]

Glad I could help! Happy New Year! 🙂

[TheTimeSavingCo]

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%2CFi...

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

[ScottWorld]

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