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

Question

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

Michael_Knapp · Answer

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.

RhettZufelt · Answer

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 · Answer

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.