AnsweredAssumed Answered

One to Many relationships using XLSForm

Question asked by PrillLake on Mar 21, 2019
Latest reply on Mar 25, 2019 by JTedrick-esristaff

We are attempting to user Survey123 to replace a paper-based field form.  This form is used by appraisers to gather information about a property when field-checking new building permits. 


We have three tabular data sources (permits, land segments, improvements), and would like to prepopulate the survey form with records from all 3, based on the user entering the property ID.  Pulldata() is working for the permits table, where there is a 1:1 relationship with the property ID.  The other two tables have a 1:M relationship, where one property can have many land segments and improvements.  To illustrate, attached is a screen grab of how we would like to display the 1:M land segments in the Form.


Can this be done using Survey123? We can publish this data as a feature service if needed. Or, is this workflow better suited to Collector?