topic Re: Continued issues with pulldata in web forms in ArcGIS Survey123 Questions

Continued issues with pulldata in web forms

WetherbeeDorshow — Mon, 20 Aug 2018 20:56:36 GMT

I used the sample called "Calculate Location from CSV", modifying the sample slightly to point to an updated pulldata table and to use different field names. I still get the error: FormLogicError: instance "lift_locations" does not exist in model. I attached the survey and the pulldata table. Thanks for the help.

Re: Continued issues with pulldata in web forms

JamesTedrick — Mon, 20 Aug 2018 21:06:44 GMT

Hi Wetherbee,

pulldata() functions are not designed to occur within other functions. The best practice would be to have a hidden question store the value looked up via pulldata() and reference that question in the question with the concat function. If you do not want to write the hidden question to the feature service, set the bind::esri:esriFieldType setting to null to have the form ignore that question on submission.

Re: Continued issues with pulldata in web forms

WetherbeeDorshow — Mon, 20 Aug 2018 22:22:11 GMT

I actually did what you suggest. Still not working. Please look at attached? Many thanks!

Re: Continued issues with pulldata in web forms

WetherbeeDorshow — Mon, 20 Aug 2018 22:32:55 GMT

What I should have written is that I mimicked the sample included with survey 123 directly, which uses the pulldata statement within a function. If that is not a best practice, I am surprised to see it included as an official sample. The sample works. Just cannot figure out why my version does not.

Re: Continued issues with pulldata in web forms

JamesTedrick — Mon, 20 Aug 2018 22:36:11 GMT

Hi Wetherbee,

Yes, you are correct that the sample needs to be updated. It functions because there are other pulldata() functions that exist by themselves - they provide enough information for the form to work around the issue.

Re: Continued issues with pulldata in web forms

JamesTedrick — Mon, 20 Aug 2018 22:37:32 GMT

Did you provide an updated Excel sheet? I only see the version in the initial post, which has a pulldata() function within a concat().

Re: Continued issues with pulldata in web forms

WetherbeeDorshow — Mon, 20 Aug 2018 22:47:51 GMT

OK, I attached an updated version of both the survey and the pulldata table

Thanks

Re: Continued issues with pulldata in web forms

JamesTedrick — Mon, 20 Aug 2018 22:51:09 GMT

Hi Wetherbee,

The issue is that the pulldata function is still inside another function - in this version the number() function. Pulldata() must at minimum begin the question - if you migrate the number() functions to the geopoint question, it will work.

Re: Continued issues with pulldata in web forms

WetherbeeDorshow — Mon, 20 Aug 2018 23:14:36 GMT

Yep, that did it. Once I calculated the lat and lon from the pulldata table (as strings), I

concat(number(${lat}),' ',number(${long})

Many thanks

Re: Continued issues with pulldata in web forms

KathrynLevy1 — Fri, 24 Aug 2018 20:42:43 GMT

Could you post the form with the correct calculation structure? I am having the same issue and would like to see how you resolved it in the xlxs form.

Thanks

Re: Continued issues with pulldata in web forms

WetherbeeDorshow — Thu, 30 Aug 2018 19:20:09 GMT

I have attached the form and the pulldata table. Best of luck.

Re: Continued issues with pulldata in web forms

daveostrander — Mon, 02 Nov 2020 19:45:43 GMT

Hi James,

"pulldata() functions are not designed to occur within other functions." Does this also extend to nested IF statements? I want to use the pulldata() function depending upon the input of a previous question.

Thank you,

dave-o.