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

[Anonymous User]

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.

[AdamZiegler1]

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

[Anonymous User]

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?

[JamesTedrick]

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

[Anonymous User]

Hi James,

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

Any thoughts as to why?

[AdamZiegler1]

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

Adam Z

[Anonymous User]

Yes I have

[Anonymous User]

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?

[JamesTedrick]

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

[Anonymous User]

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!