Allow formula fields to be included in forms


#1

Trying to build a solution for our staff and a field that is the result of a formula calculation would REALLY be helpful. Currently calculated fields are not included on forms. I think this feature would add great value to Airtable, as it would allow people to build invoice forms with live feedback of costs.


Fields don't automatically populate
Support Formula, LOOKUP and ROLLUP fields in Public Form Views
#2

Yes! This would be a great addition.


#3

Yes please include this feature. For example, someone could fill in a form saying that they want to buy something for $2 and another item for $5 and the form could state that the total cost will be $7.


#4

Thanks for the feedback! As you’ve discovered, we don’t currently display calculated fields (formula, lookup, rollup, count, and autonumber fields) in our forms. This is something we can consider for the future, though! Note that we recommend that any base collaborators with edit access use our expanded record view instead. It has a form-like layout, and users will be able to view any calculated fields!


#5

Yes…I also desperately need that feature!


#6

The expanded record view doesn’t help those of us that have Public Facing forms where the user does not have access to the Airtable (and shouldn’t). It’s helpful too for those of us trying to get a better search function out of integrations like Zapier.


#7

I am shocked this isn’t a “feature” yet. There’s this and some other seemingly basic “features” that may have us move off Airtable. Is there any update to this?


#8

Another cool application of this idea would be the ability to include hyperlinks generated by formulas that take the data entered in the form and convert it into a specific web address. Also could be used to generate specific Mailto links based on data entered.


#9

This is definitely be a feature that I would like to use, and would love to see implemented.


#10

Please! This would be very helpful and a powerful feature of forms. +1 for this feature.


#11

+1 for this one too. I would like the person to enter a date that must be between two calculated dates. Since there is no possibility to validate the entry, it would be great to at least display the date boundaries, or even display a thumb up if the date input is OK. THanks


#12

I’m considering implementing this feature for FormNano
Anyone interested in providing requirements and feedback? Let’s work together to make this possible. Contact me via the FormNano contact form and mention you’re from the AirTable community.