Tags & Format

Classic Servoy
1

I am using the following tag at the top of a form and was wondering if there would be a way to format the “project_number” part of the tag (numeric). It is showing as 100,500 instead of 100500.

%%project_number%% - %%project_name%%
2

Use a calculation with utils.formatString(…) for the tag you want to format

3

I am unable to find formatString(…). The dev ref manual also does not have this listed.

I tried to format the number column with the value of 100500 (displays as 100,500) with ```
utils.numberFormat(project_id, ‘#’)

4

Is the “Returned type” of your new calculation set to “TEXT”?

5

4xjbh:
I am unable to find formatString(…). The dev ref manual also does not have this listed.

I tried to format the number column with the value of 100500 (displays as 100,500) with ```
utils.numberFormat(project_id, ‘#’)

You used ‘project_id’ instead of ‘project_number’ as mentioned in your previous post.

Hope this helps,

6

It’s times like this that you wish you can delete this sort post. I worked out how to do a calculation and all is well in the world. Thanks

7

4xjbh:
It’s times like this that you wish you can delete this sort post. I worked out how to do a calculation and all is well in the world. Thanks

if that would be possible, we would not have such a rich forum ,where we can find stuff & solutions!
so IMHO it serves the rest, from asking :-)