Merge Templates and Commas
I am wondering if it's possible to program the merge fields that contain commas (award amount, amount requested, etc.) so they automatically carry the comma into a merged document? The dollar signs automatically carry over when merging but the commas do not. Currently, I have to do a workaround with the merge fields so the commas carry over when merging into a document. It's sort of a pain and I imagine there are others that would find it easier to have this happen automatically (if possible) rather than doing a workaround. Just curious if this is a possiblity?
Thanks so much!
~kristen
Idea posted August 28, 2013 by Kristen Cullen, Carolyn Foundation
Ideas
shared this idea
-
Chris Dahl
commented
Kristen, Catherine, and Kelli,
Does the answer above address your needs or are you having to do more than this? If you could give me a concrete example from work you've done that I could access, that would help me determine if there's more to do here or if we can close this.
Thanks,
-chris -
Chris Dahl
commented
Hi all,
Thanks for the post, Mary. That site contains the answer (which can also be found here with a bit more explanation).
Basically, it should look like this in your merge template:
{ MERGEFIELD "Price" \# "$,0.00;($,0.00)" }
where "Price" would be replaced by whatever field you were wanting to format.
In other words, you should just have to add the \# "$,0.00;($,0.00)" part in the appropriate merge tag and the value will be formatted like currency.
I hope that helps. If you have more questions on this, please let me know. Thanks,
-chris
posted September 17, 2013 by Chris Dahl, Foundant Technologies
-
Ideas
commented
There seems to be a (somewhat complicated) way to do this on the user side: see
posted September 13, 2013 by Mary Giraulo, United Arts of Central Florida
-
Ideas
commented
Double yes please!
posted September 3, 2013 by Kelli King-Jackson, The Simmons Foundation
-
Ideas
commented
Yes please!
posted August 29, 2013 by Catherine Koenen, Gianforte Family Foundation