Using Xano to store some data

Hello,

Since I don’t know much about this, I’d like to know if I can use Xano to store only a certain portion of the data (like user photos and messages) and create relationships with the Adalo database to properly link the photos or messages to the users?

I’ve read that you can do a lot with Xano.

Thank you and have a good day.

Hi @DarthSztoru,

You can store some data in Xano and some in Adalo, but there is no built-in way to create the relationships between the two; you will need to maintain relationships manually using some field (e.g. id). In your case you can add Xano tables as External Collections.

Best,
Victor

In addition to Victor’s answer, check this video out which was recorded by Jake (Past Adalo Staff Member). : https://youtu.be/3RQgpPv-0Uk

Thank you and have a great day!

Hey @DarthSztoru,

You can keep users in Adalo while storing large files like photos and messages in Xano. This is a smart way to scale.

You can use this approach:

  • Add Xano tables as External Collections in Adalo.
  • Add a field in Xano called adaloUserId (text or number).
  • When you create a message or photo, send the Logged In User’s ID into that field.
  • Then, filter the list to show where adaloUserId equals the Logged In User’s ID.

You don’t need a complicated relationship, just a simple match. It works great.

Victor mentioned the manual ID trick; this is the quick setup to make it work.

If you want a ready clone, just let me know.

Ali Bazzi

Adalo Community Leader & Expert

Templates, Audits & AI Services: webnux.org

Book a consultation: consultation.webnux.org

Hello

Thank you all for your help. I’m going to use the UserID technique, if it works as well as you claim, then that’s exactly what I need !

2 Likes

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.