Discussions

Expand all | Collapse all

Uploading data to multi select fields

  • 1.  Uploading data to multi select fields

    Silver
    Contributor
    Posted 07-03-2016 22:36

    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?



  • 2.  RE: Uploading data to multi select fields

    Posted 07-03-2016 23:22
    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.


  • 3.  RE: Uploading data to multi select fields

    Silver
    Contributor
    Posted 07-03-2016 23:52
    OK that is a good advice and consistent with what I have.


  • 4.  RE: Uploading data to multi select fields

    Posted 10-16-2017 17:39
    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.


  • 5.  RE: Uploading data to multi select fields

    Silver
    Contributor
    Posted 10-16-2017 19:46
    Thanks a lot. It is all good.