I have a domain/list set up for data collection in AGOL and using the Field Maps app for data collection. When planting a new plant or documenting an existing one, our field staff will select the species from the dropdown menu. Our aim is to keep data collection in the field as easy as possible for field staff and reduce the potential for data entry errors. There are multiple attributes that relate to the species they select. We have this species information stored in a separate, non-spatial table. I would like for the hosted feature layer to reference this non-spatial data and fill in the related attributes.
I have thought of and seen some workflows, but they would require the feature layer to be re-published. I do not believe that would work with our offline data collection workflow. Re-downloading the offline map every time is not an option. Please do tell me if I am mistaken in that assumption.
In databases and spreadsheets, it is a pretty simple lookup command. Survey123 has the pulldata command. I feel like I am overlooking something here, as I haven't been able to figure it out in AGOL or ArcGIS Pro. While manual editing in ArcGIS Pro is simple enough, the longer process to select each species and use the field calculator is not as efficient as I believe it should be, especially for ongoing data collection. And before I go too far down developing one method or other, will Model Builder or Python be my best path forward? The best solution would be a readily available workflow that I have overlooked.
Thank you!
