Can I replace the use of a master CSVs for S123 with FieldMaps?

Question

I have developed 2 rather complex freshwater species surveys.

They both use an external CSV to pull in the station they are being taken at.

Turns out that multiple surveys will use the same monitoring point.

I don't want to have to manage multiple CSVs for these monitoring points.

Can I create and manage these monitoring points in Collector/FieldMaps and then link the species surveys to them?

I know I can link to a master CSV in ArcGIS Enterprise but would like the Freshwater Monitoring Stations as an asset layer that can be managed spatially.

Any help appreciated.

DAVIDMCCOTTER48 · Answer

I'm thinking of placing the CSV data as its own feature as it represents river monitoring stations and then using FieldMaps to launch the different S123 types from there.

I think it can be done with related tables but I haven't built the surveys with this in mind. They are standalone at the moment. Can I retrospectively apply them as related to the monitoring station Feature?

DavidSolari · Answer

The easiest way to work with data from other services is the "Search" method to populate choice lists, this blog post covers everything you need to know.

If you need a more complex integration (e.g. pulling the survey's geometry from another service using a matching field value) you'll need to combine the pulldata function with a @layer query, this blog post covers that too.

Note that none of these methods play nice with offline data collection as Survey123 won't cache service data ahead of time. If your users are collecting data off the grid then you'll have to use CSV files.