How to not add a row for certain row conditions

I’m pretty novice at coda formula

The goal is to create both a recurring and one off task list in one table. The recurring formula I have works well, but I do not want it to create a new row when the recurrence is ONE OFF or simply blank. Here is the formula below. Any suggestions would be great!

RunActions(AddRow([Recurring Tasks], [Recurring Tasks].Tasks,thisRow.Tasks, [Recurring Tasks].Recurrence, thisRow.Recurrence, [Recurring Tasks].[Due Date],thisRow.[Next Date], [Recurring Tasks].Status, “incomplete”, [Recurring Tasks].[Est Time],thisRow.[Est Time], [Recurring Tasks].People, thisRow.People, [Recurring Tasks].Room, thisRow.Room, [Recurring Tasks].How, thisRow.How, [Recurring Tasks].Link, thisRow.Link),ModifyRows(thisRow,thisRow.Status,“complete”))

You can add an If() formula in there to only proceed if it’s what you want to do

RunActions(
  If(
    thisRow.Recurrence = something etc etc,
    AddRow(...),
    _NoOp() // a sepcial formula that just means "nevermind, do nothing"
  ),
  ModifyRows(...)
)

Or if the ModifyRows() is only supposed to happen if we AddRow(), then you could move the whole RunActions( AddRow(), ModifyRows()) inside the If()

1 Like