Open s4069b opened 2 years ago
tbar0970
commented
2 years ago I've had a look into this, and unfortunately at the moment it's not possible. Only a single value can be imported into a custom sselect field. I'll convert this into a feature request issue. I'm curious as to what you're using a multi-select field for?
s4069b
commented
2 years ago Thanks for looking into it. I did make a bit of an attempt to get my head around the code... but didn't get far. We have had a go at using 'import' as a 'forms' work around. Collect Kids/Youth parent permission info using a google form. save as csv. swap the column headers from a second spreadsheet (prepared with jethro fields in the column headers). Then import. Saves a lot of work!! (except when a mother put her name in place of her son by mistake and the import placed her back in year 1... interesting). There are a few custom fields that were setup in Jethro a couple of years ago - with for example communication options (eg. 'through parent only', 'sms', 'email' - parents might pick more than one). Another is health / allergies... some kids have more than one issue to be aware of. It should be possible to do a work-around for the start of next year by combining options... and only allowing a single selection (eg 'sms', 'email', 'sms or email', ... ). But that can wait till next year now.. the bulk of the work is done for 2022.
tbar0970
commented
2 years ago It should be possible to support either comma-separated options within the one cell, or multiple columns for the same field.
This is more of a question. When importing from csv is it possible to include multiple 'selections' for a custom field? (the custom field is setup to accomodate multiple) I tried two entries separated by a comma under a single header in the csv file - the import failed because it ran both selections together I tried multiple columns in the csv (with the same header and different data) - there was no error but only the last column was imported.