Category
Getting Started
Tag
Basics
Creating fields
Tables have fields. By default, tables are created with an ID field, but you can add anything you like on top of that. Fields define what values a record in a table can have.
Morph handles the following types of fields:
- Short Text ... a string of 255 characters or less
- Long Text ... a string up to or over 255 characters
- Single Select ... a set list of pre-defined options, where one may be selected
- Multi Select ... a set list of pre-defined options, where multiple may be selected
- Number ... Integer value (2 billion or under)
- Big Number ... Integer values that do not fit into Number
- Decimal ... Decimal value
- Boolean ... True / False
- Date ... Date string (YYYYY-MM-DD format)
- Date Time ... Date and time string (format YYYYY-MM-DD hh:mm)
- Time ... Time value (format hh:mm)
- URL ... URL string
- Phone Number ... Phone number string
- Email ... Email address string
- Image ... Image file uploaded to Morph, or the URL of an image file
- Attachment ... File uploaded to Morph, or the URL of the file
- Formula ... allows you to set up a formula and store the result
To create a field, click the '+' button to the right of the table header in the table screen and enter the information from the Create Field popup.