Skip to main content

Date Range

The Date Range Field allows you to capture two dates that form a range. This is particularly useful for tracking project timelines, vacation periods, or any scenario where a start and end date are needed.

Creating a Date Range Field

There are two ways to create a new Date Range Field in Buildaible:

Way 1: Adding Fields via Table Settings

  1. Access the Table Settings:
    On the table, click the down arrow next to the table name, then select “Table Settings” from the dropdown menu.

  2. Navigate to the Fields Tab:

    1. In the Table Settings screen, click the “Fields” tab.

    2. Click the “+ New Field(s)” button in the top right.

  3. Select Date Range as the field type and configure the settings.

Way 2: Adding Fields via Manage Fields

  1. Open Field Management:

    1. On the table, click the “Manage Fields” button.

  2. Add a New Field:

    1. In the Manage Fields modal, click the “+ New Field” button.

  3. Choose Date Range as the field type, provide a Field Name, and customize the settings.

Settings for Date Range Fields

When creating or editing a Date Range Field, you can configure the following options:

  • Show in Table Home: Display the Date Range Field in the Table Home view for quick reference.

  • Field Required: Ensure the Date Range Field must be completed when creating a new record.

  • Unique Value: Guarantee that no two records in the table have the same date range.

  • Helper Text (Optional): Provide additional instructions or guidance for users filling out the field.

  • Description (Optional): Add further context or explanation about the field by clicking the + Description link.

Use Cases for Date Range Fields

  • Project Timelines: Define the start and end dates for a project.

  • Event Schedules: Capture the range of dates for multi-day events.

  • Vacation Tracking: Record employee leave periods.

  • Billing Periods: Specify billing cycles or coverage dates.

Editing a Date Range Field

To edit a Date Range Field:

  1. Go to the Fields tab in your table settings.

  2. Select the Date Range Field you wish to modify and adjust its settings as needed.

Best Practices

  • Provide Helper Text: Use this to clarify how to input the date range (e.g., “Enter the start and end date of your project”).

  • Use Field Required for Critical Dates: Make the field mandatory to ensure important date ranges are always captured.

  • Define Unique Values for Certain Scenarios: Enforce uniqueness when no overlapping date ranges are allowed, such as resource booking.

Back to top