Survey123 related to multiple geography layers

deleted-user-H23pxZFaj1tR · ‎08-12-2019

I have a web map with four static geographies, four bridge tables, and a single report table. Reports can refer to one or more of each of the geographies. For example, a report could be attributed to 4 Counties, 1 State, and 2 Regions.

The survey needs to create a report record, and multiple entries in the bridge tables. I'm thinking that using select_multiple would allow a report to be associated with multiple counties, for instance. Then I would want four select_multiple questions, one for each geography.

First question is can the select_multiple questions be populated with the geography names from the related tables? Should I use an external choice list in this survey?

Second, will this work with bridge tables that have two GUID foreign keys, one to Geography tables and one to Report table?

Third, if the hosted feature service contains the items described in the first sentence above, can a single Survey123 record submission enter data in all four of the geography bridge tables? Would this mean multiple submission_url's? It seems this poster got it to work on the web client, but should I consider re-architecting to have a single bridge table?

Any advice would be appreciated!

JamesTedrick · ‎08-13-2019

Hi David,

Select_multiple questions can be used to denote multiple geographies apply to this report, though the linkage to the origin data table is a little more complicated than normal (you would use a 'LIKE #VALUE#' sql query to join, for example). That being said, I don't believe Survey123 can necessarily meet exactly what you are describing at this time. Select_multiples currently cannot be used in a cascading select.

Regarding populating multiple GUID keys, that should be possible through a lookup function like pulldata().

deleted-user-H23pxZFaj1tR · ‎08-13-2019

Thank you for the response and explanation! Would it work to have multiple single choice cascading select questions which could display only if the previous one was filled?