Skip to main content

Change a field type

Convert a field to another type, for example single line text to multi line text or single select to status. Find out which conversions exist and when values can be lost.

Written by Leo

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.

The Change field type list of a single select field with Single Select, Multiple Select, and Status

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 access to the database app and a desktop or tablet.

Change a field type

To convert a field:

  1. Open the record layout editor from the app menu with Customize record layout.

  2. Click the drag handle (⋮⋮) of the field, then select Edit field.

  3. Select Type. The list is called Change field type. Enter a name in Search for field type… to find a type.

  4. Select the new type. In this list, the select types are called Single Select and Multiple Select.

  5. In Convert field type?, select Convert. Select Cancel to keep the current type.

Opening Edit field of the Property type field, selecting Type and Multiple Select, and pointing at Convert

The Convert field type? dialog with the Convert and Cancel buttons

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 text to Multi line text.

  • Multi line text to Single line text.

  • Single select to Status or Multi select.

  • Multi select to Single select.

The Change field type list of a multi line text field with Single line text and Multi line text

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 text to Multi line text, Single select to Status, and Single select to Multi select keep every value.

  • Multi line text to Single line text keeps only the plain text. Formatting is removed, and very long text is shortened.

  • Multi select to Single select keeps 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?

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?

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?

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?

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?

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 →.

Did this answer your question?