Hello,
I have a form system that uses a sharepoint list as a data source. I'd like an icon to be displayed if the following is true, but I am having a hard time formatting it. Three icons in total:
1. Visible if Item exists in Sharepoint list made by current user AND item was made today/Date = today
2. Visible if Item exist in Sharepoint list made by current user AND item was made in current week (Sun-Saturday)
3. Visible if Item exists in Sharepoint list made by current user AND item was made in current month
Can anyone help me getting the syntax right for these?
@SamR ,
I cannot see your model, but the principle is the same - you need to refer whatever record that is displaying to the logic I posted.
Thanks @WarrenBelz !
I have one follow up question that I should have mentioned. These check marks are not associated with list items themselves. That is, they are on a "home page" that users can use to get to different sharepoint list form submission screens.
My hope is that users can take a quick glance at the home screen and see a green check mark if that respective form has been submitted for the day. Is this doable somehow? Maybe another method?
Home screen:
And then clicking on one of the items takes you to the respective form with it's own sharepoint list as it's data source:
Hi @SamR ,
Today
IsToday(Created}
Current month
Month(Today) = Month(Created) && Year(Today) = Year(Created)
Current week
DateDiff(
Created,
Today(),
Days
} < 7 &&
WeekDay(Created) < WeekDay(Today())
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.