Skip to main content

Formulas in Forms


Forum|alt.badge.img+2

I was trying to make a form that was sort of an order form and my formula field with the total cost of the items wasn’t on my form. I had no way to add it.

I tried on a form for another table that was similar and it didn’t work there either.

Is this not currently supported?

Forum|alt.badge.img+3

It is not possible to display formula fields on your form.

But Airtable does provide you with an API which you could use to link a “custom” form to your base.
On this custom form you could then display the total cost of the items etc.

By “custom” form, I mean a form built using Java, .NET, PHP etc.

You might also want to look into prefilling a form, to prefill the total cost of the items

Check this out.


Forum|alt.badge.img+2
Andrew_Johnson1 wrote:

It is not possible to display formula fields on your form.

But Airtable does provide you with an API which you could use to link a “custom” form to your base.
On this custom form you could then display the total cost of the items etc.

By “custom” form, I mean a form built using Java, .NET, PHP etc.

You might also want to look into prefilling a form, to prefill the total cost of the items

Check this out.


I will look into prefilling. Thanks!

Is this something that might get implemented down the road?


Forum|alt.badge.img+3
  • Participating Frequently
  • October 12, 2018

+1 I would highly support being able to show calculated fields as well as look up fields on forms. This would really enhance the forms feature to another level.


Forum|alt.badge.img+9

Seems incredibly silly not to be able to show formula fields on a form. I really wish they would add this as a feature!


Forum|alt.badge.img+9

Throwing my vote in for this!! A big feature of many form apps is the ability to do a quiz or calculator especially outgrow which charges crazy pricing for it.


Forum|alt.badge.img+1

+1 for adding this feature :thumbs_up:
It would be great to be able to make a registration form where the multiple attendees could be added to the same form and be able to have a formula field at the bottom which identifies the price for the group.


Forum|alt.badge.img+2

This is a must! It’s the only thing I need on my form, otherwise I have to change back to another creator… Again. Any ideas when this is coming?


  • Participating Frequently
  • January 16, 2020
Andreas_Dalen wrote:

This is a must! It’s the only thing I need on my form, otherwise I have to change back to another creator… Again. Any ideas when this is coming?


Hi @Andreas_Dalen, check out https://beenform.co. lt prefills your custom form with data from airtable.


Forum|alt.badge.img+13
  • Participating Frequently
  • January 15, 2025

Our miniExtensions form can display formula fields when editing existing records, and also when creating new records using the "Save & Continue" functionality. You can try this out using a free account now! 🙂 

 

Airtable's form doesn't have this feature, since it doesn't support reading data from the record, which is needed to display formula fields.


Reply