0

Change the field type afterward

Hello.
I have a field in "number" format. After some time I use my dB I need this field to be converted to a "text" field. Is there a way or procedure to implement to change its property by not manually setting this on the entire program in which this field is related?

9 replies

null
    • Support
    • 5 yrs ago
    • Reported - view

    Hi Fabio,

    Changing the data type of field is not feasible. For your requirement, 

    1. Add a new Text field 

    2. Move data from the number field to the text field via the "Update multiple records..." functionality

     

    Thank you

    Sakshi-Ninox Support

    • cory
    • 5 yrs ago
    • Reported - view

    Sakshi, can you expand on that?  How do you use "Update multiple records..." functionality?  Appreciate your support.

    • Support
    • 5 yrs ago
    • Reported - view

    Hi Fabio,

    I have shared a screen-sharing call request with you to help you over call.

    Regards,

    Sakshi-Ninox Support 

    • sirrahn
    • 5 yrs ago
    • Reported - view

    Hi this is exactly what i have to do. Could you please share the solution?

    Thanks

    • Tacho
    • 5 yrs ago
    • Reported - view

    1. Add a new text field (newfield)
    2. use the cogwheel
    3. search the new text field (newfield)
    4. use his dropdown field: "assign calculated value"
    5. klick into the white field to the right of the dropdown
    6. chose the field name you want to move data from (oldfield)
    7. chose OK-button
    8. make sure, the drop down in the lower left corner shows "update all visible records"
    9. chose blue button "continue"

    Done!

    • Sean
    • 5 yrs ago
    • Reported - view

    2.5 Select "Update multiple records..."

    I guess that should be obvious, but it took me a minute.

    • Tacho
    • 5 yrs ago
    • Reported - view

    Damn, forgot that, thanks!

    • Hamad_Gamal
    • 1 yr ago
    • Reported - view

    hello, this is too late but, I am totally new to Ninox I couldn't do that, can someone explain in detail? the new field that I created is a multiple-choice field.

      • Fred
      • 1 yr ago
      • Reported - view

      Hamad Gamal Welcome to Ninox. We would love to help you as best we can. May I recommend that you start a new post and give us a bit more detail of what you want to do. Give us field names, table names, field type.

      For example you said you have a multiple choice field. Is it a regular or dynamic multiple choice?

Content aside

  • 1 yr agoLast active
  • 9Replies
  • 2796Views
  • 2 Following