To sort the groups…

Hmmm - Can't see how 

You are grouping on the name Famille which can be ascending or descending. In order for the count to show you have this set an another field with each group to give the number of lines(records) within each group. Thus you would need and additional sub sort. - Try as I might I cannot get it to do this for you at the moment... 

but will keep trying ....

I created a formula field with a group count followed by the name of the group

let g := this.Group;
let n := cnt(select Table where Group = g);
let t := lpad(text(n), 3, "0") + " " + Group;
t

This gives, for example, 003 Laridae

These can then be grouped and sorted to give what you want, but adding an additional record causes problems as the group count is not updated in the other records. They can be updated but not easily in normal use.

Normalising the database could help. The parent holds the name of the group and a count of its children. These can be displayed, grouped and sorted in the child record as required.

Regards

John

What kind of data is in Ordre? What you display in the picture is a count of the number of records in based on the field Ordre.

Can you give me an example of the data that is in Ordre?

When you try to filter Ordre and you type in 2 you are saying it doesn't return any records?

Thanks for the pictures.

So the data in Ordre and Espéce is text. So of course it would show you no records if you filtered on any number.

You can filter Ordre by Guiformes or Apodiformes. You can filter Espéce by Platyrhynchos or whatever is in the field.

Again, the number you see in your tables #2 or #3 is the count of the records. Those number are not in your records.

What are you trying to do?

You can't order by count of Ordre. If you refer back to your first picture and my comment from March 6 at 6:20, those numbers you see are not real numbers to arrange.

Think of it this way. What kind of data is in Ordre? It is text. Your can arrange the table on the Ordre field either alphabetically or reverse alphabetically.

To start to analyse your data (like how many Guiformes you have) you will have to create a dashboard (which is just another other table) that then looks in to your main table. But this is a much larger conversation that can't really be answered in a forum like this.

I don't know if Ninox has any French language support or any videos in French. I know Nioxus will soon have support in French so if you go to their site (https://nioxus.com/) then you can ask them to let you know when you they do.

If you are on Facebook you can join the Ninox French group:

https://www.facebook.com/groups/1232955430369279?__cft__[0]=AZUNnFcNfG6iVk1YmEt_bwwKCPTschmmFOne4niUuosrsaq6Lji_gyijm6W43Kc0TKgOsOuHVYWORL2ci780QmR7e6JJC62dobMldvwq7FPXVfuYEttdeRHJO-FEpX1hzAwQv02gcy6amZoyThJ0btTi&__tn__=-UK-R