Simple Script to duplicate record in automation

[Lisa_Bauer]

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!

[Stephen_Orr1 · Accepted solution]

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)

[Lisa_Bauer]

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

THANK YOU!

[sistemas_urbita]

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 

[Den1155]

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

[JuAtSwc]

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