Help

Re: Simple Script to duplicate record in automation

Solved
Jump to Solution
1615 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Bauer
6 - Interface Innovator
6 - Interface Innovator

I'm having a hard time finding a simple script that will allow you to duplicate a record via automation.

My end goal:

Trigger: When a record matches a condition (i.e. a checkbox is checked off)

Action: Run script --> this is where I can't find a script online! I need this script to duplicate the selected record.

Just simple as that. Can someone help me?

 

Thank you!

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

This can be accomplished without a script. 

Trigger: when record matches conditions, checkbox checked

Action: create record, add all fields and populate them with the values from the trigger record (configure each value to be dynamic by clicking the gear icon)

See Solution in Thread

5 Replies 5
Stephen_Orr1
10 - Mercury
10 - Mercury

This can be accomplished without a script. 

Trigger: when record matches conditions, checkbox checked

Action: create record, add all fields and populate them with the values from the trigger record (configure each value to be dynamic by clicking the gear icon)

Oh my gosh, I can't believe I didn't think of that immediately 🙄

THANK YOU!

Is there a way to make this resistant to future structure changes? In other words, to make the duplication keep working if a column is added or deleted from the table? Otherwise we would always have to remember to update the automation everytime a change is made.

Also, our table has dozens of columns. To have the data for each field manually listed on the automation would be very error prone.

Thanks in advance 

Not a solution when you have hundreds of fields...

JuAtSwc
4 - Data Explorer
4 - Data Explorer

How do you refer to the triggered record in the create record part? 
Thanks in advance