Support Formula, LOOKUP and ROLLUP fields in Public Form Views

[Tech_Tylercivic]

Right now these field (column) types are not supported for public form views. This would be a very handy feature and could eliminate the necessary of another software platform.

[Mario_Esquivel]

Hi, Im also interested in this feature. We just need a read only field, so when we choose from the record link, we re sure we are picking the right one.

[Nick_Bergthold]

This feature would be very very useful. Is there any implementation for this or known workarounds?

[Benjamin_Watrin]

I need this too! This would allow my customers to have an estimate before they actually submit the form. Any update on this?

[Megan_Bishop]

For expense forms, I need this capability greatly! For example, a person fills in their total mileage for reimbursement, and then I want them to be able to see that they will be due a certain amount of money, as per what their mileage is. And I also want them to be able to see their total expenses at the bottom, for say their mileage, their tolls, taxi receipt, etc. Seems like a pretty simple feature that most other form platforms have…

[Gonz]

There is another Feature request entry (allow formula fields…) where I described a specific use case with date input

[Moe]

We’ve built a solution that kind of solves this problem

miniExtensions

Formula Fields in Airtable Forms - miniExtensions

Include calculated fields in your forms. Show your customers their input results instantly. Allow form users to review their record data right away.

[Moe]

Update
We now have built our custom form for Airtable. It does support all types of computed fields including: formula, lookup and rollup.

miniExtensions

Formula Fields in miniExtensions Form

Add formulas inside your form. e.g. calculate total or generate a URL. Let your customers see their input's results immediately.