Iโm a novice user so Iโm not sure yet how the pieces of AppSheet fit together. But hereโs what Iโm trying to accomplish โฆ
I have these fields:
Note that the above text fields get manually entered and changed EXCEPT when I want to automatically blank out those text fields when [Hide Until] > itโs previous value. For example:
Before editing:
I edit [Hide Until] to be 8/4/2020 (any value > 8/3/2020)
When I save it, I want the end result to be:
What Iโve tried:
I tried a behavior to โSet these columnsโ to โโ
and โOnly if this condition is trueโ โฆ [Hide Until] > [_THISROW].[Hide Until]
but that doesnโt seem to do anything.
Any ideas on what the proper approach should be?
This:
[Hide Until] > [_THISROW].[Hide Until]
should be;
TODAY() > [Hide Until]
No โฆ Thanks Steve โฆ but neither date is based on Todayโs Date. The date on the record might be today, last week, next week, next year, last year, etc. The date Iโm changing it to could be any date (in the future) thatโs greater than the date on the record.
You can use below expression to RESET the values of other columns via RESET_ON_EDIT
[_THISROW_AFTER].[Hide Until] > [_THISROW_BEFORE].[Hide Until]
Thanks @LeventK โฆ This worked, but I decided to make it a Workflow Rule instead. Just so that all the actions could be together in one rule for [Hide Until].
Excellent. Youโre welcome.
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |