Discussions

 View Only
Expand all | Collapse all

Can a single calendar report contain data from two tables?

  • 1.  Can a single calendar report contain data from two tables?

    Posted 09-04-2020 13:21
    Can somebody walk me through how to pull from two tables follow dates on one calendar?

    TIA,

    Robin

    ------------------------------
    Robin Sewell
    ------------------------------


  • 2.  RE: Can a single calendar report contain data from two tables?

    Posted 09-04-2020 13:28
    Edited by Mark Shnier (Your Quickbase Coach) 09-04-2020 13:28
    A Report of any kind can only show records from one table.

    But one solution would be to make a new table which would give consolidated records form the two tables. If it wuz me I would make a URL Formula button which would purge the records in the consolidated table and then run two saved table to table imports to re-populate the consolidated table and then display the calendar report. The button would run very quickly so the users would not really know that it was doing all that work.

    We can get that working slowly on this forum or else quickly if you want to contact me for one on one assistance.

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