Skip to content
HOW TO

Respond to Clicks and Notifications

Goal

Use workbook interactions to set values, send messages, or trigger follow-up formulas.

Prerequisites

  • A clearly labeled interactive range or control.
  • A defined mapping from returned click values to allowed actions.

Steps

1. Define the interactive range and the value that each click should return.

=U.SET_CLICKVALS("trade_row",B6:F20,,1,0,1)

2. Read the selected value in a separate cell.

=U.GET_CLICKVAL("trade_row")

3. Convert the changing click state into a one-time event before calling a notification or action function.

Result

A user interaction updates a click value, which an explicit event or dependent formula converts into one controlled action.

Common Variations

  • Return a clicked value, row, column, or configured state.
  • Use hover settings for presentation without triggering an external action.
  • Send a message, email, text, or sound only after validation succeeds.

Troubleshooting

  • If actions repeat, separate the live click value from the one-time event trigger.
  • If the wrong row is selected after a dynamic grid changes, capture stable identifiers instead of transient coordinates.
  • Do not place notification credentials or sensitive message content in logs.