I am trying to create a link in the popup that opens a S123 Form... This is working for the most part but not for one Field...
I am querying the data to only place in the inbox if there are records there. So if the permit number exists in the original data and exists in the form data it will populate those records in the INBOX and allow the user to update.
This works for a bunch of fields except the one I want... Its a string Field in both datasets with a length of 50. I cant figure out why it works for some fields but not others. I get the ERROR below
ANY THOUGHTS?
<a href="arcgis-survey123://?itemID=3f48f39xxxxxxxxxxx4a997ff0&
portalUrl=https://xx.xxx.xxxx.gov/portal&
action=edit&
folder=inbox&
update=true&
// THIS DOES NOT WORK -- THIS IS A STRING
q:where=PERMITNUM={PERMIT_NUMBER}&
// THESE ALL WORK -- ONE IS A STRING AND ONE IS AN INTEGER
q:where=PREFIXNUM={PERMIT_PREFIX_NUMBER}&
q:where=PERMIT_INTERNAL_ID={PERMIT_INTERNAL_ID}&
callback=https://fieldmaps.arcgis.app"
rel="nofollow ugc" target="_blank">Update Logsheet Inspection</a>
</div>
OK I figured it out. but now dont know what to do...
The field in question is a permit number with this format.. xxx-xxxx
it appears the - is causing the issue... Anyway I can modify the query to not choke on the - dash in the field value?
Could you create a copy of PERMITNUM that doesn't have the dash, purely for the query? May be the simple solution.
I believe you need to encode your URLs? There is an Arcade function for this. Some survey123 community posts or blogs cover it.
Unencoded strings may have issues parsing special characters in string values.