Hello,
I am trying to generate reports from one of the tables in my app. Everything is going well and the reports are formatted as expected.
The only issue I have is that, there are certain fields which are blank sometimes and I have applied showif conditions that if blank, they are hidden. Its working well in the app,
but they still show up in the report. Is there any way I can hide fields which are blank in the reports?
Is the report in excel? if so, maybe try and create a template for the Report with built in formula (=iferror).
I use it myself
This has been asked by a few others too. At the moment, there isnโt a convenient <> templating syntax.
Could you please add this to https://www.appsheet.com/feature-requests
@praveen Sure. I will add a feature request.
It would be very convenient to generate well-formatted reports if we can have this feature.
Thanks.
@Yogesh_laddha There is a workaround for thisโฆ not very elegant, but doable When the โVATโ is not blank, the CONCATENATE will generate a line enter. If itโs blank, it doesnโt add a new row. As Praveen mentioned, we should have a easier way.
Sub Total: <<[SUB_TOTAL]>><<IFS(ISNOTBLANK([VAT]),CONCATENATE("
","VAT%: ",[VAT]))>>
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |