topic Re: pulldata() doesn't work unless using intermediary field in ArcGIS Survey123 Questions

pulldata() doesn't work unless using intermediary field

abureaux — Thu, 04 Jan 2024 21:23:50 GMT

My pulldata() works when my select_one_from_file is the same CSV as the pulldata(), but when I use a different CSV for the select_one_from_file, I need to use an intermediary field to pass along the value to pulldata().

Typically, I use the first method (select_one_from_file and pulldata() being the same CSV), so I am not sure if I just never noticed this before, or if this is new. This seems like a ridiculous limitation.

Using intermediary (select_one_from_file dumps value into 'why' field, and then 'why' goes into pulldata):

No intermediary (why' field is bypassed and select_one_from_file feeds directly into pulldata):

You'd think that maybe the select_one_from_file was returning the label instead of the name in this case for whatever reason, but I also copy-pasted the pulldata into a note and it appears that this isn't the case:

Re: pulldata() doesn't work unless using intermediary field

DougBrowning — Thu, 04 Jan 2024 21:55:57 GMT

Have seen this a few times and I think it is the order of operations. At form load it calcs that pulldata right away or before the select_one. Then it should catch the change but does not.

Two ideas. Add the new calculation=always to pulldata so it recalcs for you. Other is put a relevant on that pulldata so that it does not show, and thus does not fire the calc, until after your select_one is filled in. Probably will look nicer in the form anyway. No need to show it until the user picks a value so the flow is better.

Hope that does it

Re: pulldata() doesn't work unless using intermediary field

abureaux — Thu, 04 Jan 2024 22:11:22 GMT

I tried setting calculationMode=always, but it had no affect.

With the exception of the select_one_from_file, all the other fields are normally calculate. I just had them visible for the example.

I may bring this one up with Esri. It is acting like an unintentional bug since everything works with an intermediary. I got frustrated with pulldata not working, so now every select_one_from_file has an extra hidden text field exclusively for this purpose (sigh).

EDIT. This is the finished product:

Re: pulldata() doesn't work unless using intermediary field

DougBrowning — Thu, 04 Jan 2024 23:20:29 GMT

Did you try using a relevant?