Is it possible to use the WHERE clause option in Survey123 Connect to limit who can see what survey in the Inbox?
Scenario: We have created a Survey that we want to share with contractors, but we only want the contractors to see they surveys that they submit, but we want our internal people to see all of the surveys, submitted by contractor or internal employee.
Creator = ${username} OR ${username} IN ('yourUserName', 'yourOtherUserName')
Using that in the WHERE clause allows you set it to where anyone in the IN statement can see everything, otherwise, the user just sees the surveys that they submit/
I think your best bet for this is to create two surveys, and two user groups in arcgis online.
Group 1 Internal people, give them access to a survey with no restrictions.
Group 2 Contractors, give them access to the survey with a where clause.
and then set the where clause to user or if all contractor can see all contractor surveys then create a field in the form that record "contractor" depending on user
Creator = ${username} OR ${username} IN ('yourUserName', 'yourOtherUserName')
Using that in the WHERE clause allows you set it to where anyone in the IN statement can see everything, otherwise, the user just sees the surveys that they submit/
