idea Support Field Formatting in Table Widget (Including Date/Time Formatting) in ArcGIS Experience Builder Ideas

Support Field Formatting in Table Widget (Including Date/Time Formatting)

williamsonsa_fultonhogan — Mon, 31 Oct 2022 22:39:58 GMT

The Attributes displayed in the Table Widget in ArcGIS Experience Builder should support the Field Formatting configuration that has been made on the respective layers in the Web Map. Field Formatting is essential for Pop-up configuration, and we want to keep the information that is displayed in a table consistent with the pop-up.

There are two particular Field Formatting scenarios that are particularly important to our users:

Date/Time Formatting - it is essential that we can hide the Time for Date/Time fields in the table widget. We have workflows where only the date is necessary, and so the time is irrelevant. Also when editing, the time user input should not be displayed. Only the date should be visible, and only the calendar when editing.
Numeric Field Decimals - Often we round the Numeric values to 2 Decimal places. In the Table widget, the attribute displayed still shows all of the significant digits.

Thanks

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

DataOfficer — Tue, 01 Nov 2022 11:31:00 GMT

We've been having the same issue where we just want to display the date and not the time.

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

Lwkrynock — Wed, 09 Nov 2022 19:47:29 GMT

I would love to see this improvement as well! I would like to be able to round the numeric values showing in an ExB table as can be done in other ESRI apps.

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

CarlHughes — Thu, 02 Feb 2023 18:33:17 GMT

This would be a really beneficial improvement!

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

DustinEdge_Boroondara — Sun, 11 Feb 2024 22:31:05 GMT

Move to XB they said...it's the way forward they said.

And yet it lacks key functionality. sigh

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

ZHenderson — Fri, 16 Feb 2024 16:04:52 GMT

I know that you can access table field formatting in Dashboards using Arcade, so it would be nice to see the same in ExB where you could get access to the underlying display code so that you could display only the date, or round to the nearest digit, or even remove the comma delimiter.

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

DavidWaltz — Mon, 15 Apr 2024 22:23:55 GMT

This would be a great update to have. My organization has had to create a new text field and convert the information from the date field into the text field in order to have the dates show without the time, but that makes it so that you can't order the field by date, which is another issue.

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

HMustapha — Tue, 04 Jun 2024 18:22:09 GMT

I also have the need to display only date, not date and time, in the table widget. Even though the source web map has "Show time" toggled off, every date in the table widget has 12:00 AM unnecessarily added after it. Please implement the ability to get rid of the 12:00 AM.

Re: Support Field Formatting in Table Widget (Including Date/Time Formatting)

E-PeterRose_GISS — Thu, 29 May 2025 14:57:16 GMT

I can edit field formatting in Map Viewer, and then by selecting "Use layer settings" under the Table widget settings in ExB, it honors the field formatting set in the web map. However, then I cannot choose which fields to show/hide in the Table widget. Whereas, if I select Customize for a layer in ExB under the Table widget settings, I can choose the fields to show/hide, but the field formatting reverts back to the defaults. So, it is lose-lose.