Hi there,
Would like to know if there is a way/work around to show the instance_name from a select_one value?
survey tab
settings tab
As seen from the mobile app, I could not see the values for estate_id and estate_name.
Hope someone can help me understand and let me know the workaround so that the instance_name will capture the estate_id and estate_name?
Thanks,
Pauline
Solved! Go to Solution.
Hi Pauline,
I managed to get the 2 values to concatenate and they are now showing fine.
I noted that you had a space in your concat function on the settings tab, removing this seems to have solved the issue. Also recieved an error about missing labels for the 2 estate name fields, which I added.
Hope this helps!
Albert
Hi Pauline
From your screenshots I can't see a reason why the instance_name is blank. Could you please provide your XLS and CSV files so I can attempt to troubleshoot?
Is the pulldata() function working correctly in the survey form?
Thank you,
Jim
Hi Jim,
I can see the estate_id now but not the estate_name.. suspect it could be due to the select_one type. Anyhow, here are the files:
estate_list.csv
survey.xls
Thanks,
Pauline
Hi Pauline
Thanks for the files. The link you've provided for 'estate_list.csv' opens an XLSX file. Just to confirm, is the estate_list.csv in your survey's media folder a CSV file? If you open it in a text editor it should look like this:
Using a CSV file as per above, I get the correct instance name in Outbox, Sent, etc.
Also I notice the labels for your 'estate' choice list are the same as the estate names in the CSV. In this case, instead of using pulldata() you could use the jr:choice-name() function to return the label for the choice. So the calculation would look something like: jr:choice-name(${estate_id}, '${estate_id}')
This function is documented here Formulas—Survey123 for ArcGIS | Documentation and here Cascading and external selects—Survey123 for ArcGIS | Documentation.
Best,
Jim
Hi Jim,
You are right. I need to save it as a csv file. Thanks for the guide. Will look into it possibly using jr:choice-name().
Regards,
Pauline
Hi Pauline,
I managed to get the 2 values to concatenate and they are now showing fine.
I noted that you had a space in your concat function on the settings tab, removing this seems to have solved the issue. Also recieved an error about missing labels for the 2 estate name fields, which I added.
Hope this helps!
Albert
Hi Albert,
Yup deleting the space in between the concat and '(' helps! Thanks for helping out.
Regards,
Pauline
Hi Pauline,
Glad that helped. Could you please mark the comments as helpful?
Thanks again.