topic AGOL - Hosted Non-Spatial Data - Format Field for Display in ArcGIS Online Questions

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

Michael_Knapp — Thu, 13 Jul 2023 18:17:14 GMT

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

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

RhettZufelt — Thu, 13 Jul 2023 19:34:10 GMT

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:

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

Michael_Knapp — Thu, 13 Jul 2023 19:46:41 GMT

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.

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

RhettZufelt — Thu, 13 Jul 2023 20:37:29 GMT

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.

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

Michael_Knapp — Thu, 13 Jul 2023 21:44:07 GMT

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.