topic Re: Survey123 | Inbox | Where code help needed in ArcGIS Survey123 Questions

Survey123 | Inbox | Where code help needed

CarissaPhantom — Mon, 06 Dec 2021 17:37:29 GMT

What I have

AssignedInspector3 = ${username} OR highRISK='Contractor BMP Required'

Backstory: I have two different sub-contractors that each work in their own way.

Sub-contractor 1 - assigns an inspector to a point ---AssignedInspector = ${username}

Sub-contractor 2 - let's the inspector choose which site are closest to them --- highRISK='Contractor BMP Required'

I'd like to get the Sub-contractor 2 data to only populate the inbox if they belong to a specific company. Is there a way?

ZacharySutherby — Fri, 10 Dec 2021 02:19:35 GMT

You'll likely need to use the concat() function to append quotes around the ${username} question. What I would suggest is

concat("AssignedInspector3 = '", ${username}, "' OR highRISK='Contractor BMP Required')

or even

AssignedInspector3 = concat("'",${username},"'") OR highRISK='Contractor BMP Required'

should work

CarissaPhantom — Wed, 23 Nov 2022 20:11:19 GMT