Automatically copy data from one Table to another using Last Updated Trigger

Hey cc5fe104-2b79-4015-9e05-5d4bc723c55d, as far as I am aware, there is no current way to add time delays internally with SS automations. If you want that approach, I suggest you use something like Make to extend the automation abilities of your use case.

However, I would consider this approach as an option (although please let me know if I am misunderstanding your process):

You want to update record 1 in table Positions. When this record is updated all the way, you want to duplicate the record to table Positions-Historical. From your description, it sounds like you are already updating the record in an automation, and as part of that same automation, you are trying to create a new record.

I would split this up into 2 separate automations (I believe SS runs on operations similarly to Make so I don't this would actually alter your automation uses). Automation 1 updates the record in position and the final update to this record would be a trigger condition for automation 2 (that could be a status or slider or something of this nature). When that trigger condition is met, you can simply create a new record in the table you want and copy over the fields directly. Then you don't have to worry about any time lags.