- 1
text vs long text
text = one line ("property size," "preferred stylist"). long text = a paragraph (notes, free-form preferences). long text doesn't show in the table column — it only renders in the detail sheet.
- 2
number and date
number for anything you might want to sort or sum (lot size, lifetime value). date for one-off dates like "birthday" or "first visit." both show in filters with proper operators.
- 3
dropdown for anything you'll filter by
service tier (basic / premium / vip), source channel, neighborhood — anything where you want a tight set of values. type the options when you create the field.
tipif you're tempted to use text for something like "service tier," don't — use a dropdown. text fields make filters and reports messy. dropdowns keep the data clean.
still stuck?
we respond to every message within 24 hours.