nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

vlookup in survey123

FiorellaRodriguez

Hi,

Is the vlookup and hlookup function supported in survey123?

My second option is to do a nested if but I´m trying not to use it because I already have a lot of calculations and I have been noticing my survey sometimes crashes after some of calculations are done.

Thank you for your help.

Find more posts tagged with

Accepted answers

All comments

Jim Moore

Hi Fiorella

Perhaps a pulldata() function would be useful for your survey. This method allows you to do a lookup from the values in an external CSV file.

Please see a great explanation on this method here: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-data

And more here: Formulas—Survey123 for ArcGIS | Documentation

Regarding the crashes, which version of the app are you using and on what device and OS version?

Best,

Jim

FiorellaRodriguez

Hi Jim, thank you for your reply.

The pulldata function does not work for me in this because because the data that I need to look up is calculated within the same form, but thank you for your recommedations. I think in this case I will use a nested if.

About the crash, I had installed Survey123ConnectAlpha_x64_3_11_20, but I thought that might be the issue so I installed version 3.7.62 however I´m having the same behavior. I found that the crash happens within a calculation field. I´m not sure if I could open a tech support case for this. I have not publish the form, I´m in the creation stage and using connect for testing the form´s calculations.

This is what happens:

I have this calculation in a calculate field type if(${calc_cant_lect} < 55, number(${s1})+1, round(${l2} + 0.5,0)), when the field ${calc_cant_lect} is lower than 55 the form works and does the calculation, but if the field ${calc_cant_lect} is 55 or higher it crashes.

Thank you for your help.

Jim Moore

Hi Fiorella

Thanks for the additional info about the crash. Strange! Would it be possible to share your XLSForm so I can help troubleshoot?

Also please note the latest version of Connect is version 3.9.120 (released last week).

Best,

Jim

FiorellaRodriguez

Hi Jim,

Yes sure, I have attached the xlsform. Thank you, I really appreciate your help.

I will install the lasted version and create a new survey from this xlsform to test if I have the same behavior.

geotecnia3.xlsx

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.