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; } } }

Survey 123 pulldata functionality?

AdamLevine

In the past I have used the pulldata function to access data from a csv file pulling from a specific record.....I was wondering if there is a way to use the pulldata function (or another way) to 'cycle' through a file of data for verification.

My use case is to be able to walk into a building - select the building entered and then cycle/scroll through all of the spaces in that building one by one (pulling 5+ fields of information) and check a box verified or not verified (with a list of reasons why). SO instead of having to type in room by room just having it scroll through the list of areas in that particular building which would save a lot of time.

Looking for ideas on how/if this might be able to be accomplished. Wondering if a repeat can be used with pulldata not repetitive questions.

Thanks,

Adam

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

erica_poisson

Hi Doug,

It looks like I just need to do a lot of reformatting of the data. I was testing using a CSV that originated as a Google Sheet. Although I thought I'd cleared the formatting, I think there was some latent junk in there. I created a new CSV with a very small subset of the data (cleaned) and it seems to behave properly. I did not expect those weird issues to crop up but now I know - start from scratch!

Your word wrap suggestion was really helpful - I wouldn't have thought to look for that. Once I saw it in my CSV I decided a fresh test was in order.

If you have any other useful tidbits to pass by, I'd be appreciative! Thank you for being so helpful so quickly.

Erica

dougbrowning

You for sure cannot have any commas. I also had issues with people pasting in special chars from book text.

The other issue that did this to be was having line wraps in there. They were hard to find because the second line was blank. If you turn on word wrap in excel on the column you can see them.

Another one that got me was using the same name for a list and a field.

It does sound you have some weirdness in your CSV.

If you can post your sheet that will help see it.

Hope that helps.

erica_poisson

Hi James,

As a very late follow-up question to this...pulldata functions work within repeats, only if the value you are trying to retrieve from your CSV was triggered by a field within the repeat? Since that may be worded poorly, here is an example I am trying with varying success:

Question outside of the repeat:

I want to be able to select the ${Restriction_Name} and have that, in addition to populating the ${Restriction_Number} also populate a number of fields within a repeat for 'Landowner Contact Information'. The way I am structuring the pulldata function in my repeat is:

It seems as if it might intermittently work while I am testing this in Connect, however I am also seeing some weird behavior both in my ${Restriction_Number} field and in my ${Primary_Contact_Name} fields. This strange behavior includes a weird default value in ${Restriction_Number} (this is a required field with no set default), some random quotation marks (") in the ${Primary_Contact_Name} field and (once) unreliably sourced information in the ${Primary_Contact_Name} field (e.g. sometimes it pulls in the ${Restriction_Number} instead...

Example #1 - weird default value present in Restriction Number before a Restriction Name is selected from an autocomplete picklist (select_one question):

Example #2 - weird default value in Primary Contact Name before a Restriction Name is selected (same as above):

My pulldata file is stored in the Media folder as a CSV. There are no field names with spaces in the CSV. It does seem as if some weirdness can be traced to commas within the pulldata CSV fields (can there be no punctuation in the pulldata CSV?), however I am curious about the strange default values in my form. There are no quotation marks in any of the fields within my CSV file.

I am currently testing this as a proof of concept for potential use in one of my established surveys to assist staff with data entry.

Any insight would be appreciated.

Erica

JamesTedrick

Hi Adam,

This may be possible if each space has a unique identifier in the CSV. As the pulldata function only retrieves one value, you would need to use it inside the repeat and formulate the lookup value per-repeat.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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