Mark Beach asked 2 years ago
I added an address field to my form. Is there a trick to importing to that field since there are multiple data elements in that field (address, city, state, zip) and a csv will have those fields as separate elements?
Michael Clark answered 2 years ago
I've found that with larger datasets in CSV, it's worth it to take the time and prep the CSV so you can map columns to the right subfields of the FF address field.:
line 1, line 2, city, state/province, postal, country
Here's the FF documentation on it:
https://formidableforms.com/knowledgebase/import-forms-entries-and-views/#kb-import-addresses
Hope this helps. 🙂
Please login or Register to submit your answer
Create an entry in this form filling in those fields. Then export that to CSV. Then use that as your template for building the import with your data. Doing it this way ensures that your data is coming in the "formidable" way. It will automatically pick up the "sub-fields".
I've found that with larger datasets in CSV, it's worth it to take the time and prep the CSV so you can map columns to the right subfields of the FF address field.:
line 1, line 2, city, state/province, postal, country
Here's the FF documentation on it:
https://formidableforms.com/knowledgebase/import-forms-entries-and-views/#kb-import-addresses
Hope this helps. 🙂
I like Bobby's suggestion, too. I do this all the time. Make a form with the structure you want, add a single entry, export it to CSV. Zero out the entry and the line in the CSV and boom! instant import template!