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:
- [Priority] is text.
- [List] is text.
- [Done] is text.
- [When] is text.
- [Hide Until] is a date field.
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:
- [Priority] = “Urgent”
- [List] = “AAA”
- [Done] = “Done”
- [When] = “This Week”
- [Hide Until] = 8/3/2020
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:
- [Priority] = “”
- [List] = “”
- [Done] = “”
- [When] = “”
- [Hide Until] = 8/4/2020
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?