If a field no longer fits, you can change its type instead of creating a new field. Tape converts the values of every record to the new type. Changing a type is meant to save you from retyping data.
Note:
A conversion can't be undone. It can delete the field's values in some records.
Other things that use the field are affected. Calculation fields, automations, extensions, and API connections that rely on the field are impacted too.
Only some types can be converted. The list shows what is possible for the field.
Who can change a field type?
Changing a field type is available on all plans: Free, Plus, and Premium. See what each plan includes on our pricing page.
You need
Full accessto the database app and a desktop or tablet.
Change a field type
To convert a field:
Open the record layout editor from the app menu with
Customize record layout.Click the drag handle (
⋮⋮) of the field, then selectEdit field.Select
Type. The list is calledChange field type. Enter a name inSearch for field type…to find a type.Select the new type. In this list, the select types are called
Single SelectandMultiple Select.In
Convert field type?, selectConvert. SelectCancelto keep the current type.
Tape shows Conversion in progress… while it converts the values.
If a field can't be converted at all, its Type row is dimmed. Hover over it to see "This field's type cannot be changed."
Available conversions
Single line texttoMulti line text.Multi line texttoSingle line text.Single selecttoStatusorMulti select.Multi selecttoSingle select.
Other field types can't be converted. To change one, create a new field of the type you need and copy your data over.
When values are lost
Single line texttoMulti line text,Single selecttoStatus, andSingle selecttoMulti selectkeep every value.Multi line texttoSingle line textkeeps only the plain text. Formatting is removed, and very long text is shortened.Multi selecttoSingle selectkeeps one option per record. If a record has several options, it keeps the option that comes first in the field's list of options. The other options are removed from that record.
Conversion limit
Converting a select field that has values in a very large number of records can be rejected. Tape then shows Conversion limit reached and asks you to reduce the values and try again. Select Confirm to close the message.
FAQs
Can I convert a text field to a date?
Can I convert a text field to a date?
No, Single line text only converts to Multi line text. To get a date, create a Date field and enter or import the dates again. Learn more about the date field →
Can I convert a select field to a status field?
Can I convert a select field to a status field?
Yes, a Single select field can become a Status field, and no values are lost. A database app can have only one Status field, so this works only if the app doesn't have one yet. Tape still lists Status in Change field type when the app already has one. Learn more about the status field →
Why is the Type row dimmed?
Why is the Type row dimmed?
That field type has no conversion. Hover over the row to see "This field's type cannot be changed." Only text and select fields can be converted. If you can't edit the field at all, you may lack Full access to the database app.
Can I undo a conversion?
Can I undo a conversion?
No. If you're not sure, duplicate the field first and convert the copy. Learn more about duplicating a field →
Are there other field types?
Are there other field types?
Yes! Database apps have fields for text, numbers, dates, members, files, relations, calculations, and more. See every field type in Intro to fields →
Still have more questions? Find answers and get help from community experts in the Tape community →.
