topic Re: Is it possible within a survey123 smart form to notify the surveyor if a survey on the same site was done in last 15days? in ArcGIS Survey123 Questions

Is it possible within a survey123 smart form to notify the surveyor if a survey on the same site was done in last 15days?

LemuelM-MDC — Wed, 10 May 2023 18:24:33 GMT

Hi All,

Is it possible within a survey123 smart form to notify the surveyor if a survey on the same site was done in the last 15 days?

Thank you in advance.

Lemuel M.

Re: Is it possible within a survey123 smart form to notify the surveyor if a survey on the same site was done in last 15days?

IsmaelChivite — Thu, 11 May 2023 20:32:15 GMT

Yes.

You will need to use the pulldata("@layer") function for this. I attached an XLSForm example.

Notes:

The pulldata function allows you to query a layer. You will want to query the inspection's layer with a query that looks something like this:

assetID='100' and inspectionDate BETWEEN CURRENT_TIMESTAMP - 15 AND CURRENT_TIMESTAMP

For your pulldata query to work, your survey layer MUST allow the query operation
The pulldata("@layer") function only works when you are connected (it will not work while offline)

To setup the XLSForm:

Take the attached XLSForm, load it into Survey123 Connect and publish it
Go into the item details page of the survey layer created by Survey123 Connect and make sure you enable queries in your surveys layer
Get the URL of your layer and replace it in row 8 of yourXLSForm. Re-publish your survey and use either a web browser or the mobile app to add one or more records to test.

Hope it helps.

Re: Is it possible within a survey123 smart form to notify the surveyor if a survey on the same site was done in last 15days?

LemuelM-MDC — Thu, 11 May 2023 21:42:34 GMT

Thank you so much Ismael. This works beautifully. The sample survey with your instructions helped a lot too. I will just let the user making the request know that the function would only works while online, and let him pick. Thanks again.

Best Regards.