Forum Discussion

JohnSanchez1's avatar
JohnSanchez1
Qrew Member
4 years ago

Calendar report to display multiple date fields

I have a project where team members will have to present at multiple dates.  Team meeting 1, Team meeting 2 and Team meeting 3.  I would like to display all three team meeting dates on the same calendar.  Is this possible? I have searched around but not finding what I need.

Any help is greatly appreciated.

Thank you in advance.

------------------------------
John Sanchez
------------------------------
reports and charts
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    No, that is not possible without some changes to the structure of your app as every date on a calendar represents a single record.  You would need to contrive to have a child table of those dates and show the calendar based on that child table..

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JohnSanchez1's avatar
      JohnSanchez1
      Qrew Member
      4 years ago
      Thank you Mark.  Do you happen to know of a tutorial or examples you can point me to?

      ------------------------------
      John Sanchez
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        4 years ago
        Well I don't have a specific tutorial or example to point to.

        Was going to do this using automations I would trigger the automation when a record was added changed or deleted and any of those three date fields changed.

        The first step would be to delete any existing children.  The next three steps would be to create three child records one for each date.

        The last step would be then to delete any children records where the date was blank.

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------