Uploading data to multi select fields

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

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?

Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 66,438 Points 50k badge 2x thumb
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.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
OK that is a good advice and consistent with what I have.
Photo of Mabel Liang

Mabel Liang

  • 72 Points
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."
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb
Thanks a lot. It is all good.