I have been developing a survey and recently found out in order for the survey to be useful it needs to be able to show the existing records for each survey site. Existing records are stored in multiple SQL tables. I am new to Survey123 and am wondering if it possible to attach these existing records and use them to populate fields as default values so the field worker wont be starting from scratch each time (most surveys involve validating current data with little to no changes being made). If the field user types in a site id as a unique identifier could this prompt the application to locate the matching record and populate the 60 + fields in the survey with the existing data? Additionally, the information needs to be available for offline use. Could this be accomplished through linking/downloading the records to the survey as a CSV file or through joining the records to the spatial feature in AGOL and attaching those to the survey? Is there a better workflow or even application to accomplish this? Any help appreciated.
