topic Re: "Search, or Find function for Calculation in ArcGIS Survey123 Questions

"Search, or Find function for Calculation

MarkBennett — Fri, 08 Dec 2017 19:39:11 GMT

Dear all,

I need to calculate for a field based on the position of a substring in another question. It should be similar to the SEARCH("search string", "String Value", start position) in Excel or Find function.

I need to do a "auto-fill" for a field using a substring in a provirus question. I need to find the numbers of starting and ending position for the "substr" function.

Thanks!

Ming

Re: "Search, or Find function for Calculation

JamesTedrick — Tue, 22 Jun 2021 08:51:14 GMT

Hi Miing,

Unfortunately, there is not a function to search of a string and return it's position in the XLSform specification. We are looking into ways to support additional functions beyond the XLSForm spec - this request is similar to https://community.esri.com/ideas/14267 (the ability to parse is the same need for variable length substr)

Re: "Search, or Find function for Calculation

MarkBennett — Sat, 09 Dec 2017 00:14:21 GMT

Thanks for let me know!

Ming

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

Re: "Search, or Find function for Calculation

MarkBennett — Tue, 30 Jan 2018 14:16:23 GMT

Is there any update on this function in the new release?

Thanks!

Re: "Search, or Find function for Calculation

JamesTedrick — Tue, 30 Jan 2018 23:57:03 GMT

Hi Ming,

We are working on this tentatively for our March release.

Re: "Search, or Find function for Calculation

RenatoSalvaleon — Wed, 25 Apr 2018 18:07:20 GMT

JTedrick-esristaff‌ did this make it to the 2.7 build?

Re: "Search, or Find function for Calculation

JamesTedrick — Wed, 25 Apr 2018 18:16:43 GMT

Hi Renato,

We have not quite finalized the feature; it is, however, available for testing; documentation is in the Early Adopter Community.

Re: "Search, or Find function for Calculation

MarkBennett — Tue, 08 May 2018 21:10:34 GMT

Hi James,

I downloaded the 3.0 Alpha. However, I cannot find the documentation on the use of this function. Could you help me locate the usage of this function?

Thanks,

Ming

Re: "Search, or Find function for Calculation

JamesTedrick — Tue, 08 May 2018 21:26:17 GMT

Hi Ming,

The appropriate document in the Early Adopter Community is Welcome to our Feedback Community . If you have questions about the functionality, please post in the Early Adopter Community.

Re: "Search, or Find function for Calculation

Anonymous User — Mon, 24 Feb 2020 13:56:43 GMT

Hi James

I've now got a similar query - did this functionality ever make it to S123 and if so what is the function called?

Thanks,

Tom

Re: "Search, or Find function for Calculation

JamesTedrick — Tue, 25 Feb 2020 19:29:51 GMT

Hi Thomas,

This is part of the custom JavaScript functionality; it still is in beta (there are a couple of final issues with the survey author's experience holding final release).

Re: "Search, or Find function for Calculation

Anonymous User — Thu, 27 Feb 2020 16:41:41 GMT

Hi James,

Thanks for responding, as it is still in Beta will hold off putting it into my surveys, will definitely be a useful feature when it arrives though.

Tom

Re: "Search, or Find function for Calculation

AlexandreNunes — Fri, 19 Apr 2024 11:58:48 GMT

Hi James,

Did this ever come to fruition? Don't seem to see it in the list of available formulas for Survey123.

Thanks!