I have an App for User Sign ups. There are Dates and sign up closing date for each date. i only want user to add new record for dates where sign up closing date is >= today(). I’m able to prevent duplicate entries by using Valid If. However, i dont want to show invalid dates in the create new view for user. PFB. Signup is a table and Sign up closing date is in the Menu table. referenced using Date
You can use an expression in suggested values to only show future dates, or whatever other filter you want to apply.
|
Suggested Values for a Column
How to suggest a dynamic list of values for a column
|
| - |
Where do i have to use this filter? If i use it in the columns, it filters it from the list view as well. in the list view i need to show everything. only when user creates a new item, i want to filter it.