Forum Discussion

Mohamed_HannanS's avatar
Mohamed_HannanS
Qrew Trainee
7 years ago

Cross Join between two tables

Hi All, I have a requirement where i need to create a Time series chart (Heat map to capture future work) . So basically i have 5 activities( which are calculated based a date) to which i need to map to my projects table. I am not sure but i am actually looking for a Cross join between Projects table and Activities tables. so that i can create an expected chart. Is this achievable
Relationships
reports and charts
Tables and fields

3 Replies

Sort By
  • Mohamed_HannanS's avatar
    Mohamed_HannanS
    Qrew Trainee
    7 years ago
    No , Currently activity is not is there in system yet .  The requirement is that each project should have 3 activities and  its start and completion dates (based on the date which is present in project table). I believe i should  create a new table where each project  in project table should have 3 activities and its dates in a new table based on that i will create a chart(I do not want to create duplicate entries for activities in  project table).  Kindly suggest. _
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    Yes, you should have a Child table of Activities.  if you like you can set up an Automation to create the three standard Activities when a Project record is created.