Adding vertical space between items in detail view

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.

6 3 1,835
3 REPLIES 3

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!

Top Labels in this Space