I am trying to create a way for workers in the field to be able collect data (through either survey123 or survey forms that are linked to a webmap viewable in collector), and for this data to update related data in one of our geodatabases for use in ArcGIS Pro, ArcMap, etc.
What I've done so far is I've created a feature service with a standalone table with a relationship class relating the two. I have also created a survey in survey123 based on this feature service (When forms are submitted, they do successfully populate the feature service and the related table). I am wondering if there is a way to append this data to a geodatabase in real time?
Thank you for your help,
GIS Intern - IF Power
You generally want a hosted feature class or Enterprise geodatabase table for dynamic tables, since multi-user access with ACID (Atomicity, Consistency, Isolation, Durability) is an intrinsic feature of RDBMS.