Column width + thousands-sep

User Support Form Building
, , ,
1

Hi Everyone,

I have a section of my form in table appearance to collect some numbers.

This is working quite well, but i need the numbers formated with thousands-sep, along with the specified column width, but it’s not working.

I have tried different appearance combinations and it’s either i get the thousands-sep working but with full width, or i get the specified width without the thousands-sep.

Below are the combined options I’ve tried:
w1, thousands-sep
w1 thousands-sep
thousands-sep w1
thousands-sep, w1

Can anyone tell me a combination that works?

Thanks

2

@elvis_pooplogg, you should have more control of your form as outlined in this post discussed previously:

3

Hi Kal_Lam,

The grid theme is well understood and it’s something I use a lot.

The challenge is how to have a thousand separator appearance within a grid-theme cell.
Combining the cell width w1, w2, w3,…etc with thousands-sep formating in the appearance column doesn’t seem to work.

Kindly give me an example of how I can have say, 10,000 in a grid theme cell for an integer type entry/question.

Thanks

4

@elvis_pooplogg, you could do this as outlined in the image shared below:

In the survey tab of your XLSForm:

image

In the settings tab of your XLSForm:

image

Data entry screen as seen in Enketo:

image
image829×493 17 KB

Reference XLSForm:

Styling Prompts.xlsx (12.6 KB)

1 Like
5

Many thanks, Kal_Lam,

This works, I’ll need to audit my form to see why it’s not cooperating.

Is there any way to get rid of the typed-in value from appearing at the top of the thousands format? It defeats the whole purpose.

Thanks

1 Like
6

Unfortunately, there isn’t.
Another option might be to force the user to entry the separator, through a regex constraint.

1 Like