Not a hack per se, just a smart way to speed up formula creation to copy a row (e.g. from the main table to a log table), using some regex.
Here’s a video how you can make such log table in 2 minutes:
Copy the table to a text editor or right into an offline / online editor that supports regular expressions (I prefer regex101.com, not affiliated). Remove everything but the headers
Set up replacement with regular expressions:
(means capture each element between tabs)
(means insert the captured column name twice, enclose in brackets)
Use replacement result in an
One caveat: this won’t have newlines. If you try to insert formula text that contains newlines, Coda won’t properly process it as a formula.