Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 14, 2020 06:00 AM
Hey yo
I have a simple use case,
I have an airtable form receiving submissions. I can see the submissions in grid view in the same table. But now I want to make changes to those submissions without changing the original submissions. How do I do that?
What I tried,
Creating sync table in the same base, but that doesn’t seem to be an option.
Help appreciated.
Solved! Go to Solution.
Dec 14, 2020 07:16 AM
Hi @Sachin_Mittal, and welcome to the community!
One word - Script. You need to establish a transactional log that secures the original version of the submission. You do realize that this is an underlying feature of Airtable, right? It versions every change.
Dec 14, 2020 07:16 AM
Hi @Sachin_Mittal, and welcome to the community!
One word - Script. You need to establish a transactional log that secures the original version of the submission. You do realize that this is an underlying feature of Airtable, right? It versions every change.
Dec 14, 2020 07:32 AM
Welcome to the community, @Sachin_Mittal!
If you need to make a copy of your original data, you can just create another table, and then copy & paste your data into that new table.
You can do this manually, or through Airtable’s automations, or by writing a JavaScript, or by using a no-code automation platform like Integromat.
Dec 15, 2020 01:09 AM
Thanks for getting back @ScottWorld,
That’s straightforward, but my DB keeps changing every hour. So, this solution is not feasible.
Dec 15, 2020 01:13 AM
Hey yo, @Bill.French
How should I do it, please share any example/ tutorial if you have one.
Airtable record versions, def but the problem is,
I want to add columns to that table, and when I add them to the table,
the column shows up in the airtable form as well. Changing the original form
that is fetching the data.
Dec 15, 2020 01:30 AM
That’s why you would automate the process, as I previously mentioned above.
Dec 15, 2020 02:50 AM
These are two very different questions. The former refers to the data submitted; the latter refers to the data elements being collected.
Is “it” the first requirement or the second requirement?
Dec 15, 2020 02:54 AM
Oh lol yes! You are right.