Salut!

If you could let us know how your data is structured right now, that would help us out.

Ideally, there would be a Client table and a Calendar Appointment table. Where each record in the Calendar Appointment table is linked to a Client record. Then, you would use a Rollup field in the Client table that counts th number of appointments.

It would look like this:

Image 1: Calendar Appointment table would add a linked record field to Client.

Image 2: Client table would add a Rollup field with formula: `COUNTALL(values)`

I hope this helps. Let us know if you are able to implement this approach.

Hey ​@Komaroff,

As mentioned above, you will want to have two different tables. One for Clients and one for Appointments, where one Client can be linked to multiple Appointments

Once that is done, I would actually suggest creating a Count field on the Clients table, as it is easier to set up. You can find more info on Count field Type on this article.

Hope this helps, and please feel free to reach out as needed.

Mike, Consultant @ Automatic Nation

Voilà ma base de données et mes tables 

Ça coince mais je ne sais pas où ?

merci à vous

Cédric

Thank you for the images. We’re almost there!

We just need to do two things.
1. Make sure each Seances de Kine links to a Patient. You do that by going into the Patient cell for each Seances de Kine. Then, click the plus sign and add the Patient.

2. Let’s go with Mike_AutomaticN’s easier suggestion. We will create a Count field like so:

I hope this helps!

Merci beaucoup 

Maintenant j’aimerais créer un champ avec formule qui me donnerait le nombre de séances par patient depuis la dernière facturation.

Quelle serait cette formule ?

De rien

If you've found my comments helpful, please give them a like because it will let others know that I am credible. Thank you!

To do what you want to do it would be easier to take a different approach:

1. In the Seance de Kine table, we will create a field  to record whether it was paid/unpaid.
2. In the Patient table, we will create a Count field only counting the unpaid Seances

It would look like this:
 

If you want to do it using the Date de la derniere facturation, it’s a little bit trickier:

1. In the Seance de Kine table, you would need to create a lookup field to bring in the Date de la derniere facturation from the Patient.
2. In the Seance de Kine table, create a formula field with the formula: 

   Date <= {Date de la derniere facuration (à partir de Patient)}

3. In the Patient table, we will create a Count field only counting the unpaid Seances

It would look like this:
 

Bonjour,

quand je veux importer des tables en csv, lorsque je veux importer la deuxième table on me demande d’enregistrer la première table et du coup les 2 tables ne figurent pas sur la même base.

Comment faire ?

merci