Skip to main content
Question

How to Pick out the highest session number per client in session log table

  • May 17, 2025
  • 5 replies
  • 102 views
S
Forum|alt.badge.img+2

Hi Everyone,

Hope you can help me out please.

I have a table with a client session log adding a new record for each client when they have another session:

 

 

I would like to be able to show how many sessions each client has had (eg the maximum number of sessions). In this case for Jamie it will show 3.

I want to be able to bring the name and number of sessions into a report - Jamie - 3, Siobhan - 2, as a list.

Could anyone please help me to generate this field so that I can pull it into a report?

Thanks so much for taking the time to look at this if you are able.

Kind regards,

Siobhan

    5 replies

    S
    Forum|alt.badge.img+2
    • Siobhan B
    • Author
    • Participating Frequently
    • 5 replies
    • May 17, 2025

    Hi there, I’ve worked this out now. Thank you!

    TheTimeSavingCo
    Forum|alt.badge.img+31

    For anyone that stumbles across this thread in the future, you can do this by adding a formula field to convert the select field value into a number:

    And then in your main table creating a rollup field with “MAX(values)” as the formula:

     

    Adam, Airtable Consultant - thetimesaving.company
    Mike_AutomaticN
    Forum|alt.badge.img+28

    The following approach could also work:

    Four the number of sessions you could use a Count field also (more on count fields here).

    For the name you could have a lookup, sort it by Date (earliest to latest), and limit it to the “Last 1” (more on lookup fields here).

    Hope this helps!

    Mike, Consultant @ Automatic Nation

    S
    Forum|alt.badge.img+2
    • Siobhan B
    • Author
    • Participating Frequently
    • 5 replies
    • May 19, 2025

    Thanks Mike and Adam,

    I did actually use a Count field to solve the problem, which I was then able to bring in to the report.

    I really appreciate you both taking the time to help.

    Kind regards,

    Siobhan

    Mike_AutomaticN
    Forum|alt.badge.img+28

    Glad that worked ​@Siobhan B! 


    Terms & ConditionsAccessibility statement