Use of Concatenate to suppress blank data columns for reporting
Following on from Aleksi’s recommendation in response to another post I have been using virtual columns with CONCATENATE strings to suppress blank rows from reports. All worked fine, but I have just constructed another one and it is not including carriage returns, see extract below, anyone know what I’ve missed?
=CONCATENATE( IFS(NOT(ISBLANK([DoorAndIronmongery])),CONCATENATE("Internal door and Ironmongery: “,[ DoorAndIronmongery],”
")), IFS(NOT(ISBLANK([FireDoorAndIronmongery])),CONCATENATE("Internal fire door and ironmongery: “,[ FireDoorAndIronmongery],”
")), IFS(NOT(ISBLANK([FinalExitDoor])),CONCATENATE("External final exit door: “,[FinalExitDoor],”
By way of a footnote from other posts I’ve seen I think others struggle with reporting from Appsheet and it would be useful to have a function that automatically suppresses columns for rows that have no data along with their corresponding headings, would make life so much easier. Thanks, Steve