Discussions

 View Only
  • 1.  Calendar report to display multiple date fields

    Posted 05-10-2021 10:02
    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
    ------------------------------


  • 2.  RE: Calendar report to display multiple date fields

    Posted 05-10-2021 10:04
    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
    ------------------------------



  • 3.  RE: Calendar report to display multiple date fields

    Posted 05-10-2021 10:40
    Thank you Mark.  Do you happen to know of a tutorial or examples you can point me to?

    ------------------------------
    John Sanchez
    ------------------------------



  • 4.  RE: Calendar report to display multiple date fields

    Posted 05-10-2021 10:51
    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
    ------------------------------



  • 5.  RE: Calendar report to display multiple date fields

    Posted 05-10-2021 11:15
    Thank you for the information and direction.  Much appreciated.

    ------------------------------
    John Sanchez
    ------------------------------



  • 6.  RE: Calendar report to display multiple date fields

    Posted 05-30-2023 15:41

    To Chime in here..... Is this still the case 2 years later? 



    ------------------------------
    Eddy Elasmar
    ------------------------------



  • 7.  RE: Calendar report to display multiple date fields

    Posted 05-30-2023 15:55

    Yes. Same answer today. 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------