Hello Survey123 Community. I'm developing an application in ExB in which residents can find out about current zoning cases in our city and then they can comment on them. The comment form was developed in Survey123 Connect, specifically so we can use the address validation of the geocode appearance field. It's also set up to prepopulate information about each Zoning Case by using the pull function with a .csv.
After showing off the application to the Planning staff, their main request was to have the Survey form already selecting the Zoning Case in which they were interested and had selected from the list widget on page 1. As it is currently set up the Survey widget in ExB is on its own page and residents will have to remember which Zoning Case in which they were interested and choose it from the list.
Any suggestions on how to integrate these two? We need an automated solution since the Survey123 form will constantly be updated based on those Zoning Cases under review. Right now we have python scripts updating the behind the scenes .csvs. The existing xlxs form and csv files are attached below.
Thank you,
Shari Forbes