Help to make calculation that determains how many times a category is selcted in portal
I have a portal, where i have a button that can add records and another one that can delete the records again.
in each record you can choose a category, fx fabric, lining or leather.
next to the category is there a number (currently all showing no.1).
Is it possible to have that number change to fx. fabric no. 1 when you add the first fabric and then lining no. 1 if thats the next record, and if third record again is fabric the number will this time turn into 2... and should you then delete fabric no.1 fabric no.2 will then turn into fabric no.1..?
So basicly im looking for some help so my portal knows based on the category what number it has to put in the field...?