Solved

Populating Dropdown in Customer Fields from a .xlsx file(spreadsheet)

JonathanReeves
Shopify Partner
17 0 0

I am working on a site for a client which uses Customer Fields in order to create a custom registration form. On this field there needs to be a dropdown select menu. My question isn't how to get the dropdown menu but more on the best way of populating said dropdown. I have a spreadsheet(.xlsx file) with a column that has all of the data I need to populate that dropdown. I am curious about the best way to go about doing that as well as whether or not the dropdown is going to have a limit on how many items it can contain?

Accepted Solution (1)

Brett_Helium
Shopify Partner
185 37 66

This is an accepted solution.

Hey @JonathanReeves, I know you reached out to us directly already, but I'll comment here as well in case anybody else is looking for a similar solution.

Our team has built an integration with Google Sheets to dynamically populate the field values of a dropdown from a spreadsheet. You can view our documentation for this here: https://help.heliumdev.com/en/articles/5507010-load-field-options-from-a-google-sheet

Brett | Helium
Helium builds apps that thousands of merchants depend on:
- Customer Fields ✪✪✪✪✪ (330+ reviews)
- Meteor Mega Menu ✪✪✪✪✪ (250+ reviews)

View solution in original post

Replies 2 (2)

Brett_Helium
Shopify Partner
185 37 66

This is an accepted solution.

Hey @JonathanReeves, I know you reached out to us directly already, but I'll comment here as well in case anybody else is looking for a similar solution.

Our team has built an integration with Google Sheets to dynamically populate the field values of a dropdown from a spreadsheet. You can view our documentation for this here: https://help.heliumdev.com/en/articles/5507010-load-field-options-from-a-google-sheet

Brett | Helium
Helium builds apps that thousands of merchants depend on:
- Customer Fields ✪✪✪✪✪ (330+ reviews)
- Meteor Mega Menu ✪✪✪✪✪ (250+ reviews)
JonathanReeves
Shopify Partner
17 0 0

Thank you. This helped a lot.