Skip to main content

Hi, I’m trying to build an event management board. Some of my events are recurring, but the current date data type does not allow multiple ones. Do you have a best practice for it?

 

One way I’m thinking about making a separate date table, and link the event with the dates. But the calendar view looks odd for this date table, as it use dates as the primary id and does not allow me to display big event name on it. Also, I don’t know how to filter the ‘date’ data based on conditions in the event table.  i.e. if I want to only show the dates where the event has been confirmed. 

 

Wonder if you have better options? And if yes, please show me!! If not, how to make my current date table better looking?

Hey ​@cecilia zhang,

 

Yes, you are certainly on the right track of thinking! Whenever a record has a list of something--in this case, a list of dates that the event occurs on--having a second linked table is usually the way to go.

 

To get the calendar view looking better, you can use a Formula field like this for the primary field:

Event & " - " & DATETIME_FORMAT(Date, "LL")

Because you can make a Formula a primary field but not a Linked Record field.

 

And you will be able to get something like this:



To filter the dates by events that are confirmed, you first create a Lookup field in your separate date table. The Lookup field will lookup whether the linked event is confirmed. Then, you can filter by that new Lookup field.

 

Let me know if I misunderstood anything. Hope this helped!

I’d recommend having one record per Event <> Date, instead of having multiple Events linked to a single Date I think:

 



And so the calendar would look like this:

 

Filtering wise, try adding a filter in the Calendar view based off however your data’s set up to confirm the event date


 

Reply


Terms & Conditions