I need to create a WordPress table that stores events that occur for a user. These events usually happen externally to the WordPress environment (Infusionsoft Tags). The events can also be triggered by updates to a google sheet and zapier if needed.
The user completes tasks A (not in WordPress) this is stored in that user's record in the table.
I then want it to be possible for a user to see a history of their tasks and also see a history of other users tasks and sort by who has accumulated the most points from these tasks.
You will need to know how to remotely add to a WordPress database. Infusionsoft knowledge to tap into the API would be handy but not essential.