Formatting numbers and dates

[nicari]

I have created formatting strings in the Format Builder, but I have not found any information on how to apply such formate to data in a display object on a form.
Any help would be highly appreciated.
Thank you.
Egbert

[kev1n]

Hi Egbert,

Just choose the format in the Input Tab.

[nicari]

Thanks for your answer.
It appears to me that the option to specify a display format exists only on edit forms.
In my case things are somewhat different:
A launch form without associated table. On the form there are a number of display objects (in this particular case 17). Each of these display objects has its own SQL query, querying different non-related tables. The result of which is displayed. The results are mathematically correct, but almost unreadable because they lack a proper formatting. I have not been able to figure out how to format these.
Can you recomment a strategy on how to correct this?
Thanks for your answer.

[kev1n]

Thanks for your answer.
It appears to me that the option to specify a display format exists only on edit forms.

No, also on Launch and Browse Screens and it doesn't matter if you are querying non-related tables.

The results are mathematically correct, but almost unreadable because they lack a proper formatting. I have not been able to figure out how to format these.
Can you recomment a strategy on how to correct this?

Are we talking about decimals? Can you give an example of what the value looks like in the database, what format you are applying to it and what the output in nuBuilder looks like?

There is also always the possibility to format data with SQL.

[nicari]

Thanks for your answer, which provided the clue to further experimentation.
I found that the sequence of action is the following:

The object type is presently "display". Change this to "input"
then under the input tag select nuNumber and the required format.
Save the record.
Then change the object type back to "display" and save again.

So this problem is solved. Thanks again for your help.
Egbert

[kev1n]

The object type is presently "display". Change this to "input"
then under the input tag select nuNumber and the required format.
Save the record.
Then change the object type back to "display" and save again.

There's no need to change to input and back to display. The Input Tab is always visible and you can chosse the format there right away.

(Although it is not logical that you can set the date for a display field under Input....)

[hiramalik]

Hi,
What is I want to change date format to MM/DD/YY which is not in the list and there is no option to customize format of a date field either.

[kev1n]

Use the Format Builder:
https://m.youtube.com/watch%3Fv%3DIZEA4 ... PEntGTw1qM