Extract related feature data from Survey123 Repeat Questions inline with the rest of the survey

RyanCarlson

I am relatively new to creating Survey's using Survey123 connect.  I built a survey to collect watershed project tracking data from various partners.  I used repeat questions to allow users to add multiple pollution reduction values.  What I have learned, is that within the feature class it creates a related table to store this data.  Is there a way to have all of the data displayed together instead of within a separate table? 

I chose to use repeat questions to make the survey cleaner for the end users. 

If I can't display the data within one row, should I pivot to using different pages to keep the user interface clean while allowing the data to be recorded into one row instead of within related tables? 

Any thoughts would be much appreciated! 

Neal_t_k

So you have a lot of options here from handling in the survey form to post processing.  But if you want all the information in one line and want to handle it in the survey. Use your repeat table to collect all the information.  In the main part of form collect all the information you only need the user to answer once, then in the repeat section use a bunch of hidden fields and calculate them to answers from the main form you want to see with the repeat data.  This way users aren't entering redunantly, but you are getting the format of the table you want to see on the backend. 

Some other options could be to make a layer view with a join; dashboard/ExB to show data as you want to see; python script to periodically perform a 1 to many join creating a new feature service showing all the data in one table.