Lookup or Formula Field in a Form

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)

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 

The Single Select could be an option actually - just the single select is going to be REALLY long. Good idea though!

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