You searched for the word(s): 12
-
See attached sample. Save the file linked in this post header by right clicking the link. Then, right click the downloaded file and select design to open in design mode. Then you can preview, etc.
-
I can't do that since the field type is text and it doesn't have any format.
-
In the form, you could use a calculated value set to display the data as currency. Just add a calculated value to the form, select the field that has the value, and under the properties, format it as a decimal. You'll have the options then to set the currency settings.
-
-
Display in your form? Or in your list?
-
how can I make it in expression? just to display as currency but the field remains as text?
-
It has default value based on another field.
Something like this in the default value - eval(eval(Title[Test= Value], 'concat(., "; ")'), "..")
The 'Title' and 'test' coming from another list using data connection and 'Value' coming from another column in the form.
-
So - by auto populated, you mean it has a default value? Or is it being set by a rule?
-
Thanks for your response.
I forgot to mention this is an auto populated field, which user can edit later.
I tried it on regular field and it works too.
2 things that pop to my mind :
--Can it be some sort of caching issue? Once the error appears it doesn't go, but as long as user is entering correct data it works.
--Can this ...
-
Hmmm. I don't know how helpful this is, but I just tested this in a list form of mine. I checked in preview and in the published form, and in all cases the validation worked as expected. The field was marked invalid unless I had 7 digits, followed by a semicolon and a space for any additional numbers.