Discussions

 View Only
  • 1.  Listing last intreaction with Children in Parent's report.

    Posted 03-23-2020 12:43
    Hello,

    I am pretty sure this isn't possible but with my limited knowledge of quickbase, I am just doubting myself and getting to the experts.

    We have Parent (Projects) and Children (Activities).

    We are trying to create a report for Parents where we can list the timecreated for the last activity on specific activity types.

    On actives, we have type and we want to know when was the past time a particular type (phone call) of activity occurred with a parent.

    From a developer start point, can we do Foreach or LastRecord details using Formulas in fields or reports?

    Thank you,

    ------------------------------
    Chetan
    ------------------------------


  • 2.  RE: Listing last intreaction with Children in Parent's report.

    Posted 03-23-2020 12:50
    nop,
    Just go to the relationships between Parents and Children and make a summary of the Maximum of the [Date created] field, subject to the filter that the Activity Type = Phone call.

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



  • 3.  RE: Listing last intreaction with Children in Parent's report.

    Posted 03-23-2020 13:16
    Thanks Mark, I'll give this a try!

    ------------------------------
    Chetan
    ------------------------------