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?
-
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
-
Sakshi, can you expand on that? How do you use "Update multiple records..." functionality? Appreciate your support.
-
Hi Fabio,
I have shared a screen-sharing call request with you to help you over call.
Regards,
Sakshi-Ninox Support
-
Hi this is exactly what i have to do. Could you please share the solution?
Thanks
-
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!
-
2.5 Select "Update multiple records..."
I guess that should be obvious, but it took me a minute.
-
Damn, forgot that, thanks!
-
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.
-
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?
-