Hey, I have a form that users can submit and then an admin can approve using a Switch component. When the admin toggles the switch it’s automatically recorded in the sheets, and then I hide it using visibility filter.
I would like to record the timestamp of the action - to have another column in the sheets that will add the current time when the switch field is 'TRUE".
I was trying many techniques I found online, but couldn’t get the NOW() to stay fixed.
Does anyone have any tips on how to add a timestamp on a switch?