Calculation being overridden by Search()

Question

How can I set the default selection for my select_one dynamic list made with a search() appearance, preferably using pulldata() under the calculation field?

I'm using a search appearance pointing to a feature layer to populate a select_one list in Survey123 Connect. I am also using pulldata calculations throughout the form, pointing at the form's feature layer to autofill the last responses from the same vehicle.

For some reason, both the calculation and default fields for the question with search() are overridden with the list provided by search(). This defaults to a blank value, but has the pulldata() value as an option from the search() list.

I have calculationMode=always set in the bind::esri:parameters column.

The entire survey works well other than this. Looking at "select_one stockpile_letters" in this screenshot:

See attached spreadsheet.

I believe the same thing could be done via locally saved .csv files if all our users had the app, but most of them will be accessing this through a web browser.

Haul Tickets for Sharing.xlsx

dougbrowning · Answer

Ok that makes sense then.  I think the order is off.  Is there i way you can add a relevant. So it does the pulldata then the field comes on?  That way you can control the order.

Ford_Rundell · Answer

I am using the search() appearance to set the list of options, and pulldata() to set the default/autofill value from that list of options, based on the user's last submitted survey.

dougbrowning · Answer

Are you trying to use the calculation field to set the items the user sees in the list?  If so that is not how the calculation column works - it is used to set what values are selected.   Search should be the one the changes the list options.  Sorry I am lost here still.  I get what you are trying to do just not sure why you have both search and pulldata.