Uploading data to multi select fields

Question

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?

quickbasecoachd · Answer

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 · Answer

OK that is a good advice and consistent with what I have.

mabelliang1 · Answer

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 · Answer

Thanks a lot. It is all good.&nbsp;

Forum Discussion

Uploading data to multi select fields

4 Replies

Related Content

Same reference field, different selections within the form

Using multi select field in pipelines

Bulk create child records from selection list

Multi-select text field

Selecting which fields to display from Formula URL searches

Recent Discussions

Share your feedback on the new Qrew Discussions

Old form: label on the left side instead above an input field.

Static Number Field

(Pipelines) Get Users in Role / Process XML from HTTP API

Average last 30 days