I'm trying to construct a URL to launch the Survey123 app from a field within my table and using calculate to do so. The problem I'm running into is that the SQL calculate tool will convert any question marks (?) that I have in my URL to a colon (:). For example, I input the following string:
'https://survey123.arcgis.app?itemID=123456xxx12345xxx12345xxxx'
and after running the calculate, it converts to
https://survey123.arcgis.app:itemID=123456xxx12345xxx12345xxxx
Anyone know of a way around this? I've tried using double question marks (??) but it converts to @. I've tried using question mark in brackets [?] but it converts to [:]