AGOL - Hosted Non-Spatial Data - Format Field for Display

[Michael_Knapp]

Hi there - 

I was wondering how one can format fields for display in non-spatial hosted tables in AGOL. 

For example, removing unwanted commas from years, or times from date/time fields.

Usually we do this through creating a view of the data, then modifying via the "properties", but this isn't available for views of non-spatial tables.

Any suggestion would be much appreciated. 

Thank you!

Mike Knapp

Municipality of Anchorage, Alaska

[RhettZufelt]

How/where are you displaying the table?

In Map Viewer, you can select the table, then the Fields option and change that on a per field basis:

R_

[Michael_Knapp]

Sorry, I should have mentioned that we're adding the table directly to Experience Builder (not via a Map). Based on some previous posts, it seems Experience Builder tables won't honor the field settings of layers in a Map Viewer. I just performed a test and this still seems to be true. So, I think we need to find a non-Map Viewer solution here.

[RhettZufelt]

Good luck with that one.  It has been requested quite a bit, but I don't see any mention of progress towards it.

As a workaround, you could calculate text fields with the format you want, but that is not very robust with dynamic data.

R_

[Michael_Knapp]

True, true.... I think we might just give the tables a dummy coordinate and have them be points, then we can adjust fields in the views.