Count

Hello guys, I hope you are doing well.

I need your help. How do I hide the sections I marked with a red line when I've filled in once?

Thank you very much for your help.

Safety.png

 

Solved Solved
0 4 122
1 ACCEPTED SOLUTION

I think i've solved it with this formula:

IF(COUNT([Related hazards])=0,

CONTEXT("viewtype")="form",

CONTEXT("viewtype")<>"form"
)

View solution in original post

4 REPLIES 4

If you haven't already, try using the Show if property of that column. It sounds like you might want an expression like ISBLANK(_THIS). The column might be a virtual column created automatically by AppSheet and called something like [Related Hazard Prediction Questions].

Based on the presence of the warning icon in your screenshot, there might be other issues you need to resolve.

Hello @dbaum thank you for your response. 

That works, but i can't see in detail view. Is there any other alternative way?

Thank you

Consider deselecting the UX option to Apply show-if constraints universally:

dbaum_0-1657498065960.png

Otherwise, you can leverage the CONTEXT function to show in view types besides forms:

NOT(CONTEXT("VIEWTYPE")="Form")

 

I think i've solved it with this formula:

IF(COUNT([Related hazards])=0,

CONTEXT("viewtype")="form",

CONTEXT("viewtype")<>"form"
)

Top Labels in this Space