0

Importing Data into a Dynamic Choice Field

I know this was addressed many years back and at the time it did not appear to be a solution.  However, has anyone come up with a way to import data into a dynamic choice field when the text being imported matches the choice exactly?  I am hoping to import ethnicity and gender from another DB.  However, most of my picklists I had created are dynamic.

10 replies

null
    • Fred
    • 2 yrs ago
    • Reported - view

    Since dynamic fields are based on tables, you just need to import the data into your tables. You can tell Ninox which field is the key and it won't import data that is already there. Or am I missing something?

    • Dave_Irving
    • 2 yrs ago
    • Reported - view

    This does not work Fred.  Since dynamic choices reference a separate table.  It does not allow you to import csv data to populate the dynamic choices fields.  It works for the regular choice fields.

      • Fred
      • 2 yrs ago
      • Reported - view

      Sorry for not being very clear. I'm talking about importing into the root table of the dynamic field. It is a table so you can do all regular table functions.

    • Alain_Fontaine
    • 2 yrs ago
    • Reported - view

    Did you try this: https://forum.ninox.com/t/p8hrznt?r=60hbqxz

    • Daniel_Berrow
    • 2 yrs ago
    • Reported - view

    A dynamic dropdown works using the record's ID from the table you're pointing it to, so to import data into it you'll need to use the record ID from that table, in the same way you would to import a link to a record

      • Dave_Irving
      • 2 yrs ago
      • Reported - view

        , do you suggest that In my csv document, I change the field I want to import to record id.  So basically find and replace text strings to equal their id#?  So, let's say "white" is #1 in my dynamic ethnicity table.  Then, change "white" in my csv to instead be =1?

      • Alain_Fontaine
      • 2 yrs ago
      • Reported - view

       No, the idea is to create, in the same table containing the dynamic choice, a (temporary) text field, and to import the text values of the choice in this field. And then to perform the global update as described in the post I mentioned to populate the dynamic choice field.

      • Alain_Fontaine
      • 2 yrs ago
      • Reported - view

       Here is a bare bones illustrating the process. Since one cannot record a bulk edit, I did include a button that does the operation on the current report. Its script can copied to the calculated value of a bulk edit.

      Test dynamic from csv.ninox
    • Fred
    • 2 yrs ago
    • Reported - view

    I'm confused on what is being asked anymore. , are you trying to update the choices in a dynamic field (to add more choices) or update the record of the selected choice in a dynamic field?

      • Dave_Irving
      • 2 yrs ago
      • Reported - view

       lol.  I don't need to know how to add choices to a dynamic choice.  That's a very easy process.  I was only talking about importing data to update a client table records dynamic choice field.  For instance, taking our applications via a CSV to update the ethnicity field (which is a dynamic choice field).  I resolved this issue, by just converting all the choices to their record ID # in EXCEL, then importing the data into ninox.  This seemed to me to be the least time consuming way.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 10Replies
  • 268Views
  • 4 Following