Setting a variable and writing back a value with the Edited Cell action

The Edited cell action does not do the same as a writeback formula (for example, RWC or WBC). You might have an RWC formula to enter values to the database. In the same cell, you can have an Edited cell action that fills a variable. When a user edits the cell, the action is triggered and the variable is filled, but the formula is not executed.

You can change the action to allow both writeback and setting a variable.

  1. In Design Mode, select cells B4 to D6. Format them with a background color. Format cell C5 with a white background. Remove cell protection from C5.
    See Applying cell protection
  2. Create two global variables: gvEditor and gvWriteback.
  3. Right-click cell C5 and select Define Action.
  4. In the Define Action dialog, select Set Parameters as the type, Edited cell as the mode and =TRUE as the condition.
  5. In the Parameters section, double-click <New Parameter>. Select gvWriteback from the list of global variables.
  6. In the Value field, write a WBC formula, using the cell reference, C5 as the Value argument.
    See WBC
  7. Double-click <New Parameter> and select gvEditor from the list of global variables.
  8. Specify =GlobalVariables._CurrentUser.text as the value of gvEditor.
    An example of using an Edited Cell action to update attributes is included in the description of the WBA formula.

    See WBA.

Parent topic: Actions
Related topics