Is it possible to show or hide a column in a form view depending on time?
I have an Image column and a OCRTEXT() column. I also have a ChangeTimestamp column that is looking for the Image column.
Sometimes OCRTEXT() does not answer. It’s just not extracting the Text out of the Image.
So I want to bring a SHOW column that says: “Please take the Photo again”.
The expression in the Show_if for the SHOW column would be:
AND( ISNOTBLANK([ChangeTimestamp]), ISBLANK([OCRTEXT]), NOW()-[ChangeTimestamp]>"000:00:05" )
Meaning: Show me the SHOW column, when the user took a photo, but after 5 seconds, the OCRTEXT ist still empty.
But this expression is not working in Form view.
When I save the Form and open it again, it is working.