I need help since I haven't found a related post to my problem.
I am preparing a Survey with Surve123 Connect (version 3.13.249) and a need to autocomplete 3 fields with date store in a table inside my AGOL.
I cannot store the table in the "media" folder since the Table is being constantly and automatically updated.
The example is: Survey will be used from a laboratory to collect data from water samples. But the field "active_cases" and "Incidence" shall be populated with the latest values which are found in the separate table.
I know there is a way to pull date from a different future service, but not sure how i can do this for a table. I am not that good with scripts.
Is there a way to do so? Thank you so much and kindest regards,
Hi Dory! I'm currently creating a survey with two different workflows that may help you. One is to create a dynamic list with the search() function in the appearance column. You must use this with select_one or select_multiple question types.
thanks for your prompt response, I really need help indeed.
Could you possibly post some links of any posts which deal with something similar so I can try to see if I can copy from them?
Thank you very much and kindest regards,
I've attached a screenshot of my survey and a file of my script. Copy the text file in a new Survey123 script and change the feature layer and query parameters to return what you're looking for. It was a lot of trial and error. I found it helpful to create queries in the feature service REST api to match the query URL with the query parameters returned with the script.
I hope this helps!
You can also link to a hosted CSV in the linked content tab of Connect. The CSV will be stored in the media folder, and each time the survey is opened in the field app the CSV will be updated if there have been any changes to the hosted version.
See the External choice lists section of the Survey123 documentation for more info.