topic Re: format field in table widget in ArcGIS Experience Builder Questions

format field in table widget

Anonymous User — Sun, 11 Jul 2021 03:46:12 GMT

Hello All,

Can someone tell me how to format a field in a table widget so that a URL appears as a clickable link?

Thanks!

--john

Re: format field in table widget

DrVSSKiran — Sun, 11 Jul 2021 07:17:09 GMT

Hi,

No need to enable or format separately for URLs. When you format the table make sure the column type is a string and you can enter the URL in the attribute value. Once it's published you just add the attribute table widget in your web app builder, and you will clearly view the clickable URL in the table.

Re: format field in table widget

JayantaPoddar — Sun, 11 Jul 2021 07:25:24 GMT

Here is a neat way to do it.

Ensure the Hyperlink (Text) field is long enough to accommodate the URLs along with its formatting elements.

You can format the field like this

<a href="file://filepath" target="_top">hyperlinkname</a>

In my example, it looks like this in ArcGIS Pro

Once published (Shared as web layer), it looks like this, in ArcGIS Online Map Viewer as well as in Experience (Table Widget).

FAQ: Is it possible to add a hyperlink path to a field in ArcGIS Pro?

Re: format field in table widget

Anonymous User — Sun, 11 Jul 2021 18:40:46 GMT

Thanks for your reply, but that doesn't seem to be working for me (see screenshot below). This is a text field from a hosted FeatureLayer. Works fine in the popup, just not in the table widget.

Re: format field in table widget

Anonymous User — Sun, 11 Jul 2021 18:47:27 GMT

Thanks for your reply and suggestion. In this case, I published a file geodatabase to AGOL and created a FeatureLayer at the time of publishing. The field shows as type "String" and length 200 (enough for this this URL). I wonder if the problem is that some of the records contain "NA" rather than a valid URL?

Re: format field in table widget

JayantaPoddar — Mon, 12 Jul 2021 04:44:52 GMT

Is it a Hosted Feature Layer?

Then go to its Item Details Page > Data tab >Fields. Add a new Field (Text). Keep the default length, if not more.

Next, click on the Table tab (Next to Fields tab)

Click on the newly created Field Name > Click Calculate > Choose Arcade.

In the Arcade Calculator, write a similar expression.

IIF($feature.IMAGEURL=='NA','NA',<a href="' + $feature.IMAGEURL + '"target="_top">' + $feature.SCIENTIFICNAME + '</a>')

You should be able to click the link from this field from both the new Map Viewer as well as the Table Widget of Experience.