Latest Contributions by BryceHancock

Hi Doug, Where do I implement the arcade expression in Fieldmaps designer? I have a field named FEATURE_ID in my FC attribute table it contains the unique identifier that links the fieldmaps and survey123 data. In fieldmaps designer, I added the FEATURE_ID field to the form and created a new Arcade expression for the field: return guid('digits') I run the Arcade code in the code block and it works, but when I open my map in fieldmaps on my tablet and add a new feature, the form pops up but the FEATURE_ID does not populate. I thought maybe I needed click the check in the upper right to get it to populate and show the integration url, but the field did not populate. I see that I can add an arcade expression under the 'Logic' tab for the editable, required, and visible options, but I just added a new expression outside those options. Do I need to add the expression to the required option in the logic tab, shown above? Just not certain where to implement it. Also, wondering if there are any issues using the "guid" arcade expression in the FEATURE_ID field. Can there be a calculated guid field and globalid field in the same feature class, or will that cause problems with the data? I received no error when I added the guid to the existing feature class with the globalid, but maybe there is currently limited error handling for arcade expression in a feature class, so no warning.

I am having the same issue. Did you find a solution?

Hey Doug, Thanks for your prompt response. This is very helpful. I like the idea of using Arcade to create the key and then passing it through the url. I currently have the FieldMaps spatial and Survey123 tabular joined on a FeatureID field that is in both FC's. The FeatureID field is the GlobalID field calculated to remove the curly brackets. I had to get creative because of the curly bracket formatting of the GlobalID from Fieldmaps. I could not join the two datasets with the brackets, so I ended up using a calculation in the Survey123 form to remove the brackets when they are received by the url, and then I have to run a field calculation in the Fieldmaps attribute table in Arcpro to populate the FeatureID with the GlobalID without brackets, and rejoin the data. It's ugly, the equivalent of duct tape and bubble gum to fix a workflow, and requires constant manual maintenance. So, excited to try this out and it should not cause any issues with the old data, not live now, so should be an easy fix! Thanks again for your help!

Hi Doug, Thank you for responding. What did you use for your new key to establish the relationship between Fieldmaps and Survey123? How do you deal with existing records where there is a join between fieldmaps and Survey123 on GlobalID? My fieldmaps feature datasets point, line, and poly, only have the GlobalID field in the attribute table. Would I add a datetime field and another to fieldmaps, concatenate them in the url to pass to the Survey123 form, or use some other field type in Fieldmaps to pass to Survey123 in the url? I am confused on the exact process and I cannot find any resources with specific examples. Thanks for any help you can provide.

‎02-22-2024

Hi Doug, In the process you describe above, what do you use or how do you create the new key in the geodatabase for the fieldmaps features: point, line, and polygon? Also, I currently have nearly 1000 records in Survey123 that are using the globalid relationship with Fieldmaps, how do I keep the relationship between fieldmaps and Survey123 with the old data after adding the new key? Also, what happens if you need to make changes to the Survey123 form, i.e., editing or adding new fields and republishing? Will the relationship be maintained after republishing with the method you describe? Thank you.

‎10-03-2023

Hello, I have configured a Field Maps popup that opens a Survey123 form and populates the globalid from Field Maps to a field in the Survey123 form. Popup URL: arcgis-survey123://?itemID=e4012bc59ca1407a8712a65862aa1454&field:incoming={globalid} I found a post in the community that described the need to remove the curly brackets when passing the globalid to the Survey123 form in order to join the Field Maps feature data to the Survey123 form data on the backend (cannot find the post now). I use the following calculation in the Survey123 form to remove the curly brackets and populate the field FEATURE_ID with the globalid, sans curly brackets. if(regex(${incoming}, '^\{[\w\-]*\}$'), substr(${incoming},1, string-length(${incoming}) - 1), ${incoming}) On the backend I wish to join the Field Maps feature data using globalid with the Survey123 form data FEATURE_ID, but when I go to join the two fields, the Field Maps feature data globalid has curly brackets and FEATURE_ID does not, so the two fields will not join. The workaround I am using now is, I created a new field in the Field Maps feature data, named feature_id and run the field calculator replace function to remove the curly brackets from the globalid field and populate the feature_id field. I can then join the Survey123 FEATURE_ID to the Field Maps feature_Id. Obviously this is not ideal from an efficiency perspective as I have to remove the join and recalculate whenever there is new data collected. It would ideal to create a static join, so in the AGOL Webmap and/or ArcPro so when the map is opened the updated data is displayed. How would I accomplish this? Do you have to remove the curly brackets from both datasets in order to join the two? Is there another way to join the two datasets rather than using globalid? Any help greatly appreciated!

‎07-14-2023

Thank you, it appears .>0 and .<360 or -99 , works as well.

‎07-14-2023

Hi, I have an integer field where I have added the following expression to the constraint field: .>0 and .<360 or .-99 I want the user to be constrained to enter numbers between 0 and 360, or allow a -99 to be entered. Can this be done with a constraint field? If so, what is the proper expression?

‎07-04-2023

I have a form, screenshot attached, with a series of calculations to compute a final result. The first set of calculations work fine, but when I attempt to sum the results of two calculations then compute an average, the values are concatenated instead of computed. I tried setting bind esri field type to integer and also tried beginning each expression with int( as I found an article stating the calculation fields are saved as strings, so I assumed my final result fields are being treated as strings and concatenated instead of summed. The result stopped evaluating all expressions and provided results from only a single series of the expressions instead of summing and averaging the results. How can I correct the attached expressions to compute the sum and average of the 2 series of fields? The xls form I am using is an older version, I pulled to from a previous survey to use as a template. Could this be causing the issue?

‎06-30-2023

Thanks Michael, Tried this with the following expression and received a message that it could not understand the expression. ${TRANSECT_NUM} in ('4','8','12','16','20','24','28','32','36','40')

‎06-30-2023

I have the following relevant expression: ${TRANSECT_NUM}='4' or ${TRANSECT_NUM}='8' or ${TRANSECT_NUM}='12'or ${TRANSECT_NUM}='16'or ${TRANSECT_NUM}='20' or ${TRANSECT_NUM}='24'or ${TRANSECT_NUM}='28'or ${TRANSECT_NUM}='32'or ${TRANSECT_NUM}='36'or ${TRANSECT_NUM}='40' The expression works fine, but is there a way to condense, so it is not so lengthy? Something like selected$(TRANSECT_NUM} = 4,8,12,16, etc.? The TRANSECT_NUM field is an integer field and calculated based on the count of another field, so I can't use the selected expression.

‎06-28-2023

Thanks Ismael, I realized I had an extra paratheses in the calculate field after I posted. 🙄

‎06-28-2023

Hi All, Seeking assistance with the correct syntax for the following calculation in a survey123 calculate field. I have tried numerous combinations with parentheses but cannot get the calculation work. (${FIELD_1} div (${FIELD_1} + ${FIELD_2})) div 0.01 FIELD_1 and FIELD_2 are number fields, of course.

‎06-13-2022

Could you tell me in detail how to stop a service in Arcpro, so I can enable attachments for my updated Survey123 form? Thank you

‎03-15-2022

Helllo, is there a way to show photos side by side from a repeat in a Survey123 report yet? I tried using a table but it places the photos, one after the other down the page, instead of across. Thank you.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by BryceHancock

Re: Integrating Field Maps with Survey123 using globalid and joining in AGOL or ArcPro

Re: Field maps stuck on "in progress..." after collecting streaming line

Re: Integrating Field Maps with Survey123 using globalid and joining in AGOL or ArcPro

Re: Integrating Field Maps with Survey123 using globalid and joining in AGOL or ArcPro

Re: Mapping with Survey123 within a polygon or admin unit

Integrating Field Maps with Survey123 using globalid and joining in AGOL or ArcPro

Re: Multiple constraints expression for a field?

Multiple constraints expression for a field?

Calculations concatenating instead of providing mathematical result

Re: Relevant expression question

Relevant expression question

Re: Help with calculation syntax Survey123

Help with calculation syntax Survey123

Re: How do I enable attachments for my Feature Service Layer for Survey123

Side by side photos from a repeat in a Survey123 report?

Re: Integrating Field Maps with Survey123 using gl...

Re: Help with calculation syntax Survey123

Side by side photos from a repeat in a Survey123 r...

Display attachments in new Map Viewer?

Re: How do I show image attachments in pop-up, fro...