Tables: Update a row - look up and update empty cells

Options
Kalin_996882
Kalin_996882 Posts: 74 admin
in Questions

I have run into a few cases where I would like to update a row with an empty cell. When filling out the Tables: Update a row action I'm asked for 2 search criteria:

  • Column names
  • Column criteria

The issue I run into is there is no criteria to specify since my goal is to select and update an empty cell. So far the only workaround I have worked out is placing a value to search for later on to update. I'm interested to see if there are any other approaches to this out there.

I also found this idea to upvote: https://community.pushbot.com/discussion/172/tables-update-a-row-look-up-empty-cells

Best Answer

  • Jozef_783863
    Jozef_783863 Posts: 331 admin
    Answer ✓
    Options

    @Kalin_423324 There are two steps you can add before running Tables: Update a row.

    1. Tables: Add a Column - (Add a Column Named "Update Column")
    2. Tables: Apply formulas to columns - (Write to the value "Update" to the new column if your column is empty)

    These two steps will provide you a Column Name ("Update Column") and Column Criteria ("Update").

Answers

Categories