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.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |