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
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_
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.
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_
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.