Hi,
Canadian postal code format is A1B 2C3. As survey 123 geocoding reverse result, we only got the first 3 characters as "reversegeocode.address.Postal". While we get the last 3 characters from "reversegeocode.address.PostalExt".
So I merged these two into one as:
pulldata("@geopoint",${location},"reversegeocode.address.Postal") + pulldata("@geopoint",${location},"reversegeocode.address.PostalExt")
It works in Survey 123 connect:
But it doesn't works in web browser.
If I only have postal code, it works but only show the first 3 characters.
Any clue? Thanks!
Fan
Solved! Go to Solution.
Hi Fan,
Try to create two null questions and each of them calculate first 3 code and the rest of 3 code. Then use 'concat' to put them together as calculate in postal code question.
E.g.Name, Calculate, Esri field type
postal_123, pulldata("@geopoint",${location},"reversegeocode.address.Postal"), null
postal_456,pulldata("@geopoint",${location},"reversegeocode.address.PostalExt"), null
postal_code, concat(${postal_123}, ' ', ${postal_456}).
Kerry
If you set Esri Field Type as null, it does not create additional fields in the actual dataset, but does work/exist within only Survey123 form. It's tricky to make both field form and web form works.. Hope you can find a solution! I am in Canada so I will be interesting how it works eventually. 🙂
Kerry
Hi Fan,
Try to create two null questions and each of them calculate first 3 code and the rest of 3 code. Then use 'concat' to put them together as calculate in postal code question.
E.g.Name, Calculate, Esri field type
postal_123, pulldata("@geopoint",${location},"reversegeocode.address.Postal"), null
postal_456,pulldata("@geopoint",${location},"reversegeocode.address.PostalExt"), null
postal_code, concat(${postal_123}, ' ', ${postal_456}).
Kerry
Thanks Kerry!
But we are using a standard data model (shared with other applications) so cannot create extra field for that. I know extra fields calculation is a work around method. But I'm seeking a direct solution base on existing field calculation.
Thanks for your advise!
If you set Esri Field Type as null, it does not create additional fields in the actual dataset, but does work/exist within only Survey123 form. It's tricky to make both field form and web form works.. Hope you can find a solution! I am in Canada so I will be interesting how it works eventually. 🙂
Kerry
Thanks Kerry!
That works!
That's great! One more tip, after you publish the survey, you can change the type of two additional question to 'hidden' (I assume you used 'text'), the re-publish it. Then they won't be displayed for end users.
Kerry
Yeah, I set them hidden in the beginning. 😁
The issue of the Canadian postal code not being pulled in a web browser as a Geocoding reverse function can occur due to several factors. Here are some potential reasons and solutions:
1. Incorrect Format:
2. Geocoding Service Limitations:
3. Privacy Restrictions:
4. Data Quality or Coverage:
Potential Solutions:
For more specific help, please provide additional details about:
i have solved this issue on my website canada postal code