My 3rd Day over here and queries continuing , Appreciate the help and guidance that i am receiving.
For today, i am facing a challenge to find the count of rows that exist for a particular category of records.
from the table shown above, i am trying to fetch the number of Fruit (which should display as 3) and Vegetable (which should get displayed as 2)
Okay, try this:
it checks if the number is added to the list values2 in another time.If its added . that means that its a doable value.Now it will check again if this number is in the duplicate numbers list. if so it will just increment the duplication number by one.Else, it will added to the duplicated registered numbers list an add in the duplicate count only two. lastly it adds the number to the list values 2.
Note: you must set the field type in airtable to number.