Help

Copy data from one field to another in the same table

Topic Labels: Automations Formulas
Solved
Jump to Solution
609 4
cancel
Showing results for 
Search instead for 
Did you mean: 
CharlieMullin
6 - Interface Innovator
6 - Interface Innovator

What's a good way to copy data from one field to another in the same table?

Currently, I have data in Field A that I want to copy to Field B because I want to deactivate Field A (probably hide it.) Then, going forward current processes where data was entered via a form to Field A would instead be entered into Field B.

So, this is a one-time need but there may be other changes in the data structure where having an automation in place that performs this task would be handy.

If this is an automation, I'm not sure what to use as a trigger.

Any ideas are welcome.

2 Solutions

Accepted Solutions
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @CharlieMullin ! You answered your own question, let the form submission be the trigger! 🙂  I'll include screenshots here of an automation structure and code snippet you can use. Here's the structure:

Trigger: When form is submitted. 

Action 1: Run Custom Script. Take Field A as an input for the script, and output the value as Field B. 

Action 2: Update Record. Take the output from Action 1 and insert into Field B.

 

Screenshot 2023-10-27 235753.pngScreenshot 2023-10-27 235727.png

See Solution in Thread

CharlieMullin
6 - Interface Innovator
6 - Interface Innovator

Hi @Arthur_Tutt , thanks for the info. I have never written an Airtable script so this is a good opportunity to get started. I'll need to figure out how to declare which records I want to update, and other things as well, so I may follow up with more questions if I can't figure it out.

I'm mrking this as the answer.

See Solution in Thread

4 Replies 4
Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @CharlieMullin ! You answered your own question, let the form submission be the trigger! 🙂  I'll include screenshots here of an automation structure and code snippet you can use. Here's the structure:

Trigger: When form is submitted. 

Action 1: Run Custom Script. Take Field A as an input for the script, and output the value as Field B. 

Action 2: Update Record. Take the output from Action 1 and insert into Field B.

 

Screenshot 2023-10-27 235753.pngScreenshot 2023-10-27 235727.png

CharlieMullin
6 - Interface Innovator
6 - Interface Innovator

Hi @Arthur_Tutt , thanks for the info. I have never written an Airtable script so this is a good opportunity to get started. I'll need to figure out how to declare which records I want to update, and other things as well, so I may follow up with more questions if I can't figure it out.

I'm mrking this as the answer.

Arthur_Tutt
8 - Airtable Astronomer
8 - Airtable Astronomer

Hey @CharlieMullin - glad I could help! And if you have more questions let me know.

Can you do me a quick favor and if you found my answer helpful to mark it as a solution (can have more than 1 solution), this helps to build my credibility in the community. Thanks and I appreciate it!