Field Types Reference
When mapping columns from your Google Sheet, you assign each column a field type. This tells FieldFlow how to display and format the data.
Available field types
Section titled “Available field types”The default type. Displays as plain text.
Use for: Names, descriptions, notes, addresses, any freeform text.
Renders as a clickable link.
Use for: Website URLs, social media links, application forms.
Example data: https://example.org/apply
Displays as an image in the directory card and detail page.
Use for: Logos, photos, headshots. The column should contain a direct URL to an image file (.jpg, .png, .webp).
Example data: https://example.org/images/logo.png
Formats as a clickable phone number (tel: link) on mobile devices.
Use for: Phone numbers, fax numbers, hotlines.
Example data: (864) 555-0123
Renders as a clickable mailto: link.
Use for: Contact email addresses.
Example data: [email protected]
Formats the value as a readable date.
Use for: Event dates, deadlines, last-updated dates.
Example data: 2026-03-15 or March 15, 2026
Number
Section titled “Number”Formats as a number with optional currency or unit display.
Use for: Prices, quantities, distances, ratings.
Coordinates
Section titled “Coordinates”Enables map view for this record. Expects latitude and longitude.
Use for: Physical locations you want to show on a map.
Example data: 34.8526, -82.3940 (lat, lng in a single column)
Taxonomy
Section titled “Taxonomy”Marks this column as a filterable category. Values become filter options in the directory sidebar.
Use for: Categories, service types, regions, tags — anything users should filter by.
Example data: Housing, Employment (comma-separated values create multiple tags)
Displays in a dedicated “Hours” card on detail pages.
Use for: Operating hours, office hours, availability schedules.
Example data: Mon-Fri 9am-5pm, Sat 10am-2pm
Rich Text
Section titled “Rich Text”Renders HTML formatting (bold, italic, links, lists).
Use for: Long descriptions with formatting. FieldFlow sanitizes the HTML for security.
Choosing the right type
Section titled “Choosing the right type”| Your data looks like… | Use this type |
|---|---|
| Names, descriptions, addresses | Text |
https://... links | URL |
https://...png or .jpg image links | Image |
| Phone numbers | Phone |
| Email addresses | |
| Dates | Date |
| Lat/lng coordinates | Coordinates |
| Categories or tags (comma-separated) | Taxonomy |
| Operating hours | Hours |
| Formatted text with HTML | Rich Text |