Dec 05 2021 04:59 PM
Hello Community,
Have a form where input is formatted to look like currency (while typing) via a variable.
However, when the form is submitted, the dollar value does not submit to SharePoint.
Any suggestions/recommendations?
V/R
chudson002
Dec 06 2021 12:15 AM - edited Dec 06 2021 12:18 AM
What's in the "update" property for that datacard?
When submitting to a sharepoint currency column, the value should be formatted as a decimal number.
Im not sure what you mean by formatted to look like currency while typing, by perhaps you could put in the update property something like:
value(right(fieldname.text,len(fieldname.text)-1))
This would give you the value in the text field, less the $ on the left hand side, in numeric format.