Skip to main content

Hi there,

I have a table which has all of the raw data from form submissions. I want to run some automations to change the format of email addresses, home addresses etc. However, I don't want to replace the raw data with the cleaned version, I want to have a table of the raw data and a table for the cleaned data. I want to clean the data as the forms are submitted. Is there a way to sync the data such that any new form submissions in Table A (raw) get put into Table B (cleaned), but which would allow me to then run automations and edits on the data in Table B without editing any data in Table A?

 

Thanks!

Hi there,

Can you clarify the cleaning of email addresses? Why not tackle the issue in the contact form so that have it directly in your desired format ?

Hmm, you'd need an automation that'd trigger on form submit that'd create a record in Table B with all of the data from the form submission.  I'm curious though, why not make a couple of formula fields and use different views in Table A?

@isobelhoward 

I agree that you should look into using views. You can learn all about views in my free Airtable training course, which you can take for free by signing up for a trial membership with LinkedIn Learning: https://www.linkedin.com/learning/learning-airtable/ 

Terms & Conditions