How do I input a csv table list into a multiple choice values table? I have a 100 choices and I don't want to type them all out.

D

I have a 100 choices and I don't want to type them all out.

S

I don’t believe this is possible, though would be very cool!

Ninox Profile

This is possible. Have a csv with ";" as field seperator. Give the choices commy separated.

Birger

S

I am trying to do this, I currently have an excel CSV file with states listed as 

 

"Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming"

 

 

How do I import these options into a Choice field? Please explain in detail.

D

Birger, please let us know how you import the CSV.

Thanks

D

Birger, please let us know how you import the CSV.

Thanks

R

"drdlayton":  I think you mean a multiple choice FIELD, because, as far as I know, there is no such thing as a multiple choice "table".  (If I'm wrong about that, please tell me.  I want to know.)

Like "S Moore" above, I don't think it is possible.  On multiple choice dialog I don't see any way to import:

Screen  32

Many, many questions here asking for help to import odd data sets into Ninox.  My solution -- and it works every single time -- is Mac utility software, Keyboard Maestro.  It is not part of Ninox; need to buy separately.  From what I see on this forum, the very nice people at NX don't know about Keyboard Maestro yet, because if they did, they'd recommend it to solve about 1/3 of problems here.

Keyboard Maestro has some of the best documentation I've seen anywhere, including a vast Wiki with many examples, along with an excellent forum.  However, at first it looks overwhelming -- at least it was that way for me -- but once you start to understand Keyboard Maestro, you can use it do so much more with Ninox, like importing 100 items into a choice field, without retyping.

 

 

R

Further note:  Digging into the documentation for any software is usually a pain.  The best solution I've found is using Artificial Intelligence to search, sort, analyze and collate from the full set of user manual + Wiki + forum.  Neither Keyboard Maestro nor Ninox have anything like Artificial Intelligence, so I use Mac software utility, DevonAgent to ease the struggle of understanding the documentation.  I've written about DevonAgent elsewhere on this forum.

S

Ron, that worked beautifully, I got all 50 of my states added to the dropdown within minutes! 

R

"S Morre" - You are most welcome. 

And would you please post a screen print here of the macro you created in Keyboard Maestro? 

I'm sure it would help a lot of users here to be able to see your solution.

 

(I wish I could make a little video showing how Keyboard Maestro works like that with Ninox.  Many people would find that very helpful.  But I don't know how to make videos.)

1 2
Reply