Hello @Jeff_Hager @Manan_Mehta @ThinhDinh @Robert_Petitto , I have one table having 50 entries with Name, Type, Status etc. These are user specific columns. Each such entries are divided in three Status viz. Active, Expired, Expiring Soon. A particular user has 20 entries out of which 7 are expire…

I don’t believe you can do rollups on user-specific columns yet.

Which of those Name, Type, Status are user-specific columns?

User can make user-specific entry and each entry has such status and details.

Just to explain this in details, you can see following Glide Table. [image] There are 9 entries, out of this, 5 are posted by one user and 4 by another user. So for one user, out of 4, one entry is Expired and for another user also, one entry is Expired out of Five. I want this count in User Pr…

Thank you @Jeff_Hager for the response. I am sorry but I am stuck somewhere. I created Template with Name and Status in Main Glide Table. But I am not able to proceed further, I guess I could not understand what your mentioned. Can you please help what exactly I need to do? Thanks

Hey @Pratik_Shah , If I understand correctly. Once you have created the template you need to: Create a relation where “that template” matches the same template on the same tab. Have a Rollup against the relation.

Thank you @SantiagoPerez for response. I actually want the count in User Profile tab (i.e. another tab) from the User Entries Tab.

So you have the user-specific column in a different tab? I have not idea if this would work but I think you could create an ITE. If user-specific column is true then “that template” Then make a relation of that template to the one in you users sheets. I’m sure @Jeff_Hager has a better idea.

Thanks, I guess i got it now. Thank you for all your help @Jeff_Hager @ThinhDinh @SantiagoPerez

Count specific entries from one table to another

Ask for Help

Jeff_Hager October 23, 2020, 11:41am 6

Create a template of name and status joined together. Use the template to create a relation to that same template (relation to itself). Then create a Rollup count against the relation.

Topic		Replies	Views
Como realizo uma contagem de dados específicos? Ask for Help	7	177	March 28, 2024
Display the Count of items matched in a 'Relation' list Ask for Help	29	5032	January 17, 2024
Having difficulties on counting numbers of orders with status X Ask for Help	3	179	February 24, 2023
Count boolean "true" contents Ask for Help	14	528	October 16, 2022
Bug - Rollup + Count + Template Report a Bug	4	391	November 24, 2020

Count specific entries from one table to another

Related topics