Showing pending status summary

[maxweir]

I have a personal facebook art page where I post to many related facebook art groups, when a post is submitted to a group it goes into a moderation state, then I just wait for their admin to accept/decline the submission.

I've setup a base that contains:

• All posts: Individual art pieces
• Groups: Each Facebook group I belong to

In the "All posts" table, I've added a "Roll out" column which is to show the status of whether I've posted to all groups. But I don't think this is ideal as it has no relationship to the groups.

What I would love to see is some kind of progress state column that tells me how many groups there are outstanding which I have yet to or are waiting on post approval.

[TheTimeSavingCo]

Hmm, I think you just need to add another linked field to your "Groups" table, and make sure that each post in "All Posts" is linked to all the records in "Groups", and you could just make an automation trigger on record creation in "All Posts" to handle this link for you

Once that's done, you can do this:

And we're just using count fields and then formula fields to get the %s
Link to base