Tracking users with a "Read Post" action button within the post

[Simondalgas]

Hey Guys,

Im trying to get my head around how to build out a action within a post/resource, that when the user have Read and Understood the content or update for a work SOP etc, they will press the Action and that will add a row with timestamp, useremail, post topic, etc.. 

We will submit new posts every other day, 3-4 per week.

How can I track who is missing which posts from an admin side, as well as the user will be able to local track which posts that a new and they havent read yet?

Do I need two tables, one for the posts and one for user track logs? 

I imagine the tables will be with quite lot of activity as I expect to have 80-100 users reading and check in posts per month.

Please advise 🙂

[peterson]

I guess you'll need another table and one column REF set as IS PART OF, there you'll can create columns such as user, date and time, Got it? (yes/no) 

then in the parent table you'll have the post/text whatever, and one ACTION that adds anew row to another table. You'll need to set the ref column as the parent table ID, this way you'll create a connection between the new child-row to this exisitng parent-row