Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Support Formula, LOOKUP and ROLLUP fields in Public Form Views

cancel
Showing results for 
Search instead for 
Did you mean: 
Tech_Tylercivic
7 - App Architect
7 - App Architect

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.

27 Comments
Katherine_Duh
Airtable Alumni (Retired)

Currently, we don’t show calculated fields in form views because the person filling out the form can’t actually directly input data into those fields. Do you have a particular use case in mind for showing formula/lookup/rollup fields in a public form? If so, we’d love to hear it!

Tech_Tylercivic
7 - App Architect
7 - App Architect

Can you see the example I sent Alex?

Katherine_Harkn
6 - Interface Innovator
6 - Interface Innovator

This is a feature I would very much like to see. My base is for a library, and I fill in the forms on the fly as people hire things out. At the moment I’m having to swap between the forms and the base to get the information I need to fill out the form. This means I can’t ask the users to fill out the forms themselves.

  1. In my Hires form, I select a user and a thing to hire out. Each user has a calculated status as to whether they already have something hired, in which case they can’t have another, so I would like this displayed. Similarly, each item has a suggested deposit. When I select an item to hire, I would like the suggested deposit displayed so I can then fill in how much I’m actually charging. Also, when I enter the return date it calculates the hire fee. At the moment I have to fill out the whole form then go back to the base to look up the hire fee.

  2. In my Returns form, I select a hire that is being returned. I want to display the expected return date so I can calculate any late fees, and display the deposit left so I can return it.

These are my main examples.

It seems to me you’re thinking of forms only as basic data collection, where really they could be so much more.

Arlo_Haskell
7 - App Architect
7 - App Architect

Hi Katherine, I too would like to see calculated fields in form views. Here’s one reason why:

We sell tickets to an event on a deposit/balance model. People register for the event with a minimum deposit payment of $100, then pay the balance a few months later.

In the grid view, I use formula fields to calculate the balance that each customer owes. This allows our staff to review the balance due, answer the customer’s questions, determine if they’ve overpaid/underpaid, etc.

Because the financial transaction data in this table is so important, I am very wary of how easy it is for staff to accidentally delete records in the grid view. So I’ve set up a form view to be able to record payments without the risk of deletion. But without being able to see the results of our “balance due” formula, staff is unable to answer questions from the customer, or issue any necessary refund or remaining-balance-due statement.

Zach_Sipes
4 - Data Explorer
4 - Data Explorer

Unsure if there was ever a resolution to this. I am looking for similar functionality of having visible lookup fields in a form view. I am making an order form for materials and would like to be able to reference pricing information that has been saved in a product database. In the edit form view this information appears if you test the item number field, but in the shared form or preview form this information is not visible. Even if the information was visible like in this screen shot in the shared form that would be greatly beneficial.

lookup-form-view.JPG

Zach_Sipes
4 - Data Explorer
4 - Data Explorer

This second image is the view in the shared form. Notice how there is no “lookup” field information visible within it.

lookup-form-sharedview.JPG

Sarah_Filipiak
5 - Automation Enthusiast
5 - Automation Enthusiast

Yep, I have the same problem. I need users to be able to input hours worked on a client job, but they only see the job number, not any info associated with it. With more than 1200 jobs to choose from, there is no way they can memorize job numbers. Please help!

Get_Off_My_Ice
4 - Data Explorer
4 - Data Explorer

I would like to use Airtable as a cost estimate calculator for custom prints (i.e. posters). The user would enter the size of the poster and select the type of paper they want it printed on, and the calculator would display an estimated cost for the print. I have already built a small, working version of the calculator database using Airtable. If Airtable could display the result of Formulas in Form view, I could integrate this calculator into my webpage and use Airtable to make quotes, and take/track orders. It would put Airtabe at the center of my workflow.

I work for another company that has used Airtable with great success for the past year. We depend on it to take orders, track production, and maintain a delivery schedule. Airtable has helped to automate a lot of the workflow, but this same lack of functionality is creating a bottleneck in the quote process.

An Airtable-integrated method for automating quotes would be very helpful. This could be accomplished if Airtable was capable of displaying non-interactive fields (such as formula results) in forms. I think it would open Airtable up to a whole new set of applications and expand the potential customer base. The company I work for already pays for Airtable, and I would purchase it for my business if it could do this.

Toni_Nolasco
4 - Data Explorer
4 - Data Explorer

I can give you more feedback as to my particular situation, I work in the elevator filed, I am using Airtable for manage my agent, when they are in form view they add the id device, but they have to able to see the others field, like “addres”, “client name” etc…

SGR
4 - Data Explorer
4 - Data Explorer

It could be a “read-only” field, because it’s for informational purposes, as I see in the previous requests. I do need this too, for the people who is filling the form could verify the information.