idea Add Records to ArcGIS Online Hosted Table in ArcGIS Online Ideas

Add Records to ArcGIS Online Hosted Table

MatthewStull1 — Fri, 30 Nov 2018 00:08:28 GMT

This idea might already be posted but I'll put it out there just in case it hasn't. This week, we were trying to edit a standalone table that is hosted in ArcGIS Online. We wanted to manually add a few records to a table but we couldn't do it from the Map interface or from the Data tab in the Item Details window. Editing was enabled on the table. The help document about editing tables in ArcGIS Online made no mention of manually adding records to a hosted standalone table. My idea then is:

Allow a user, with the proper permissions, the ability to manually add records to a hosted standalone table in ArcGIS Online (this assume the table has editing enabled).

Thank you.

Re: Add Records to ArcGIS Online Hosted Table

GB_-_ChristopherMcCollister__G — Wed, 31 Jul 2019 18:38:48 GMT

This would be great to be able to do in Collector as well.

Re: Add Records to ArcGIS Online Hosted Table

Anonymous User — Mon, 14 Oct 2019 20:17:28 GMT

This would be a great feature to bring table functionality in line with feature layers. Here is a workflow where it would be useful:

Our department has a master parks layer which contains basic attribute information about the each park property. A team working on a planning project wants to be able to run analyses on various subsets of the parks data. As such, they create a standalone table with a row for each park where and columns denoting the subset of parks used for various analyses. That table is published as a hosted feature service on ArcGIS Online. By creating a join view between the authoritative parks dataset and their standalone table, they use the resulting view to run various analyses without affecting the authoritative parks dataset. A new park is added to the authoritative parks dataset, so a new row needs to be added to the standalone analysis configuration table. Currently this appears to only be possible via:

ArcGIS Pro: You can open the table in Pro and then add a new record. This is an incredibly heavy-weight solution for adding a new row to a table.
Appending updates from an uploaded CSV or JSON: This feels like a workaround at best and is an overkill for adding a couple rows now and again.
ArcGIS Python API: I think this could be done...but it feels like overkill.
??? Some other method?

Joining spatial and non-spatial tables to one another is a common GIS and database task, but it feels like tables are being treated like tables are a bit of an afterthought. The capability to create views from table joins in ArcGIS Online has made tables a first-class item within AGOL. It is super-simple to add a new row to a feature layer. Give a little love to the tables!

Re: Add Records to ArcGIS Online Hosted Table

ChelseaRozek — Fri, 13 Dec 2019 19:48:03 GMT

How does this functionality not exist yet? I don't want to have to open the AGO table in Pro just to add a record.

Re: Add Records to ArcGIS Online Hosted Table

HeatherWidlund — Mon, 24 Aug 2020 13:14:16 GMT

Still not available? I want another user to be able to add records to a table that updates a dashboard without logging in as me and uploading a new excel file. I set up edit views with limited permissions for the tables but can't add a new record so I'm stymied in my workflow.

Re: Add Records to ArcGIS Online Hosted Table

KevinMacLeod3 — Wed, 02 Sep 2020 17:29:29 GMT

+1 for this idea, so tables and related tables can be updated

Re: Add Records to ArcGIS Online Hosted Table

ChelseaRozek — Tue, 13 Oct 2020 11:52:25 GMT

Please upvote this similar idea: Ability to add Related Records via Item Details Data tab

Another use case: tables with metrics that populate a dashboard. These tables don't have a spatial component so you can't "create a new GIS feature" to add a new record. I'm trying to get the departments to be able to maintain their own dashboards, but they aren't GIS-savvy so trying to teach them Pro hasn't gone well and exporting the table, editing it, and reuploading it is time-consuming and confusing for them.

Re: Add Records to ArcGIS Online Hosted Table

MatthewStull1 — Tue, 13 Oct 2020 15:00:11 GMT

That's a great example of why we need this. Thanks for posting to my idea!

Re: Add Records to ArcGIS Online Hosted Table

RandalGreene3 — Sat, 27 Feb 2021 12:08:31 GMT

The inability to add records to non-spatial tables is preventing me from recommending ArcGIS Online to small client who are not in a position financially or technically to use desktop licenses.

Re: Add Records to ArcGIS Online Hosted Table

JacobTully1 — Tue, 06 Apr 2021 21:09:36 GMT

Has anyone come up with a solution to this sort of appending a record/row? Seems like it would a lot easier to simply add a new record in the attribute table of the hosted record for most smaller projects?

Re: Add Records to ArcGIS Online Hosted Table

dan-es — Wed, 27 Oct 2021 16:58:27 GMT

Anyone found a solution to this yet? Been a while since this was posted. Is there still no option to add a record to a table?

Re: Add Records to ArcGIS Online Hosted Table

MelissaNorthey — Wed, 17 Nov 2021 17:46:56 GMT

I've just run into this limitation today and I can't believe it is a limitation! I have a table that I'd like a user to update in an AGOL web map or app. The table has multiple views based on it in our database that show as feature services in other web mapping applications. I published this table in a web service with editing made available and I want to give the user the power to maintain their table which includes adding records.

Re: Add Records to ArcGIS Online Hosted Table

RandalGreene3 — Wed, 17 Nov 2021 18:17:25 GMT

Thanks for keeping this thread alive, Melissa! I previously commented, but will make another appeal:

I understand that ArcGIS is a primarily spatial platform, and they've gone out of their way to provide excellent approaches for spatial data on the web - maps, app builders, surveys, stories, templates, etc. However, there seems to be an assumption that even Enterprise clients have other infrastructure or approaches for dealing with tabular data, and that is often not the case. As far as I can tell, we are expected to build custom code-based (i.e., expensive) apps or widgets directly using Esri APIs and/or published services.

Relational data is a foundation of the platform, the technology hasn't really changed much in 30 years, and it's not going away anytime soon. I suggest Esri add customizable tabular editing capabilities to web maps and app builders that includes:

Adding, not just editing, records not tied to a feature class.
Smartly presenting data for related tables and navigating among the customized editors for those tables.
Supporting dropdowns dynamically populated from records in other tables (i.e., the classic lookup table from relational database 101). Domains just don't cut it because they are not editable on-the-fly by users.

Re: Add Records to ArcGIS Online Hosted Table

MatthewStull1 — Mon, 22 Nov 2021 15:46:56 GMT

I just wanted to thank everyone who's commented on my idea/post here. ESRI just needs to do this! It's a no-brainer...

Re: Add Records to ArcGIS Online Hosted Table

TonyLau1 — Sun, 23 Jan 2022 03:45:18 GMT

+1 for this functionality. opening the table with pro just to add a row is a very involved workaround.

Re: Add Records to ArcGIS Online Hosted Table

MatthewStull1 — Mon, 07 Mar 2022 16:10:05 GMT

This problem cropped up again on me last week. Some staff members in my organization need to make some very basic updates to some hosted tables that drive some dashboards. Because they couldn't use ArcGIS Pro, their computers weren't powerful enough for it, I had to download spreadsheets and have them update spreadsheets with the new data. Then I had them send the updated spreadsheets back to me and I uploaded the spreadsheets to update (append) the table. Something that should have taken just a few minutes took at least an hour. This is so ridiculous!! Fix it!!

Re: Add Records to ArcGIS Online Hosted Table

AnthonyJonesRSK — Tue, 15 Mar 2022 17:41:36 GMT

Hi all, I've just come across this issue myself. Could a solution be to build a Survey123 form on top of the table? The form can then be used to add new records to the table. It could also be used to edit the form (to ensure some QA/standardisation) but of course this can be done from the tables item page too.

Re: Add Records to ArcGIS Online Hosted Table

MatthewStull1 — Tue, 15 Mar 2022 22:27:04 GMT

Thanks for sharing that idea of using Survey123. I will have to try to it out. Even if it does work, it's not the best/easiest solution. Maybe ESRI can make a "Table Editor" as an app or maybe just a tool within AGOL.

Re: Add Records to ArcGIS Online Hosted Table

AnthonyJonesRSK — Wed, 16 Mar 2022 09:26:05 GMT

Agree Matthew, it would be much easier to be able to do this from the item page. You can edit the table in the Data tab but it would be good to be able to add records there too. You could add the link to the S123 form to the item description page so users could access it relatively easily too. Another option is to build a quick editing app in Experience Builder until a more elegant solution made available.

Re: Add Records to ArcGIS Online Hosted Table

DanielleRogers — Thu, 24 Mar 2022 13:15:09 GMT

I was just googling to find out how to do this. I am really surprised this simple functionality isn't available directly in AGO. Would be super useful, especially when using the dashboards to present relational data. Please add this!