Using Survey 123 Connect, how do I use pulldata calculation to retrieve data associated with a DATE?

Legermatt

I'm trying to use pulldata calculation to retried data associated with a date but the field is returned blank.

 

 

What is wrong with my expression??

 

@IsmaelChivite 

ChristopherCounsell

Hi! Couple of things to correct:

• don't use 'date' in the survey123 name column. It is a reserved word.
• Your key/value name columns in your CSV should not contain spaces. You need to rename the 'Avg Daily Nubmer of SAR Cases' column and pulldata function.

Also recommend taking a look at:

• Is the value returned the same as the key i.e. does your date function work
• 'Nubmer' is a typo. Occurs on both sides, so isn't your issue, but will cause issues when corrected if not done everywhere
• Use better field names so it makes more sense, and maybe put them before the pulldata question so it's more logical when reviewing. date and date1 = hard to review. 
• Share the XLSForm and .csv where possible, it's just very useful for community members

More information:

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91

https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata/ba-p/896889