Updating all available rows in a Table with a default value

Options
Kelsey_827704
Kelsey_827704 Posts: 8
edited March 2021 in Questions

Currently I'm having trouble applying a default value to a Table column.

USE CASE
Based on department, employees have different required and optional training requirements. For optional training, I would like to be able to send a webform that allows the manager to identify which optional trainings should be included in the individual's orientation packet.

ISSUE
Right now, it seems like the easiest way to accomplish the above is to include a Table in an emailed webform that can be updated per training. It has two columns: Training (long text), Needed? (boolean). I would like to update the boolean column to default to False, but am having a difficult time doing this via Tables: Update a row.

Any recommendations on how to best to address the above issue or maybe a different way to approach this? Many thanks in advance.

Tagged:

Best Answer

  • Andrew_239256
    Andrew_239256 Posts: 16 admin
    Answer ✓
    Options

    Hi-
    Have you tried the Tables: Apply formulas to columns action?
    If I understand your question correctly, use the action above and insert the code below in the row formula field to set the entire table column to false.
    columns['Needed?'] = 0
    Hopefully that helps!

Answers

Categories