Select to view content in your preferred language

LInk from WebMap to S123 form

476
3
12-27-2023 09:29 AM
kapalczynski
Frequent Contributor

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&amp;
portalUrl=https://xx.xxx.xxxx.gov/portal&amp;
action=edit&amp;
folder=inbox&amp;
update=true&amp;
// THIS DOES NOT WORK -- THIS IS A STRING
q:where=PERMITNUM={PERMIT_NUMBER}&amp;
// THESE ALL WORK -- ONE IS A STRING AND ONE IS AN INTEGER
q:where=PREFIXNUM={PERMIT_PREFIX_NUMBER}&amp;
q:where=PERMIT_INTERNAL_ID={PERMIT_INTERNAL_ID}&amp;
callback=https://fieldmaps.arcgis.app" 
rel="nofollow ugc" target="_blank">Update Logsheet Inspection</a>
</div>

 

kapalczynski_0-1703698157906.png

 

 

0 Kudos
3 Replies
kapalczynski
Frequent Contributor

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?

 

0 Kudos
abureaux
MVP Frequent Contributor

Could you create a copy of PERMITNUM that doesn't have the dash, purely for the query? May be the simple solution.

0 Kudos
ChristopherCounsell
MVP Regular Contributor

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.

0 Kudos