Change a field's data type on Zapier Tables

In Zapier Tables, the field type defines the data format used in a specific field, such as email or number formats. Not all field types can be converted to another field type. 

 

Change the field type

  1. From your Tables dashboard, click the name of your table.
  2. Click the header of the field you want to change.
  3. Click Edit field. A sidebar will open.
  4. Click the Field Type field to open the dropdown menu.
  5. Select a new field type.

 

Possible field type conversions

If the field you want to change uses one of the field types in the list below, it can be changed into any of the other types on this list:

  • Text
  • Long Text
  • Checkbox
  • Number
  • Email
  • Phone Number
  • Date & Time
  • Currency
Note

Some conversions may warn you that changing the field type may invalidate some values. If you change the field type, review your table’s records afterward.

 

Field types that cannot be changed

You cannot convert these field types to any other field type:

  • Dropdown
  • Link
  • Button
  • JSON
  • AI Field
Note

You can set dropdown fields to allow a single or multiple selections. If you mark the Allow multiple selections checkbox, you cannot change it back to a single selection afterward.

Was this article helpful?
3 out of 5 found this helpful