Hello Everyone,
I want to create a announcement banner, on home page, which will be visible only between it’s start date and end date,
for that I have created a announcement tab for Admin, where admin can click on button “make Announcement” and types the announcement and it’s start date and end date, these data will be stored in the announcement table,
Now i want to fetch it into the Accounts table to display that Announcement in the home page for all the users, only during the particular duration.
but when I lookup the start date and end date from announcement date is getting con=verted as text so i am not able to set the visibility condition for the announcemnet<
Could anyone tell me the better way to do this Announcement banner
I am not getting, between which columns I should create relation because Admin is the one who makes the announcement and in accounts table there many users along with 2 admins
I think I would take a different approach.
If I look at your first screen shot, I see two announcements with a start date of Feb 2nd.
So this means you can have more than one announcement that is current at any given time.
With that in mind, here is what I would suggest:
In your Announcements table, create an if-then-else column as follows:
– If Start Date is after Now, then null (leave empty)
– If End Date is before Now, then null
– Else true
The if-then-else column should return true for any current announcement.
So you can add a collection of Announcements to your screen, and use the if-then-else column as a filter (only show Announcements where that column is checked).