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
    • 10 mths 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
    • 10 mths 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
      • 10 mths 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
    • 10 mths ago
    • Reported - view

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

    • Daniel_Berrow
    • 10 mths 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
      • 10 mths 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
      • 10 mths 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
      • 10 mths 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
    • 10 mths 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
      • 10 mths 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

  • 10 mths agoLast active
  • 10Replies
  • 206Views
  • 4 Following