topic Re: Pre-populate fields based on someone's else's input in ArcGIS Survey123 Questions

Pre-populate fields based on someone's else's input

Anonymous User — Thu, 24 Aug 2017 13:57:21 GMT

I'm working with our local mosquito abatement workers to create a Survey123 form to track service calls. They would like their dispatchers to be able to complete certain sections of the form (i.e., customer name, address) but have the field workers complete the remaining sections. Is there a way to do this?

They were trying to use Workforce and integrate the survey but unfortunately it doesn't allow for customization to suit their needs.

I also read about the pulldata() function but we would need a CSV file that could be updated by multiple dispatchers daily.

Re: Pre-populate fields based on someone's else's input

AdamZiegler1 — Thu, 24 Aug 2017 18:35:40 GMT

Hi Brandon - This is possible in Survey123 Connect. There is an option called Inbox that allows you to update existing features/surveys. Here's a brief video on the option. Survey123 for ArcGIS: Editing Existing Data with Survey123 for ArcGIS - YouTube

Another option is using one of the Crowd Source templates to have content entered and then use Collector to update the features in the feature layer. There is a pretty full mosquito suite on solutions.arcgis.com.

Public Works - Manage Mosquito Populations | ArcGIS for Local Government

-Adam Z

Re: Pre-populate fields based on someone's else's input

Anonymous User — Thu, 24 Aug 2017 20:16:50 GMT

Thanks Adam, I think this is getting me on the right track.

If I wanted to enable my inbox but only pull entries from that day would I put something like date = (today)? in the query section?

Re: Pre-populate fields based on someone's else's input

JamesTedrick — Thu, 24 Aug 2017 20:56:04 GMT

Hi Brandon,

You should be able to do this with:

date = CURRENT_DATE

See Standardized SQL functions in ArcGIS Online—ArcGIS Online Help | ArcGIS for more information on what is supported in the where statements

Re: Pre-populate fields based on someone's else's input

Anonymous User — Fri, 25 Aug 2017 15:10:58 GMT

Hi James,

I keep getting an error message: Code 400 Cannot perform query. Invalid query parameters.

Any thoughts as to why?

Re: Pre-populate fields based on someone's else's input

AdamZiegler1 — Fri, 25 Aug 2017 15:13:45 GMT

Did you replace the 'date' with the name of your Date field?

Adam Z

Re: Pre-populate fields based on someone's else's input

Anonymous User — Fri, 25 Aug 2017 15:25:43 GMT

Yes I have

Re: Pre-populate fields based on someone's else's input

Anonymous User — Fri, 25 Aug 2017 15:48:53 GMT

I think it might have something to do with the time being saved with the date so it's not finding the "exact" CURRENT_DATE. I also tried GETDATE(). It didn't return the error but didn't provide any results either.

Is there a work around for that? Do I have to format my date field to be only date with no time somehow or query by current_date-1?

Re: Pre-populate fields based on someone's else's input

JamesTedrick — Fri, 25 Aug 2017 19:56:42 GMT

Hi Brandon,

I was a little sloppy with my initial answer. Aside from issues of the exact moment, you also would have issues of UTC time zone storage. You can do this as a date range:

DATE BETWEEN CURRENT_TIMESTAMP - 1 AND CURRENT_TIMESTAMP

Re: Pre-populate fields based on someone's else's input

Anonymous User — Fri, 25 Aug 2017 20:09:11 GMT

Thanks James,

That is almost exactly the expression I came up with... after yelling a few choice words at my computer haha.

I actually wound up using the CreationDate field for query, so it came out looking like this:

CreationDate BETWEEN CURRENT_TIMESTAMP AND CURRENT_TIMESTAMP-1

Thanks again for all the help!