Formatting fields/ data using the table widget in Experience Builder

Question

Good day all,

I'm new to Experience Builder and having some issues attempting to configure fields in a table (using the table widget). I know there are options to format using expressions (number formatting)  for a text box - connected to data.

I would like to simply change the amount of decimal placeholders to 2. I would also like to know how to format/ change field names in the table as well.

I know you can do this kind of formatting with dashboards, but ideally I would like to do it straight within the table widget in EB.

I appreciate any assistance/ comments on the matter.

Thank you,

Snapshot.png

JoClarkeBega · Answer

I have tried this but despite setting my field to NOT show thousands separator and thousands separator does not appear in the pop-up, in tables in table widget in Experience Builder and in Feature Report widget my integer is appearing with commas. It means that when I try to configure report name to include the property_ID it appears with commas and needs to be manually edited to remove from title. Is there any other solution for this? I tried using Arcade expression to turn into text but appears not to recognise full arcade expressions.

DaveStewart1 · Answer

Thank you for your response  jmaxwell_braun,

This is tabular data only (no mapping tie in/ component) - apologies I should have included that.

Regards,

JamieMaxwell · Answer

I believe that setting is controlled through the source layer or map used in Experience Builder, not in Experience Builder itself.

Open the source map in Map Viewer, click the Layers tab on the left side of the screen, click the layer you want to adjust, then click the Fields button on the right side of the screen. Select the field you want to adjust and change it. I attached a screenshot of the setting.

After making the adjustment you'll need to either save the map or save the changes directly to the layer (by clicking the 3 dots next to the layer on the right side of the screen and choosing "Save"). I generally prefer to save things like this to the layer instead of the map. That way you don't have to adjust it again if you reuse the layer in a different map.

field setting map viewer.JPG