I have a form to gather information about new projects. I want to use a search() function to generate two dynamic dropdown lists with possible companies and contacts from an existing Client table. The Client table is published to ArcGIS Online and shared publicly.
Users will first select a Company from the drop down and the Contact drop down will filter based on the selected Company. Both of these selections appear to work properly in Survey123 Connect, but the Contact drop down does not populate with values in the web app.
I did get the Contact drop down to populate, but only when I defined a value as the search text and not with ${ExistingClients} like I need (attached).
UPDATE: The Contact drop down only works if I specify a search text without a spaces.
Ex: search(tableName, 'matches', 'Company', 'LIVIC') will work and populate with possible Contacts, but search(tableName, 'matches', 'Company', 'LIVIC Civil') or search(tableName, 'matches', 'Company', ${Company}) will not.
I based the search() functions off a different form with the same parameters and workflow that does work in the web app, so I am not sure why this form is not working properly. The web app is behaving strangely and I'm not sure what else I can try to troubleshoot this issue. Any suggestions would be appreciated!
The form was created in and published from Survey123 Connect version 3.18.