cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
rencygonzalez
Nintex Newbie

How to filter by date using List Lookup Control on Form

Jump to solution

In my Nintex form I have a list lookup that pulls Account Numbers from a list in another subsite. There are thousands of Account numbers saved in this list. Is there a way to "filter" Account Numbers in the list lookup control by date? For example i want to see account numbers from the last 10 days that way I won't have look through thousands of account numbers in my form.

list lookup

Form

Labels: (2)
0 Kudos
Reply
2 Replies
Nintex Employee
Nintex Employee

Re: How to filter by date using List Lookup Control on Form

Jump to solution

Hi Rency,

You can accomplish this by creating a view on the Account Number list with a filter that only shows the Account Numbers for the last 10 days. The filter formula is [Today]-10. Here's an example screenshot of the Filter configuration:

SharePoint List View Filter

Then you can configure the List Lookup control to use that view to show only the Account Numbers for the last 10 days. You just need to configure the Source List and add the name of the view you created in the Source View field. The form will only show the Account Numbers for the last 10 days because of the filtered list view. Here's an example screenshot:

Nintex Forms - List Lookup Control using Source View

View solution in original post

Reply
rencygonzalez
Nintex Newbie

Re: How to filter by date using List Lookup Control on Form

Jump to solution

Thank you so much!! This is exactly what i was looking for!

Reply