0

How can I change a field type - from text to choice?

Imported data from a CVS file.  Choice field became text.  How do I change it to a choice field?  This my first time using Ninox.  Previously used FileMaker.

2 replies

null
    • Sean
    • 5 yrs ago
    • Reported - view

    The easiest way would be to click on the Administration icon (wrench) in the upper right corner and then select the "Console" tab. Type this code using your table and field names and click run.

     

    for r in (select yourTable)

    r.yourChoiceField := r.yourTextField

     

    Be sure to create a Choice field in your table and make sure the choices match the text to be copied/selected.

    • Joanna_Traynor
    • 3 yrs ago
    • Reported - view

    Hello, I have a similar issue in that I would like to change a Rich Text field to a multiline text field - well i only want to do this because when you export an RTF field to excel, it turns into gobblegook...i would rather not have that happen - but i think if its plain text, it won't happen. I am major newbie big style so any help will need to be understood by a five year old!!! hope you can help....

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 1646Views