
Hi
I created a FORM to submit new records into SP list and pickup in Gallery to view and edit there for now the list is starting to grow.
As the list grow to thousand and many more
1) How to not display past records in the gallery and not allow edit
2) is there a way to show range of records by year or quarterly to be set by user
3) is it ok to use the form as it goes for years as the SP list will grow to few thousand or many
what is the best way to do it? Thank you
Hi, this can be done using the gallery filter. in the example below i have filtered the gallery based on todays date - 30 days
Filter([MyList],Created > DateAdd(Today(),-30,Days))