Solved: Reset date and time column value - Page 2

HugoJousselin · 07-28-2022 05:37 AM

Hello,

I would like to reset a date value and a time value to NULL so that the field can disappear when he is empty.

Actually, i have a bot that is setting their values to "" when my event occurs but that doesn't erase the value of these fields. It works only whith text fields.
Is there any command to set a value to NULL ?

MultiTech

If you've got the "reset on edit" turn on - and you're not using a formula to conditionally control when it should reset - then it's basically the same as having an app formula inside that field.

You'll need to do something with more nuance:

IsNotBlank([_this])
This will get the field to continue to reset, UNTIL it gets a value; at that point it becomes a static data point
- You'll need to come up with something similar to that, but tailored to your scenario

View solution in original post