I am new to Coda but so far like its flexibility and friendly UI. Porting my PARA implementation over from Notion. I am using Addrow function to implement recurring tasks with a “Done” button. Since my table has more than a dozen columns, my newbie of using Addrow function created a super long formula
if(thisRow.Recurring>0, RunActions((AddRow(Tasks, Tasks.[In Box], thisRow.[In Box], Tasks.Done, thisRow.Done, Tasks.Task, thisRow.Task, Tasks.[Start Date], thisRow.[Start Date]+thisRow.Recurring, Tasks.[Due Date], thisRow.[Due Date]+thisRow.Recurring, Tasks.[Parent Task], thisRow.[Parent Task], Tasks.Project, thisRow.Project, Tasks.Priority, thisRow.Priority, Tasks.Recurring, thisRow.Recurring)), ModifyRows(thisRow, thisRow.Done, true)), ModifyRows(thisRow, thisRow.Done, true))
I am wondering if there’s a variation of the addrow formula that by default replicates all the fields except the columns specified in the parameters? Something like:
ReplicateRow (Table, Column_to_change_1, value, Column_to_change_2, value)
Thanks for the help!