Importing to an Option Set datatype via CSV

[harris]

Ahh okay so I think I realize the miscommunication here.

I want users to be able to upload data themselves via CSV from the front end.

Here’s the design:

Here’s the workflow:

It’s in this instance where I’m running into this issue with options. And I’ve tried different column headers to get it to accept/auto-match the upload, but that’s where it’s struggling. It says Column headers should match the fields’ captions but that’s where things are getting snagged.

For testing purposes, I’m going to try the back-end data importer here. First, for reference here’s my spreadsheet:

First, it automatically recognizes and matches it:

Then Validate works, it gives me a confirmation message:

Then finally, it does successfully upload:

Weird… Right? It seems like there’s some difference in the logic between the back-end admin-generated upload and the front-end user-generated upload.