topic Re: Calculate fields from external CSV based upon Project User Input in ArcGIS QuickCapture Questions

Calculate fields from external CSV based upon Project User Input

Chris_Anderson — Tue, 14 Nov 2023 14:37:33 GMT

I have created a survey for sea turtle nesting in FL using Survey123 that pulls data from multiple external CSVs, and the survey works very well. Unfortunately, some users are unable to use it because of sheer volume of nests and false crawls and/or restrictions when they can survey (e.g. rocket launches). Halfway through the season, I was able to create a QuickCapture project for one user as a test to help make data collection easier while on the beach, and it helped greatly.

This year, I want to improve QC and make it available to more users. Unfortunately, I don't want to customize individual QC projects for each user. I am interested in using Arcade to pull data from external CSVs like in S123. So, 1) is this possible or will it be in the near future? and 2) being new to Arcade, does anyone have some sample code for pulling data from an external CSV and calculating field with the returned values that I can modify and use?

Any help is greatly appreciated.

Chris Anderson

Florida Fish and Wildlife Conservation Commission

Re: Calculate fields from external CSV based upon Project User Input

JohnathanHasthorpe — Tue, 14 Nov 2023 22:44:45 GMT

Could you use a feature service layer instead? We have support for dynamic lists in Beta:

https://earlyadopter.esri.com/project/article/item.html?cap=9c6a1e4687c34c7fb5c6f8f4e0bc2df3&arttypeid={489e45f2-59e4-41dc-b142-cbb71eabb765}&artid={34F21764-A77A-4EFB-A53D-6DAA8094B6F4}

This may suit your requirements.

Re: Calculate fields from external CSV based upon Project User Input

Chris_Anderson — Wed, 15 Nov 2023 11:55:33 GMT

Can a hosted table be used instead of a layer? I will try with one and see what happens.

One of the reasons we would love to use a local CSV is because some users may be on beaches where there isn't any cell coverage. The local CSV's in S123 help solve this issue.

Re: Calculate fields from external CSV based upon Project User Input

JohnathanHasthorpe — Mon, 11 Dec 2023 06:10:38 GMT

Hi Chris, we are looking to support tables in the 1.19 (March 2024) release. But it is not possible to test them using 1.18 (while this functionality is in Beta).