Depending on how complicated your formula is will make this trickier!
The simplest solution would be to use a bunch of "Single Select" fields as empty text boxes. You can do this by configuring the options to "show field as a list" with no options. Then "Show field only when conditions are met", based on your formula's conditions.
However, if your formula is more complicated with combining and looking up more details, you may have to build a whole system for submitting data using Interfaces etc
Hi @Travis_Groom1,
Have you tried the dynamic filter, which is a paid plan-only feature?
This is set in the field, not in the form settings.
Dynamic filtering in linked records (airtable.com)
Hmm, I think the problem we're trying to solve is the fact that the data doesn't really exist yet when you're filling it out in the form, and as a result lookups and formulas can't exist either?
I feel like the only way you could get those details in is if you created one field per department and put the department specific information inside that field's help text within the form. You could then conditonally display the correct field based on the department they selected
All of the features that you are looking for are possible with Fillout’s advanced forms for Airtable.
Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including 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, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more.
If you can’t use a 3rd-party app, then I would just use conditional hiding on your form to show or hide additional fields that have large blocks of helper text as instructions.
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
Depending on how complicated your formula is will make this trickier!
The simplest solution would be to use a bunch of "Single Select" fields as empty text boxes. You can do this by configuring the options to "show field as a list" with no options. Then "Show field only when conditions are met", based on your formula's conditions.
However, if your formula is more complicated with combining and looking up more details, you may have to build a whole system for submitting data using Interfaces etc
The Single Select could be an option actually - just the single select is going to be REALLY long. Good idea though!
Hmm, I think the problem we're trying to solve is the fact that the data doesn't really exist yet when you're filling it out in the form, and as a result lookups and formulas can't exist either?
I feel like the only way you could get those details in is if you created one field per department and put the department specific information inside that field's help text within the form. You could then conditonally display the correct field based on the department they selected
Actually, I think this is the right callout. It would exist after they picked the form choice - but wouldn't exist prior to that so AirTable likely doesn't allow it since it doesn't technically exist yet.
I somewhat solved it using "description" in each of the groups under the form - not quite ideal but it works.
Our miniExtensions form displays lookup fields as soon as a linked record is selected! You can also use formula fields when editing existing records, or when creating new records using the "Save & Continue" functionality. You can try all of this out using a free account now! 🙂
