Count unique items from repeating group

Hey everyone, i’m stuck on a problem & hope someone can help.

I have a table which is basically a repeating group, with repeating groups inside of it. The interior repeating groups have data which comes from an API call.

What i’d like to do is create a seperate table that shows each unique item & # of each unique item. I can’t quite wrap my head around how to reference that original table. Help!

Gonna bump this up again in case anyone has an idea.

I think the optimal way to do it is with an API workflow. I can get it all set up so it makes a “master list” in the user DB, and then i should be able to run calculations off that data set. However it seems you can’t do that on the Hobby plan.

I’m not sure i want to upgrade my plan quite yet… does anyone have an idea how to accomplish this w/o an API workflow?

This topic was automatically closed after 70 days. New replies are no longer allowed.