I have a field that I need to change from List user type to just user - but i cant do it in the field properties. The field ID is used across a lot of reports as well as external applications, so just creating a new field and transferring the data is not really an option.
Is it possible for a Quickbase tech/admin to do this in the backend? All fields only have 1 user in anyway, so the data should be fine.
Question
change field type from ""list-user"" to ""user
+17Hi Geoffrey,
Unfortunately List - User fields are one of two specific field types (the other is Multi-Select Text) that once a field is created as that type or converted into that type they aren't able to convert back. They are fields that format differently then most fields in Quick Base in order to hold multiple values. Once they are applied to that type there isn't a built in function to convert the existing field. The fix is to create a new field to mirror the data in the right field type (in this instance a user field) and then once that data is in place replace the existing field. I'm sorry there isn't a technical fix I could recommend in this instance.
Unfortunately List - User fields are one of two specific field types (the other is Multi-Select Text) that once a field is created as that type or converted into that type they aren't able to convert back. They are fields that format differently then most fields in Quick Base in order to hold multiple values. Once they are applied to that type there isn't a built in function to convert the existing field. The fix is to create a new field to mirror the data in the right field type (in this instance a user field) and then once that data is in place replace the existing field. I'm sorry there isn't a technical fix I could recommend in this instance.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.