The DISPLAY field for a menu item allows for some crafty formatting. The one I have yet to figure out (read a lot of postings in the forums) is how to simply put the COUNT value under the Menu Name.
On a mobile device with a specific width of display, the long text seems to wrap ideally, but not in every use case.
CONCATENATE("Everyone (",COUNT(FILTER("People",ISNOTBLANK([FIRST_NAME])))+COUNT(FILTER("People",ISNOTBLANK([MATE]))),")")
CONCATENATE("Everyone",{LineFeed},"(",COUNT(FILTER("People",ISNOTBLANK([FIRST_NAME])))+COUNT(FILTER("People",ISNOTBLANK([MATE]))),")")
Thinking AppSheet expressions might follow JavaScript syntax, I first tried using "\n" and "\r". And while both of these methods PASS expression testing, they fail to produce the desired outcome.
CONCATENATE("Everyone","\n(",COUNT(FILTER("People",ISNOTBLANK([FIRST_NAME])))+COUNT(FILTER("People",ISNOTBLANK([MATE]))),")")
CONCATENATE("Everyone","\r(",COUNT(FILTER("People",ISNOTBLANK([FIRST_NAME])))+COUNT(FILTER("People",ISNOTBLANK([MATE]))),")")
Aside from the stray comma after the word "Everyone" -- I think using SPLIT() and specifying the "/" as my delimiter seems to work.
SPLIT(CONCATENATE("Everyone/(",COUNT(FILTER("People",ISNOTBLANK([FIRST_NAME])))+COUNT(FILTER("People",ISNOTBLANK([MATE]))),")"),"/")
User | Count |
---|---|
16 | |
11 | |
8 | |
2 | |
2 |