Skip to main content

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

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

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:

 

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

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

Glad that worked ​@Siobhan B! 

Reply


Terms & Conditions