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

Legermatt · ‎06-05-2023

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??

ChristopherCounsell · ‎06-06-2023

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:

ChristopherCounsell · ‎06-06-2023

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:

Legermatt · ‎06-06-2023

Wow that did it!

Thank you so much!