Numeric values in Custom Forms | Community
Skip to main content
Level 2
January 4, 2024
Question

Numeric values in Custom Forms

  • January 4, 2024
  • 1 reply
  • 525 views

I am trying to build a custom form that has annual costs and monthly costs. how do I create a calculated field that can automatically generate the monthly cost based on the annual cost? How do I set a field in a custom form to show as numbers (with the comma's). 

 

Thanks 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

KatherineLa
Community Advisor
Community Advisor
January 4, 2024

For the field formatting, you'll want to set the field type to 'Currency' in that case. You do that when you put the field on the form initially. If you have an existing field and forgot to set it properly during creation, you CAN try simply changing the field to Currency/Numeric and saving the edits. If the existing data happens to all be valid already, it will simply convert it like it was always that way from the start. When viewing that field on the form, it will show like this to the user. Mine has 'USD' there automatically because that's the currency for my instance.

 

As far as pretty formatting, you would do that in the reports that display the data under the Advanced Options menu when the column is added to that report. 

 

For your calculations, you'll want to review this documentation first before deciding on your best option. There's a couple ways to get there and each has it's trade-offs. https://experienceleague.adobe.com/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-custom-fields-calculated-columns.html?lang=en

 

 

AminaOyAuthor
Level 2
January 4, 2024

Thank you so much @katherinela. This is very helpful.