Display a note based on number of records

[KatjaKrivoruchko]

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.

[Anonymous User]

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.

[Anonymous User · Accepted solution]

Hi @KatjaKrivoruchko,

Just wanted to let you know with the upcoming 3.16 October Release of Survey123 we have extended the pulldata() function to now include spatial searches and URIs. You can find the latest announcements, documentation and test out the latest 3.16 beta builds via the Early Adopter Community to get early access to these builds.

Regards,

Phil.