Hi all, I’m having trouble creating/updating hashtags on my users’ posts. Here’s how my database looks:
Collections: Users, Posts, Companies, Hashtags
Users <–> Posts is many to 1. Users can have many Posts, a Post belongs to 1 User.
Posts <–> Companies is 1 to many. A Post belongs to 1 Company, a Company can have many Posts.
Posts <–> Hashtags is many to many.
Companies <–> Hashtags is many to many.
I need to:
- Create New Hashtags if they don’t already exist. (I’m Creating New Hashtag as an second action from the Create New Post form)
- Count the number of Total Posts with a specific Hashtag. (Across all Companies)
- Count the number of Company-Specific Posts with a specific Hashtag.
Currently, on the screen with my list of Hashtags, I’m seeing repeats, and my counts are off. And, the Create New Hashtag action isn’t working. Wondering, should I create a custom form instead of using the Create New Post form? I’ve also tried the blank screen trick which Creates/Updates Hashtags.
thanks in advance for your help Adalo-ers!