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
Are you sure the source columns are configured as date/time types?
Can you show a screen shot of the source columns?
Looks like your relation is a multiple relation, and so your lookup is returning an array.
Change it to a single relation and it should work.
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
It’s okay if you suggest whole new method to implement the Announcement banner
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).
Thank you for the solution, I did the same in Announcement table but how do I fetch the announcement which is true to the accounts table
Use a Collection with your Announcements table as the source, and use the if-then-else column to filter it.
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.