Postscript: The method described in this post works but thereโs a much, much easier method. For that, please scroll down to @tsuji_koichiโs comment. I also learned after posting this that spaces placed at the beginning of a line are ignored when brought in from a Google sheet but that spaces typed directly in a virtual column are not. When those virtual columns are combined in concatenate expressions, however, the spaces may be ignored. So, if you want to make sure that an indent works when you need to concatenate, the technique Iโve described here (putting a special character in your Google sheet) might be best.
Have you ever wished you could just add an extra line to make a view look a little nicer? Hereโs an example of a situation where I wanted to do that:
Here Iโve used the standard AppSheet function to designate the header column in a Detail view:
It works but I found myself wanting some more space between the header and the first items . . . something more like this:
How did I do it? Well, thatโs what this โTipโ is about. My data is in a Google spreadsheet where I made a column with the following formula in it:
=concatenate(CHAR(HEX2DEC(โ200Bโ))," ",)
This is simply a space preceded by a โZERO WIDTH SPACEโ character. Iโve written about another way in which I use this character here:
In the vertical spacing example Iโm explaining here, I named the column with the zero width space character and the real space character โBreakโ. Then, I put a space in the โDisplay nameโ setting to turn of the โBreakโ heading that would otherwise appear about my space:
Then, I brought the โBreakโ column to the top of my column order in my Detail view settings.
Thatโs it. I was happy to see an appropriate (in my view, at least) amount of space between the heading and the first item.
By the way, if you need to you can use a format rule to make the space bigger or smaller and thereby fine tune your vertical spacing.
Finally, CHAR(HEX2DEC(โ200Bโ)) followed by spaces in a concatenate statement allows your to indent horizontally, too โ if that is something you happen to want to do.
Yes, the space, or padding, margin whichever we call, i agree with you, space is too narrow.
What I do is to generate the virtual column called, [blank] and kick the app formula of " " like you do. and put that into the header or first column out of the listed items.
Wow! That worked and it was so much easier!! I thought that a space there would be ignored. Good to know itโs so easy!
All roads lead to Roma, but in the different way sometime!