What field types do we need to support?

[zackkatz]

We currently have the following field types:

• DateTime
• Enum
• HTML
• Image
• Link
• StatusIndicator
• Text

When thinking about different field types, it's worth referencing the what others do.

Filament

Filament has these column types:

Static columns display data to the user:

• Text column
• Icon column
• Image column
• Badge column
• Tags column
• Color column

Editable columns allow the user to update data in the database without leaving the table:

• Select column
• Toggle column
• Text input column
• Checkbox column
• You may also create your own custom columns to display data however you wish.

Airtable

Airtable has this list of field types. I understand that many of these aren't primitives (Created by is a DateTime) and should be handled by the data sources, but I'm keeping the full list here for completeness.

Airtable Field Types

• Attachment (File): An attachment field allows you to attach one or more files directly to your Airtable records.
• Autonumber (Number): An autonumber column automatically generates a unique, automatically incremented number for each record.
• Barcode (Barcode object): If you use the mobile Airtable client, you can use the camera in your mobile device to scan several types of barcodes and QR codes.
• Button (Button object): The button field adds interactivity to your record such as opening a URL.
• Checkbox (Boolean): A checkbox field is useful for true/false values within a record.
• Count (Number): A count field lets you count the number of linked records in a record link column.
• Created time (String): The created time field type will automatically show the date (and optionally, time) that a record was created.
• Created by (Collaborator object): The created by field will automatically show which collaborator created a record within the base.
• Currency (Number): A currency field is a specific type of number field that formats the number as a currency amount.
• Date & Time (String): A date field allows you to easily enter a date and optionally a time into a cell.
• Duration (Number): The duration field type is a numeric field type intended for use with time durations measured in hours, minutes, seconds, or milliseconds.
• Email (String): An email field is intended to store a single email address in each cell.
• Formula (Varied outputs): Formulas allow you to compute a value in each record based on other cells in that same record.
• Last modified by (Collaborator object): The last modified by field displays which collaborator made the most recent change to a record.
• Last modified time (String): The last modified time field type returns the most recent date and time that a record was modified by a user in a non-computed field.
• Linked record (Link to another record) (Array of record IDs): A linked record field allows you to represent the relationships between related records by creating links between them.
• Long text (String): A long text field is great when you need to keep notes or multiple lines of text in each record.
• Lookup (Array of numbers, strings, booleans, or objects): A lookup field allows you to look up a specific field in a linked record.
• Multiple select (Array of strings): A multiple select field allows you to select multiple options from a list.
• Number (Number): The number field type is a general-purpose field type for most numerical values.
• Percent (Number): The percent field type is designed to hold numerical values formatted as percents.
• Phone number (String): A phone number field will format a 10-digit string of numbers as a US/Canada phone number.
• Rating (Number): The rating field allows you to rate your records for ranking or quality assessment.
• Rollup (Number or String): A rollup field performs calculations or formulas on an aggregate of inputs from another field based upon a linked record relationship.
• Single line text (String): The single line text field is best for short, unique pieces of text.
• Single select (String): A single select field allows you to select a single option from a preset list of options.
• URL (String): A URL field is intended to store a single URL in each cell.
• User (Collaborator object): The user field allows you to select one or more names from a dropdown list of all the collaborators with whom your base is shared.

[doekenorg]

We should add a GravatarField. Currently you can use an ImageField with some magic on the callback, but it would be nice just to provide the email address field, and make it work.