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
-
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.
Content aside
- 1 yr agoLast active
- 9Replies
- 2855Views
-
2
Following