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.
Solved! Go to Solution.
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:
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: