I want to make timestamp for my approval system that generate when the user editing the status in Glide. There are 3 roles with different level like level 1, level 2, and level 3. When the user with level 1 editing the request status to approve, it will generate a timestamp in the timestamp approval level 1 column. Also, the same process for the user level 2. Every approval from level 1 until level 3 will have their own timestamp approval column and this happen on the same data or same row,
I’ve already made the approval system, but the timestamp will always changing and following the new role that editing the status. So for now, I have 3 timestamp columns with the same value. Any good suggestion? Thank you!
Just to be clear, I wasn’t suggesting that you get rid of your Edit Form.
You can still use that, but instead of setting the timestamp in every column using the special value, do it as an onSubmit action and only set the appropriate column based on the signed in users role.