Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Try this. But I have not tested.
Export a dump to excel of the record ID and the multiselect field. It should come out as a semi colon delimited list, actually a semicolon and a space.
Use Excel's Find and Replace to find and replace.
Then upload to your table
BUT! I have not tested this, so on the first upload, just upload 1 record to see that it works! Then if all is good import the rest.
Export a dump to excel of the record ID and the multiselect field. It should come out as a semi colon delimited list, actually a semicolon and a space.
Use Excel's Find and Replace to find and replace.
Then upload to your table
BUT! I have not tested this, so on the first upload, just upload 1 record to see that it works! Then if all is good import the rest.
- MikeMike8 years agoQrew CadetThat worked beautifully, thank you! Quickbase even gave me a couple of warnings telling me that existing records may be updated.
Something to note:Export a dump to excel of the record ID and the multiselect field. It should come out as a semi colon delimited list, actually a semicolon and a space.
This was actually just a semicolon, no space:Staff;Customer Service;Finance
_But Excel Find & Replace didn't care either way and worked well.
Thanks again! - QuickBaseCoachD8 years agoQrew CaptainGreat, now I will know that the technique works for the future. That find a replace in Excel is super powerful as it replaces within strings.