Action button to add a fixed value to a column in a single row

AppSheet AppSheet Q&A
1

I think this should be simple: I want an action button that will add a fixed value to a column of a row. More specifically, I have a table of tasks and I want an action button to add 1 hour to the [Due Time] column for a task. I am trying to do this with the option ‘Date: set the value of some columns within this row’. I think I need to reference the current [Due Time] value before the action takes place. But I can’t seem to use the [_THISROW_BEFORE].[COLUMN] expressions in the ‘Set these columns’ formula field. Any help on how to do this?

Screenshot 2025-03-31 133818.png
Screenshot 2025-03-31 133818.png870×655 38.5 KB

2

Instead of using [_THISROW_BEFORE], which is not available in the “Set these columns” formula field, use this expression:
[Due Time] + "001:00:00

3

Thanks so much, that works! I think I had tried [Due Time] + 1 and it didn’t work so I assumed I needed to call the value before the update.. But I guess it just requires the full time format.

1 Like