How to only show Concatenate Virtual Column only when data is entered

[drfuadj]

Hello, im new to Appsheet and do need help to configure this issue

I'm currently making an app to store 'Patient Blood Reports' and for the DETAILED VIEW i'm using Concatenate to optimize the appearance of the data much better.

Just one issue, the blood report is not a mandatory field to be fill, so in some instances the blood report data will not be entered in complete. So in this situation, how can i HIDE the concatenate column when the data is not filled in?

[Aurelien · Accepted solution]

Hi @drfuadj 

---

@drfuadj wrote:

the blood report is not a mandatory field to be fill, so in some instances the blood report data will not be entered in complete. So in this situation, how can i HIDE the concatenate column when the data is not filled in?

---

You can fill a Show_if condition here:

and provide this expression:

AND(
  ISNOTBLANK([FBS]),
  ISNOTBLANK([RBS]),
  ISNOTBLANK([Hba1c])
)

But given your expression, I would go very simply with that:

IFS (ISNOTBLANK([FBS]),CONCATENATE("FBS: " , [FBS] , " mmol/L
"))
&
IFS (ISNOTBLANK([RBS]),CONCATENATE("RBS: " , [RBS] , " mmol/L
"))
&
IFS (ISNOTBLANK([Hba1c]),CONCATENATE("Hba1c: " , [Hba1c] , " mmol/L"))

 Basically, I'm just building an chain of character if there is something to display. Eventually, if the whole chain goes blank, then your column won't be displayed.

For reference:

ISNOTBLANK() - AppSheet Help

IFS() - AppSheet Help

Conditionally show or hide a column value (Show_If) - AppSheet Help

[drfuadj]

Tested & it works smoothly.

THANKS a lot for the help! Very much appreciated!