Ability to use "Deleted Row" in formulas

Suggestion Box
1

I’m trying to create an automation to delete rows from a table if rows from a lookup column have been deleted in the referenced table.

I discovered that Coda sees the “Deleted Row” error as a value in formula language, but doesn’t allow me to use it… It would be so much easier if I could use “Deleted Row” in formulas, especially since I can’t get the =IsBlank("") formula to work since Coda doesn’t see the deleted rows as blank.

55
Screen Shot 2019-03-13 at 11.34.55.png1028×641 80.9 KB

3 Likes
2

Oh, for anyone wondering how to get that to work, I did find a workaround.

I created another column in the Project Items table that converts to text the values from the lookup column [Project ID selectable]. I also got rid of the If variable in the automation. I was then able to create a simple formula using “Deleted Row” as value :slight_smile:

(Beware that the automation doesn’t always work instantly, if going back and forth between sections and tables to check it.)

45
Screen Shot 2019-03-13 at 12.16.45.png1028×668 60.1 KB

1 Like
3

Thanks for sharing @Andreea_Cri.

Just wanted to share, I was able to find a different way to do this using buttons:

Pushing the Red delete button deletes the project as well as all tasks for that project.

4

Further to @Andreea_Cri 's workaround, if you don’t want to add the column for whatever reason, you can have your custom filter formula convert to text on the fly:

Project ID selectable.ToText() = "Deleted Row"
5

You could also accomplish this with one button using formulas instead of the Push Buttons action.
For the example @Angad has above, the code would look like:

RunActions(
    DeleteRows(
    filter(
      Team Task List,
      Project = thisRow
    )),
  DeleteRows(thisRow)
)
1 Like