Latest Contributions by Katie_Clark

‎07-19-2022

Well, the formula for BMI is BMI = kg/m2 so you'll need a question for weight (in kg) and height (in meters). Then you just reference those fields in the calculation column of the XLS form (if you're using Survey123 Connect). Are you using connect, or the web form? The calculation would look something like this: ${weight} div (${height} * ${height})

‎07-15-2022

So glad you got it working! 🙂 For writing quick statements like this, I usually use Notepad++. You don't have to save the document as a certain file type for the parentheses highlighting to display (like you can see in the screenshot, where the matching ones appear in red.) For more involved coding, I've used PyCharm, Atom, or Sublime depending on the language I'm writing in.

‎07-15-2022

Sorry, I didn't notice this the first time....I think you need a parentheses here too? Because the 'NULL' is the final ELSE statement. (I highly recommend writing these statements in an editor like this with syntax highlighting! It always helps me with the grouping.) If this still doesn't work I'll try to help more, but...let's try to get the simple stuff out of the way first 🙂

‎07-15-2022

At a quick glance, I noticed in your expression that you're missing a parentheses here: Does adding that fix the statement?

‎07-06-2022

Ah, ok I see now. I would have to do some testing and experimenting to see if a syntax directly in the report would work for that, but one idea that came to mind would be a schema change in the survey. Have a hidden question that returns "True" if choice1 OR choice3 OR choice5 is selected. Then in the report, populate the checkbox based on that hidden question.

‎07-05-2022

I think the issue is somewhere in your vegetation and/or soil section, but can you provide the XLS form so we can see how you structured the schema? Also, funny enough, I've basically done an identical workflow, creating a report template for the Wetland Determination Data Forms in Survey123. Maybe send me a DM if you would like to chat more...

‎07-05-2022

Hi @ThomasM ! You might find it helpful to look at the "Conditional Report Elements" section of this documentation The syntax is slightly different for the reports compared to within the XLS form. If you have a more specific question after reading that, let me know and I'll do my best to assist. 🙂

‎07-05-2022

I always use this workflow when downloading feature layers, the export button has never worked for large file geodatabases for me. https://support.esri.com/en/technical-article/000014156

‎06-28-2022

Hi Dan, thanks for your response! 1. The user said that the offline map area was very new, so I don't believe there were any schema changes between download the area and trying to sync. 2. The version of Collector on the device is 20.2.4, build 2851 3. This issue did NOT occur with other maps on the device. I created test data on other maps and they synced successfully.

‎06-28-2022

Hello, I've "triaged" the situation and have manually recreated the points and extracted photos so that the team has the data they need. However, I'd really like to get some answers on what caused this issue in the first place so that we can avoid in the future. See screenshot below for the error message received. This user has not had issues syncing before, and I was able to create test points and sync successfully with that login info on that device in a different map. I also tested by creating a test point on two different devices, using the same login information, and then syncing. I thought maybe it was an issue with duplicate/conflicting object ID's, but it looks like the data simply gets corrected and whichever device is synced first gets priority for the object ID, and subsequent syncs automatically reassign a unique ID based on what's already in the dataset. I tried retrieving the data manually per the Esri documentation (using iTunes to extract the replica geodatabases) but all the data that I was able to extract were for different offline maps. The one for this map didn't exist! So I couldn't retrieve the data that way. I also successfully synced test data to this specific web map on a different device. I am really stumped as to what caused this error! Any ideas?

‎06-17-2022

Hello, I'm not completely sure if this is what's causing your issue, but you may want to look into the differences between relevant and body::esri:visible. See this documentation: You can hide a question from view with an expression using the body::esri:visible column. This column hides the question if the expression it contains does not evaluate as true, while still keeping the contents of the question itself. For example, the expression ${edit_location}='yes' causes the question to only display if the edit_location question has been set to the value yes. This behaves similarly to the relevant column, with both columns hiding a question until the expression in the column evaluates as true. The primary difference is that body::esri:visible doesn't clear the value of a question hidden by the expression and still submits the hidden value to the feature layer. This makes body::esri:visible useful if the field's default content should be required, such as a default or calculation.

‎06-17-2022

Yup! I recommend reading this post about external choice lists

‎06-16-2022

Hmmm, well in this specific case I think you need an additional parentheses at the end to close the loops. I often write my expressions in a text editor with syntax highlighting so I can better see which parentheses are paired with which. However, now that I see what you're doing (having the user choose the common name and populate the scientific name automatically), this really sounds like the ideal situation for pulling data from external CSV's. I make all my surveys in Survey123 Connect, and that's the method I use since I work in the environmental industry and the common/scientific name translation is a requirement for almost every survey! Here's a great post from James Tedrick that can give you more info on that functionality.

‎06-16-2022

I recommend taking a look at this post of mine from a few years back - I still reference it when I need to double check my nested if statement syntax! This is me taking a stab at the syntax you'd need - it should be really close at least! if(selected(${field_one}, "E"), "bird xyz", if(selected(${field_one}, "C"), "Dog xyz", if(selected(${field_one}, "B"), "cat xyz", "monkey xyz"))) Hope that helps!

‎06-02-2022

May seem obvious, but are you removing both of these lines when you delete the if-statement? The ${/} below the if-statement doesn't appear to be paired with anything.

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by Katie_Clark

Re: Formula

Re: If statements with concatenations

Re: If statements with concatenations

Re: If statements with concatenations

Re: Nested IF statements in Survey123

Re: Can't find errant tag in report template - need help!

Re: Nested IF statements in Survey123

Re: Export Data ArcGIS Online

Re: 'Request Forbidden' error message when trying to sync edits

'Request Forbidden' error message when trying to sync edits

Re: Data entry disappearing when scrolling

Re: Code Help for IF Then using Drop Down List in Survey123

Re: Code Help for IF Then using Drop Down List in Survey123

Re: Code Help for IF Then using Drop Down List in Survey123

Re: Survey123 | Feature Report | Maybe Bug | When I remove the if statement I get a tag ${/} is unopen

Re: Dashboards That Pop: No Selection? No Problem!

Re: Category Selector - ALL option with default no...

Re: Category Selector - ALL option with default no...

Re: Legend in chart does not show if the Series is...

Re: Selecting multiple rows at a time in Map Viewe...

GIS Jobs