https://community.esri.com/t5/arcgis-online-questions/updating-a-join-to-be-used-in-a-web-experience/m-p/1333606#M54822 <P>Hello,<BR /><BR />I have built a fairly robust Web Experience that relies heavily on a single hosted feature layer and its attribute table, which is based on a joined hosted table.<BR /><BR />This feature layer depicts survey respondents from a 3rd party platform, and over time we will need to add new points to the map representing new respondents.&nbsp; The survey does not include reliable address data and so ideally we would create the geography manually.&nbsp;&nbsp;<SPAN>When there are new respondents, I'm given a CSV of results that is formatted appropriately to join to my hosted Feature Layer.&nbsp;<BR /><BR />I have created a hosted feature layer view for this data.&nbsp; My workflow is to manually create a new point for each new response in a hosted feature layer that is just points and a join field (because address data is unreliable), and then use that CSV to update the attributes.<BR /><BR />Doing this via the Hosted Feature Layer View settings tab doesn't appear to work without address data.&nbsp;</SPAN></P><P>Trying to do it a bit more manually in a webmap, the problem is that when I run the join, the feature layer view will not update or overwrite - I am directed to create a new feature layer view with a new name.&nbsp; which means everything in my Web Experience has to be rebuilt, which is okay once but not feasible 100 times over.<BR /><BR />How should I navigate this situation, where a hosted feature layer needs to be updated regularly via a join and I can't use address data?</P><P>Thank you.&nbsp; &nbsp;&nbsp;</P> Thu, 28 Sep 2023 21:56:00 GMT sgambrel_Bouldercounty 2023-09-28T21:56:00Z https://community.esri.com/t5/arcgis-online-questions/updating-a-join-to-be-used-in-a-web-experience/m-p/1333606#M54822 <P>Hello,<BR /><BR />I have built a fairly robust Web Experience that relies heavily on a single hosted feature layer and its attribute table, which is based on a joined hosted table.<BR /><BR />This feature layer depicts survey respondents from a 3rd party platform, and over time we will need to add new points to the map representing new respondents.&nbsp; The survey does not include reliable address data and so ideally we would create the geography manually.&nbsp;&nbsp;<SPAN>When there are new respondents, I'm given a CSV of results that is formatted appropriately to join to my hosted Feature Layer.&nbsp;<BR /><BR />I have created a hosted feature layer view for this data.&nbsp; My workflow is to manually create a new point for each new response in a hosted feature layer that is just points and a join field (because address data is unreliable), and then use that CSV to update the attributes.<BR /><BR />Doing this via the Hosted Feature Layer View settings tab doesn't appear to work without address data.&nbsp;</SPAN></P><P>Trying to do it a bit more manually in a webmap, the problem is that when I run the join, the feature layer view will not update or overwrite - I am directed to create a new feature layer view with a new name.&nbsp; which means everything in my Web Experience has to be rebuilt, which is okay once but not feasible 100 times over.<BR /><BR />How should I navigate this situation, where a hosted feature layer needs to be updated regularly via a join and I can't use address data?</P><P>Thank you.&nbsp; &nbsp;&nbsp;</P> Thu, 28 Sep 2023 21:56:00 GMT https://community.esri.com/t5/arcgis-online-questions/updating-a-join-to-be-used-in-a-web-experience/m-p/1333606#M54822 sgambrel_Bouldercounty 2023-09-28T21:56:00Z https://community.esri.com/t5/arcgis-online-questions/updating-a-join-to-be-used-in-a-web-experience/m-p/1334041#M54837 <P>Hi&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/491853">@sgambrel_Bouldercounty</a><BR /><BR />Could you relate the feature class and table using a relationship class rather than a join?&nbsp;<BR />Recent changes to AGOL allow you to create a pop-up and a form that allows you to view related records and edit related records.&nbsp;</P><P><BR /><A href="https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-related-record-editing-in-map-viewer/" target="_blank">https://www.esri.com/arcgis-blog/products/arcgis-online/mapping/introducing-related-record-editing-in-map-viewer/</A><BR /><BR /></P> Mon, 02 Oct 2023 03:59:00 GMT https://community.esri.com/t5/arcgis-online-questions/updating-a-join-to-be-used-in-a-web-experience/m-p/1334041#M54837 gis_KIWI4 2023-10-02T03:59:00Z