Skip to main content

We have an Airtable form to submit internal orders, and it would be very helpful for our team to have a field that shows the last record number before filling in a new order. Not to create the order number – we have autonumbers set up – this is because they have to add the current PO to one of the files that gets submitted in the form itself. Right now they’re going and checking the latest order number in the normal Airtable view before submitting the form, but if they can cut that step out it would be helpful!

Is there any way to add in a view-only or read-only field?

I looked at trying to integrate the interfaces with forms too and that didn’t quite get what I was going for.

Thank you!

Airtable doesn’t offer this feature, but you can do this with Fillout’s advanced forms for Airtable.

In your case, you would need to add a linked record field to the customer's record (which could be a hidden field), and then you can display a rollup field or a lookup field based on that linked record field which would show the latest order information.

Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Hi all, I know this is an old thread, but for those of you still looking to create an alternative 'readonly-like' field, but don't want to use third party forms like Jotform (don't get me wrong, they DO have their place), you could try the 'dummy' field option.  That is, create a new Airtable single line or long text field that contains the required data and display the that text field data in a separate form field with the appropriate 'READONLY' warning, and just don't use the data from that form field... it's readonly so your intention is that the back-end won't change on form submission.

I know this is inefficient and wasteful, but so is waiting for Airtable to create a 'readonly' form field.

If you find users are changing the 'readonly' form field and getting confused by the results, ie their fiddling doesn't change the form submission outcome, you might be able to sell them some training 😊

I use this method for displaying calculated summaries, as well as displaying calculated serial numbers, etc.

Happy coding...

Hi everyone!

At miniExtensions, we built a third-party form specifically designed to integrate with Airtable. Our form allows adding read-only fields, ensuring that specific information remains visible but uneditable for users.

 

Terms & ConditionsAccessibility statement