Select to view content in your preferred language

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

941
4
07-13-2023 11:17 AM
Labels (2)
Michael_Knapp
Regular Contributor

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

0 Kudos
4 Replies
RhettZufelt
MVP Notable Contributor

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:

RhettZufelt_0-1689276825225.png

 

R_

0 Kudos
Michael_Knapp
Regular Contributor

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.

0 Kudos
RhettZufelt
MVP Notable Contributor

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_

0 Kudos
Michael_Knapp
Regular Contributor

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.

0 Kudos