POST
|
@JoshuaFergusonPCW and @RobertAnderson3 For the survey where I have 1 record populate 1 row, I have the ObjectID as a column in my excel sheet and use this in my flow: Where string(...) is equal to string(triggerOutputs()?['body/feature/result/objectId']) and empty(...) is equal to empty(body('Filter_array')) **Keep in mind, the "List rows present in a table" has a maximum records that it will search through** So this option is only really viable if you have a maximum of 5000 rows in your excel sheet. I've also set something up where there are multiple lines populated in excel per survey entry, but that flow is a bit more complicated for updates.
... View more
05-11-2023
08:33 AM
|
0
|
1
|
617
|
POST
|
I've used the mentioned solution, but hadn't committed the process to memory and now the link is returning 404. Could someone post a written solution?
... View more
03-31-2023
09:00 AM
|
1
|
0
|
891
|
POST
|
Is there any way to set a survey up to automatically refresh the calculations when copying to a new survey? I am running in to a similar issue, where the user will copy a sent survey to a new survey, even update a field used in another field's calculation, but the calculation will not update unless manually refreshed. This was not the behavior when the survey was first published, but has been happening after one of the updates last year, which has been quite confusing for several users.
... View more
02-14-2023
10:07 AM
|
0
|
0
|
512
|
BLOG
|
@RyanMcKenna - did you ever receive a solution to your above mentioned comment? "I am working on a building inspection form and I would like the building shape to be populated in the Geoshape based on the building name selected from a drop down. The form is setup to pull a number of fields from a CSV file and I can pull the vertex values to a text question with no issues. However when I try to pull the data directly to the geoshape question from the CSV or use a calculation to pull the data from the text question, I receive an error in Connect "java.lang.Number.Format.Exception: For input String..." I know the vertex information is in the correct format as the building will show up if I paste the coordinates in the default field. Am I missing a step that is needed to get the pull data function to work with geoshapes or is this not supported yet? I know there is the option to launch from Collector but I would rather not require the teams to use another app if they don't need to. I would consider using the Inbox method you outlined above but the inspectors need to collect photos and I don't see the repeat work around being a viable option for us." I am experiencing the exact same problem...
... View more
02-04-2021
11:34 AM
|
0
|
0
|
33615
|
POST
|
I tried applying the UrlEncode function to the arcade expression, and while it again showed successfully in the test, (e.g. 49.076299867222936%20-119.49206557279504%3B49.07729539411242%20-119.49157106101092%3B49.07748055058896%20-119.49015584073926%3B49.076918323830725%20-119.48940482221228%3B49.07629733102711%20-119.48848015844256%3B49.07563048532977%20-119.48942211118825%3B49.07576573916958%20-119.49133601232523%3B49.07553254850802%20-119.49236478454819%3B49.076299867222936%20-119.49206557279504) it still didn't show in the pop-up nor the URL that was formed. Thanks for your input. The fact that it still passes to the survey123 field app means that I can get by for now.
... View more
02-02-2021
10:14 AM
|
0
|
1
|
1666
|
POST
|
This is the URL I currently have set up (other than I've just listed the surveyID as 123): arcgis-survey123://?itemID=123&field:spray_status={spray_status}&field:vineyard_={vineyard_}&field:block_={block_}&field:polygon_={expression/expr0} This is the URL is currently produces: arcgis-survey123://?itemID=123&field:spray_status=requested&field:vineyard_=Bullpine&field:block_=BullpineD&field:polygon_= And this is an example of what I am trying to pass to the polygon_ question from the arcade expression first mentioned in this post: 49.076299867222936 -119.49206557279504;49.07729539411242 -119.49157106101092;49.07748055058896 -119.49015584073926;49.076918323830725 -119.48940482221228;49.07629733102711 -119.48848015844256;49.07563048532977 -119.48942211118825;49.07576573916958 -119.49133601232523;49.07553254850802 -119.49236478454819;49.076299867222936 -119.49206557279504 Also, even though it doesn't show in the url, it does transfer to the survey123 field app properly.
... View more
02-02-2021
08:05 AM
|
0
|
3
|
1672
|
POST
|
I went a step further and set up the URL with my survey... and using my arcade expression above, I successfully passed a polygon shape from collector for arcgis to my geoshape question in the survey123 field app. Not sure why it won't show in the pop up or attribute table though. And indeed, the web app does not appear to have this capability for geoshapes.
... View more
02-01-2021
02:37 PM
|
0
|
5
|
1686
|
POST
|
I have an arcade expression as follows in the add-ons of a polygon hosted feature layer on arcgis online: var geom = Geometry($feature); var firstpart = geom.rings[0]; var outparts = []; var counter = 0; function metersToLatLon(mx, my) { var originShift = 2.0 * PI * 6378137.0 / 2.0; var lon = (firstpart[pt].x / originShift) * 180.0; var lat = (firstpart[pt].y / originShift) * 180.0; lat = 180.0 / PI * (2.0 * Atan(Exp(lat * PI / 180.0)) - PI / 2.0); return Concatenate(lat, " ", lon); } for (var pt in firstpart){ var ptstr = metersToLatLon(firstpart[pt].x, firstpart[pt].y); outparts[counter]= ptstr; counter = counter + 1; } return Concatenate(outparts, ";") The expression works as intended when tested, however, when I try to view in the popup or attributes table, nothing appears. It also has not successfully saved in the layer. Ideas?? The goal of this workflow is to have a polygon shape passed through URL to a survey123 form geoshape question, hence the metersToLatLon function.
... View more
02-01-2021
10:13 AM
|
0
|
8
|
1716
|
POST
|
Yes, that was it! I guess mine were all defaulted to off. Sent from my iPhone
... View more
11-06-2020
03:21 PM
|
0
|
1
|
1699
|
POST
|
I have successfully created a flow from my survey123 survey created from connect to an excel online file. I can get the flow to add new rows to the table. However, after several attempts and trialing a few other forums suggestions, I still cannot get the flow to trigger, let alone update an existing row in my table, when editing and resending a survey from the inbox or sent folders of the ios app. I have tried using the objectId as well as calculated uuid() for indicators. The flow itself will also perform without error, but when tested for a resubmission, it is not triggered. Can someone provide a template on how to "update a row" in an excel file when an existing survey response has been edited from the ios app?
... View more
11-04-2020
01:05 PM
|
0
|
7
|
1722
|
Title | Kudos | Posted |
---|---|---|
1 | 03-31-2023 09:00 AM |
Online Status |
Offline
|
Date Last Visited |
06-26-2023
10:32 PM
|