Skuid SFX is now Nintex Apps!

Legacy terminology may appear as we update our documentation.

Use Select option to Filter on Date Ranges

In Filter on Date Ranges, the examples uses the pre-configured Date range filter type limit records. But there’s another way to filter dates, one that allows the builder a fixed set of dates from a dropdown menu.

For example, what if a manager of the tech support team wanted to filter cases by the last time they were modified—that is, the last time anyone on the team worked with the case—based on a set of parameters:

  • Worked on today
  • Worked on this week
  • Worked on during the last week
  • Worked on sometime this month

To create this type of date filter, use a Select option filter and standard date strings.

The goal? A filter that allows the user to select from a drop down of pre-selected date options.

image1

Assumptions

Note

The example below assumes a Skuid page with:

  • a functioning model on an object that collects information about potential leads (In this example, we used Salesforce’s Opportunity object).

  • a table on that model with fields for …

    • Name (of lead)
    • associated account (if any): AccountID
    • Amount
    • Created Date and Last Modified Date
    • Owner ID

If using a different data source, the field names indicated may be different.

Create model conditions [[]]

In the model, under Conditions, click add to add a new condition and configure this condition for the start date of the first date range (e.g. $1,000):

  • Field: Use the Last Modified Date datetime field

  • Operator: =

  • Value: Leave blank

  • State:

    • Condition state: Filterable default off. (Skuid will automatically generate a name for the filter.)

Build the filter [[]]

On the Table component, click Add feature > Table filter, then configure the filter:

  • Filter type: Select option
  • Filter method: Server
  • Pick options and condition: Manually
  • Filter label: Last Modified Date
  • Model condition to affect: The one created in the previous step
  • Create “None Selected” option: Checked
  • “None Selected” option text: Last Input
  • Display as: Dropdown

Add the filter source

On the Last Input filter, click the Sources tab. Click add Add option source, then configure:

  • Source type: Manual

Choose filter options

On the Source: Manual option source, click add Add option to create an option for the first choice to be listed in the filter:

  • Which conditions will this source’s option affect?: Affect the default condition.
  • Label: Today
  • Value: TODAY

Repeat the step above to add three addition Filter Options:

  • This Week (value string: THIS_WEEK)
  • Last Week (value string: LAST_WEEK)
  • This Month (value string: THIS_MONTH)

Learn more about Datetime formula functions.