Help

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

Form to edit data

cancel
Showing results for 
Search instead for 
Did you mean: 
Katherine_Harkn
6 - Interface Innovator
6 - Interface Innovator

At the moment the form only allows input of new data. Can we have a form for editing existing records? At the moment we can only edit in the table meaning I can’t present the records the way I want. Can’t even hide columns on mobile, meaning the users are free to wreak havoc on the existing data :grinning_face_with_smiling_eyes:

163 Comments
Amos_Rendao
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 on this feature request to allow forms to input data into already existing records

It’s brutal that I would have to use Zapier and make additional automations across multiple services to achieve this.

Thanks for listening to the community!

Sabrina_Merlo
4 - Data Explorer
4 - Data Explorer

I am working with senior execs from 2 dozen organizations on a field strategy project. I have a set of data on each of their organizations that I need them to review and update. This is NOT data a junior person can edit. I also want them to only edit their org’s data and not see or experience the others’.

If I send these senior folks a form and ask them to fill it out, they will roll eyes and be annoyed. It will not get done.

If instead I sent them a form with fields at least partially complete with data we have FOR THEM TO EDIT they will 1) feel respected and 2) actually make the edits. Their attitude about engaging in the whole project will be different.

ScottWorld
18 - Pluto
18 - Pluto

You can create a pre-filled form in Airtable, and give everyone a different link to their own personalized pre-filled form. This excellent app from @kuovonne even helps you create the form URL: Prefilled Forms - Apps - Airtable Marketplace.

However, Airtable forms only ADD new records, so you would have to create some sort of automation afterwards (either through Airtable’s Automations or through an external automation tool like Integromat) to actually do the updating of the original record.

Alternatively, many people prefer to use MiniExtensions, because you are literally editing the actual record through a form, with no additional steps needed:

p.s. If anybody needs help setting any of this up, and you have the budget to hire a professional Airtable consultant, please feel free to contact me through my website at scottworld.com.

Samir_Ghosh
6 - Interface Innovator
6 - Interface Innovator

I’m baffled that this still does not exist after hundreds of requests and many years.
Simple implementation: For an existing form with URL, let users pass a parameter (e.g., record ID) which simply loads default data into the existing Form (so uses can a. customize, and b. share externally). Obviously, you need to add Update instead of Create on the backend in that case.

$40/mo to an external party (miniextensions) for such a core (CRUD) capability seems unreasonable.

Derek_Footer
5 - Automation Enthusiast
5 - Automation Enthusiast

100% agree, this is such an obvious need to implement.

Nadege
4 - Data Explorer
4 - Data Explorer

I simply cannot believe that this has STILL not been implemented. How many comments are you going to need to actually DO IT ?
I mean, don’t get me wrong, I LOVE AIRTABLE.
But as said numerous times in here, there is a strong NEED for “editable form” view, customizable (i.e. not only row after row, but with possibility to put several fields per line, etc…).
This is what Stacker does but it’s slow and painful.
Stackby is rising, simply because of this and I cannot believe I am now looking for solutions to export my Airtable bases to Stackby, juste because of that. Some of the users of my tables are high level users, and the table view is simply too complicated for them at some stage.
Don’t let people leave Airtable because of that ! Do something !

Nadege
4 - Data Explorer
4 - Data Explorer

Nope :slightly_smiling_face: This just prevents people from editing some fields but it’s not related to a specific view of the data.

Jack_P
6 - Interface Innovator
6 - Interface Innovator

Katherine could you not use an automation with the Find Record & Update Record function to do this?

The form could link to the original record ID, you can make a copy of all fields (It could be another Table or a bunch of hidden fields), the Automation would then use the Find Record function to link to the original record, and Update Record to update each field with the new information from the form?

itoldusoandso
10 - Mercury
10 - Mercury

Suggest Airtable has a place for links and profiles to 3rd party products as there are a number of sites I have seen with list of apps for Airtable.

Even this page https://builtonair.com/resources/?cat=product doesn’t have more than a fraction of what I have seen recently floating around as the number has grown over short period of time and the Airtable Marketplace doesn’t seem to cover more than the Airtable apps and the github apps.

Fabrizio_Nastri
4 - Data Explorer
4 - Data Explorer

MS Access forms are a good example of how view/edit forms should look like, but Access is tedious to build. Ninox (nionx.com) does it perfectly right. I would love it if Airtable had the same feature as Ninox when you can build a form in a couple of minutes by simply drag/drop fields around. Such forms are easy to build and give the ability to view/edit data in a nice customized layout.

Airtable is nice for simple datasets (~10 columns). But when you have lots of colums they don’t fit on a screen any move (neither in the grid view, nor in the exanded view). When you have more fields, then customisable forms is an absolute necessity. We need to have all the information for a given record visible on screen, in a structured and compact form, with view/edit capability.