Been a while since I build an app and I am a bit rusty and I was hoping if someone can help me with is probably a issue solution to a Reset_if scenario I am looking for.
I have two specific columns of a table that includes a few others.
- Status Date
Status date is currently empty, however status is mostly populated as well as the data in most of the other columns in the table.
I would like that Status Date to Reset_if I change or edit the data in the Status column.
- The status date won’t necessarily be today’s date. So timestamp will not help.
- I also would like to make the Status Date required only if the Status is changed / editted.
Can anyone help?