Populating fields from csv

ZenMasterZeke — Mon, 16 May 2022 17:17:37 GMT

Howdy,

Having a problem populating fields based on a csv. I have a csv file, contact.csv, with three contact info fields: contact_name, contact_phone and address like this:

contact_name,contact_phone,address
Carol Danvers,(123) 456-7890,123 Kree St Bangor ME 01234
Steve Rogers,(321) 654-0987,1600 Penn Ave Wash DC 01010
Fred Munster,(699) 699-6000,1313 Mockingbird Ln Chico CA 9876

On my form, I can populate a select one question with the contact name using:

type name label appearance
survey sheet - select_one contact cont_name Contact Name minimal search('contact')

list_name name label
choices sheet - contact cont_name contact_name

But after selecting a name from the select_one, the other fields, e.g. phone, don't populate:

type name label calculation
survey sheet - text cont _phone Contact Phone pulldata('contact', 'contact_phone', 'contact_name', ${cont_name})

Hopefully this makes sense. How can I get the other fields to populate from the csv row matching the contact name? Thanks!

Re: Populating fields from csv

ZacharySutherby — Tue, 17 May 2022 00:50:11 GMT

Hello @ZenMasterZeke,

On the choices worksheet the name and label for the contact choice list will both need to be contact_name. With what's set now no matter what choice is selected cont_name will be returned from the choice list and that doesn't match the values in the CSV.

Re: Populating fields from csv

ZenMasterZeke — Tue, 17 May 2022 12:16:47 GMT

Awesome, thanks Zach!

topic Re: Populating fields from csv in ArcGIS Survey123 Questions

Populating fields from csv

Re: Populating fields from csv

Re: Populating fields from csv