ExB Table Widget only showing fields selected for the pop-up

[ajohnson]

Hello,

I am experiencing a problem with the Table widget in Experience Builder (in Enterprise 11.5) where the table is only showing a limited selection of the total fields. The fields it is showing seem to be dictated by the fields that were selected in the web map for that layers pop-up. My layer has a total of 26 fields but only 11 are needed in the pop-up. I would still like users to be able to view all 26 fields in the table. Why is this happening? Is this a bug or a known limit to the table widget?

I can see all 26 fields in the web map and in the feature layer's data tab. All fields were also set visible when publishing from Pro. All things seem to be functioning as expect with the layer until I get to ExB.

If I select 'Customize' for the Configure fields setting (Table Settings\select relevant layer\Sheet Configuration\Configure Fields), I am able to manually select all the fields and then the problem is "solved" and all fields now show (lol jk actually it introduces a new problem). When I select "Customize" though the fields reset back to default and it does not reflect the specific layers field formatting (configured in Pro and the web map). All the date fields default to MM/dd/YYYY with a randomly assigned time. I have many fields in this dataset that require only a year and it would be confusing for non-technical users to see a randomly assigned date month, day, and time. In order to prevent it from destroying my date fields I need to use the 'Use layer settings' option in Configure fields, which dumps me back to my original issue.

What am I missing here???

[EMani]

Hello @ajohnson 

I tested this, and you’re right — when switching to Customise, the date format in the Live view reverts to the default Date/Time. However, once I saved and published, or saved and refreshed the builder page, the formatted date displayed correctly.

I then went back to Map Viewer and changed the date format again to display only the year. In Experience Builder, even after refreshing, the change didn’t appear. I unchecked the date field in Customise, saved the experience, then re‑enabled the date field and saved again. After doing that, the date was displayed as just the year.

Also, make sure the date field in Map Viewer is actually formatted to show the year only.

I hope this helps you to resolve your issue.

[ajohnson]

Hello,

Thanks for your speedy response. I have all of my date fields formatted as needed in the web map. I just retried configuring the table in the order you suggested above and I am still experiencing the same issue (it is showing MM/dd and hh:mm).

Do you have any insight into why the table is being controlled by the fields selected for the pop-up? I just noticed that even when I customize the layers used in the table to show all fields it still restricts the fields when you add content to the table widget via the three dots next to a layer in the layer list.

Why isn't the use layer setting not working to preserve field formatting?

[Shen_Zhang]

Hello @ajohnson,

From your original post, I see two separate issues:

1. The Table widget does not honour the pop-up configuration defined in your web map.

2. There is a date/time format mismatch in Customise mode.

Regarding #2, this was previously a known limitation and has now been fixed. The fix is already available in ArcGIS Online and will be included in the upcoming Enterprise 12.1 release. It is not available in 12.0.

For #1, we have recently resolved similar issues. However, I’m not certain whether your case matches those fixes. It would be helpful if you could share a sample app so I can confirm what's really happening here.

[ajohnson]

Hello @Shen_Zhang,

1.) I am not able to share the app publicly as it contains org protected data. I have not run into this issue with other datasets used in ExB. Currently the table widget in my ExB is honoring the pop-up, but I would like it to show all fields and honor field format in the web map. What specific info would help you determine if the case's match?

2.) What do you mean by 'there is a date/time format mismatch in Customize mode'? 

[EMani]

Hi @ajohnson,

Do you have any insight into why the table is being controlled by the fields selected for the pop-up?

• Use the layer's default settings to determine which fields appear for initial display, which fields ...

The customise fields config in the Table widget is for the table only.

When you click the 3 dots in the Map Layers widget and add the layer to the table, the Map Layers widget will use the pop-up configuration.

• The underlying Layer settings are determined by the config in the Visualisation tab.
• The map layer settings are determined by the config in the map. These override the above.
• The widget settings are determined by the individual widget config. These override the above.

To ensure you have the fields you require for the layer, in the Visualisation tab:

• Configure the pop-up 
• Configure the Date field
• Save

When you 'Add to table' from the Map Layers widget, all the fields should appear (as this will use the layer settings from the visualisation tab).

I just tested this, and it worked for me.

I used a new web map and a new experience, and I have not had any issues with the date format at all. It has remained just the Year throughout.

I hope this helps clarify the configuration hierarchy. Let us know if this fixes your date format and map layers 'add to table' issues.

[ajohnson]

Thank you @EMani for the link, I had missed that somehow in the ExB documentation before.

I'm sorry dumb question, which visualization tab do you mean? In the web map? I will try to reconfigure the table in the order you suggested here and see what I get.

[EMani]

You are welcome @ajohnson 🙂

The Visualisation tab is in ArcGIS Online, in the hosted feature layer's Item Details.

It's like a map viewer just for the hosted layer. Any edits made here are saved to the underlying feature layer, not just the map. For example, if you change the symbology here, then every map to which you add the layer will have this symbology. When you configure a pop-up here, it's configured for all maps. These configs can be overridden in each map/app.

You can also quickly save the layer config in the Map Viewer, in Properties/Information. 

Do let me know if you manage to resolve the date issue or have any more questions. 

[ajohnson]

Hmm weird, I just tried to set that configuration in the visualization tab and I'm still having this issue. I submitted a tech support claim and they told me it is a new defect, BUG-000183075. Thank you for all your help on this though. Unfortunately, it seems to  be a flaw in 11.5.