FORMATTED CURRENCY DOES NOT SUBMIT TO SHAREPOINT

Brass Contributor

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

 

 

 

1 Reply

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.