Display a note based on number of records

195
1
01-04-2018 04:38 PM
KatjaKrivoruchko
New Contributor III

I would like to display a note in survey when it is opened (before it is submitted) when the total number of previously submitted records is equal to (or greater than ) certain number. The number of records would change very quickly, so updating the text file for use in pulldata() would not be dynamic enough.

Tags (2)
0 Kudos
1 Reply
Philip-Wilson
Esri Notable Contributor

Hi Katja,

Currently this workflow is not possible. We currently have an open enhancement request to extend the pulldata() function to support URIs (cusotm URLs) so that a feature service or hosted data source accessible via a URL can be queried and values returned using the pulldata() function. This would be the ideal solution for your workflow.

At present the only way I can think you could get this to work is to use python scripts that are automated at short intervals to query the feature service, save the results in a CSV file, upload the CSV file to the media folder of the survey and use the pulldata() function to query the result. You can also automate updating the CSV file in the media folder without needing to re-publish the survey, following this blog post: https://community.esri.com/groups/survey123/blog/2017/12/08/an-alternative-way-to-update-the-media-f.... Note that the users would still end to update (re-download) the survey to get the latest CSV file on device though.

Regards,

Phil.

0 Kudos