Skip to main content
Question

Uploading data to multi select fields

  • July 4, 2016
  • 0 replies
  • 31 views

As I am uploading historical data from a MS Access database where my safety table is linked to various factor responsible, I have a couple of question: 

1. What is the correct procedure to upload many factors to one safety incident when I have factors in my QB screen as a multi select field and not quite as a separate table. 
2. Is it permissible to upload relevant factors to an existing field multi select field to appear multi selected in QB?

This topic has been closed for replies.

I have no idea, but you may want to reconsider the design of the app to have the factors be a child table to safety incidents. When you go to analyze your data, having the factors in a multi-select field is going to limit your analysis ability.
  • ArshadKhwaja
  • Author
  • Quickbase Alumni
  • July 4, 2016
OK that is a good advice and consistent with what I have.
  • MabelLiang1
  • Quickbase Alumni
  • October 16, 2017
I don't know if you're still looking for this.

from https://help.quickbase.com/user-assistance/clean_excel_data.html

"A list of items that might be common across records, such as categories, you can import them into a Multi-select Text field type. Just separate each value in the field with a semi-colon.
  • ArshadKhwaja
  • Author
  • Quickbase Alumni
  • October 16, 2017
Thanks a lot. It is all good. 
Terms & ConditionsAccessibility statement