Automatic Duplication of Records with One Field Change

Hi everyone,

This might be a scripting question, but thought it couldn’t hurt to ask. I have a table in which certain records operate in a somewhat-grouped manner by nature of Year # and Number of Years fields (ie. if Number of Years = 3 there would be three total records with 1, 2, and 3 as the Year #. Is there a way to create an automation so that when say, the Year # = 1, Number of Years = 3 record is made two duplicates that are identical except for the Year # are made? It seems theoretically possible to do through going to the Create record automation and manually bringing forth each duplicated field and then adding an update automation, but I have to think there’s an easier way.

Thanks so much!