Is there any way of creating a dynamic spatial Join in ArcGIS Online? As an example, our use case is that we have have species point data being generated via a Survey123 form. We want that point data to be visualised in a dashboard/webmap publicly but at a coarser resolution. To do this, we want to spatially join the attributes from the species points to a grid (e.g. 10km). However, using the Join Features analysis tool in ArcGIS Online only allows the creation of a new, static, layer if using a spatial join. It is possible to create a (dynamic) hosted feature layer view if using a join based on attributes. However this latter option is not suitable for us as it would require assigning the relevant spatial attributes (e.g. grid id or other spatial id) to every new record that comes in. I have also looked at the Aggregate Points and Summarize Within tools but neither of these can be used to create a hosted feature layer view, and neither are running successfully for me in any case (Failed - "the number of features is zero").
