Fields
Learn how to work with different field types and manage columns in your tables.
Available Field Types
Text Fields
- Single Line Text: For short text entries
- Long Text: For longer text content, descriptions
- Rich Text: Formatted text with styling options
Numeric Fields
- Number: Integer values
- Decimal: For decimal numbers
- Currency: Monetary values with currency symbol
Special Fields
- Attachment: Upload and manage files
- Date/Time: Date and time values
- Single Select: Choose from predefined options
- Multi-Select: Multiple choice selection
- Checkbox: True/false values
- URL: Web links
- Email: Email addresses
Field Operations
Adding Fields
- Click the “+” button in the field header
- Choose field type from the dropdown
- Configure field settings:
- Field name
- Required/Optional
- Default value
- Validation rules
Field Configuration
- Set field as required
- Add field description
- Configure field permissions
- Set default values
- Add validation rules
Column Management
- Resize columns by dragging edges
- Reorder columns via drag and drop
- Hide/Show columns
- Freeze columns
- Sort by column
- Filter by column values
Field Properties
Common Properties
- Field name
- Field type
- Description
- Required/Optional
- Unique values
- Default value
Advanced Properties
- Custom validation
- Reference fields
- Lookup fields
- Formula fields
- Rollup fields
Best Practices
- Choose appropriate field types
- Use clear field names
- Add field descriptions
- Set proper validation rules
- Configure default values when needed
- Organize fields logically
Tips and Tricks
- Use reference fields to link tables
- Leverage formula fields for calculations
- Set up rollup fields for aggregations
- Use lookup fields to display related data
- Configure field permissions for security