How to make a duplicate record

[John Prouty]

I want to give the user a button that will duplicate (copy) the current record so they don't have to re-enter all the data and can only focus on the differences.  I was looking at the Flow Designer and an Update Trigger, but all I could see was where I would have to explicitly identify each and every field in the record to do the copy.  Is there a way to code a loop that would copy all the fields from one record in the table to another record in the table?  Then I would make the one change to link them together.

[John Prouty · Accepted solution]

I have concluded that I can only do this by explicitly reference each field in the trigger.

[charlesgord]

You can also just enable the 'Insert and Stay' UI action at the table level which provides exactly this functionality with no custom coding required