Formulas in Forms


#1

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?


#2

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.


#3

I will look into prefilling. Thanks!

Is this something that might get implemented down the road?


#4

+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.


#5

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