Discussions

Expand all | Collapse all

Listing last intreaction with Children in Parent's report.

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

    Posted 17 days ago
    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 17 days ago
    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 17 days ago
    Thanks Mark, I'll give this a try!

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