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

Question

Question

Display Value (Comma) on Emails generated from Laserfiche Form

asked on August 28, 2018

Is there a way to display the value such as the comma character to separate groups of digits in the amount field (Example: $1,000,000.00) on emails generated from Laserfiche Form?  We have a Laserfiche Form that generates an email capturing the amount field from the Laserfiche Form.  The actual Laserfiche Form entry displays the comma character (Example: $1,000,000.00) but the email generated displays the amount as $1000000.00.

 

Thank you,

0 0

Replies

replied on August 28, 2018 Show version history

* EDIT - Realized that you  are not using workflow, just within Forms.   Mine is of course a workflow answer. 

You can add commas with numeric formatting,  #,###.00

See the Custom Numeric Format Specifiers section in the admin guide.

However you will first need to extract the numeric part of the dollar value (remove the $ sign) and then apply the formatting.

If %(Value) is the original dollar token, in an 'Assign Token Values' activity, step 2 will have the value with commas:

~ Andrew

 

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

Sign in to reply to this post.