Padding Space

[davidhuang]

Hi, I use CONCATENATE and TEXT functions to create text. How can I pad spaces to the left something like LeftPad(" ", Text(number_column), 14)? Thank you!

[Steve]

There is no LEFTPAD() function, but this will approximate it:

RIGHT(("              " & TEXT([number_column])), 14)

Note, though, that AppSheet uses proportional fonts (by default), so space padding probably won’t give you the alignment you appear to want. Instead, you might consider:

You may also want:

[davidhuang]

Thank you very much @Steve!

By the way, in the future (new feature), is it possible to have a column type of HTML in which we can put html contents?