Formating numbers as percentages within a smartrow

[Chris Iacovelli]

Working with confiforms smart rows more often now (loving it) and ran into a situation where one of the fields in my smart row is numeric. I want to show it as a percentage. The smart row is only shown in conjunction with the "parent" record and i am unable to figure out how to format numbers at that level.

Any suggestions on how to format 100 to 100% in the smart row field would be appreciated.

[Yvonne Sims · Accepted solution]

This is a fairly common Confiforms + Smart Rows limitation, and you’re not missing an obvious toggle 🙂

Short version: Smart Rows themselves don’t have formatting controls, so you have to handle the formatting at the field level.

Here are the practical ways to convert 100 → 100%.

Recommended: Use a Calculated Field with a display pattern

 If your Smart Row field is numeric and already contains 100, the cleanest solution is:

 Create a Calculated Field in the Smart Row definition

1. Use the original numeric field as input

2. Apply a DecimalFormat pattern to show it as a percentage

Example

Assume your numeric field is called progress

Formula
code
${progress} / 100

Display Pattern
code
0%

Result

Stored value: 100

Calculated value: 1

Displayed as: 100%

This works because Confiforms uses Java DecimalFormat, where % multiplies by 100 automatically.

✔ Works everywhere (Smart Row, parent record, views)

✔ No macros needed

✔ Still keeps the original value numeric