How can I build an activity tracker with Xano?

leonardkinzinger

Hey!

I would like to create an activity tracker for my dashboard. To be flexible with more upcoming modules, I had the idea to create three different databases. One for modules, one for submodules and one for activity_tracking of users. I would like to left join the submodules with my filtered activity_tacking table for that specific user (basically adding column with a 1 for every submodule that is present in the activity_tracking table and a 0 for every module that is not jet in the activity tracking table). Then I would like to extend the modules endpoint with the joined result.

I currently struggle to perform the left join. How is that done with Xano?

Does the whole approach make sense or is there an easier way to achieve this?

Many thanks!
Leo

Liz Anaya

Hi @leonardkinzinger! 👋

Have you looked into Addons for this use case? Addons allow you to enrich the response from a single API endpoint with additional data from other database tables. Check out this video 👇 and let me know if it helps! 😊

https://youtu.be/t9qXwFVUZZ0