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

[JonathanReeves]

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?

[Brett_Helium · 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

[JonathanReeves]

Thank you. This helped a lot.