You are viewing limited content. For full access, please sign in.

Question

Question

Monetary Values in Forms

Feature Forms
Updated November 29, 2022
asked on July 22, 2021

When using the currency Field on a Form, it is not stored in the database with commas separating the thousands.

  • Form shows: 5,120.25
  • Database stores: 5120.25

When you use this at any point in the process such as a email notification or the instance name, the value is the comma stripped version directly from SQL. 

A Customers Compliance department is not happy that it does this and has flagged this as an issue in testing. Has anyone found a way to Format the values in an Email Notification or a Report with a , for the thousands/millions?

0 0

Replies

replied on July 27, 2021

With workflow you can format tokens to include the thousands separator. If you need the thousands separator in an email, I would recommend using workflow to format the token and send the email. 

Documentation

The standard for formatting a token is %(token#"expression"#), where token is the name of the token and expression is a formatting expression. For the thousands separator, you would use the thousands place comma structure here:

, - Thousand separator and number scaling - Can be used to insert commas as a thousands separator in numbers. 

%(token#,#)

More detailed info here

 

0 0
View 1 previous reply
replied on July 27, 2021

Thanks Jared, however if I passed the number to a Single Line field (=sum(numberfieldwithseperators)), it retained the comma separated value when used as the Instance Name and Email token. So implementing Workflow just for a email seems a bit excessive than hiding the field to the end user.

1 0
replied on January 28, 2022

Anthony,  So you just used something like this =SUM(Total_Reimbursement_Requested) and it retained the comma?  Here is what I am getting, just curious if I missed something.   I created two extra single-line fields as you suggested for two number fields that aren't keeping the comma when sent to an email.  I haven't tested the email yet but the values in the field don't have the retained comma.  

0 0
replied on November 28, 2022

Jason, did you ever sort this out? I'm not having any luck with field calculations or trying to format the email notification.

0 0
replied on November 29, 2022 • Show version history

Peter, I didn't.  I just gave up on it since it was just cosmetic in the email for me. However it doesn't store in LF fields with the comma either it seems.   My calculations all work, but just not the token for email.  I am happy to show you may calculations if you want.  Email me and we can set up a time. 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...