# Xano Database Difficulty

**URL:** <https://forum.adalo.com/t/xano-database-difficulty/59627>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [November 27, 2025, 1:22am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627 "2025-11-27T01:22:22Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![renee](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renee](https://forum.adalo.com/u/renee)\
**Post date:** [November 27, 2025, 1:22am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/1 "2025-11-27T01:22:22Z")

</div>

So I finished building my app in Adalo, only to realize it was going too slow. I am now redoing things so that my backend is in Xano. However using a Xano database is giving me a big issue with magic text in Adalo.

Previously, I could basically select any field that was somehow related.

Eg. I could select logged in user, schools, school name.

 ![Adalo DB](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/d/8d3da1aba50767149c4267e4801e2e8a9ce56433.jpeg)

However, when using my Xano database, I can only get as far as logged in user, schools\_id.

 ![xano bd](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/8/b/8bc6b19e082df9cd3dce184b84400ba23bf7ec02.jpeg)

In my Users table (in Xano), my “Schools” field is ‘table reference’ type, to link it with the Schools table.

I know very, very little about Xano, custom endpoints etc, so if anyone knows, please spell it out super simply. Thanks!!

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [November 27, 2025, 4:40am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/2 "2025-11-27T04:40:10Z")

</div>

Hi @renee,

Yes, Xano returns the ID of the table reference field which you need to use an addon to get the data that matches that ID. : [https://youtu.be/XKIbVm-jFGE](https://youtu.be/XKIbVm-jFGE)

Let me know if you still couldn’t figure it out!

Thank you and have a great day!

---

<div class="post-metadata">

**Author:** ![renee](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renee](https://forum.adalo.com/u/renee)\
**Post date:** [November 28, 2025, 12:54am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/3 "2025-11-28T00:54:47Z")

</div>

Hi Dilon,

I have already added an addon to my “Users” query all, get endpoint, but it didn’t to change anything in my adalo magic text options. Any ideas? And thanks!

 ![add on](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/4/1/41237581caf137b5677d2bdb3f980cc87d769e25.jpeg)

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [November 28, 2025, 2:00am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/4 "2025-11-28T02:00:57Z")

</div>

Hi @renee,

Did you add this addon into the auth/me endpoint under the auth section too? Once adding, publish the changes \> click the three dots for the users collection in Adalo \> edit settings \> run test \> save.

Thank you and have a great day!

---

<div class="post-metadata">

**Author:** ![renee](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renee](https://forum.adalo.com/u/renee)\
**Post date:** [November 28, 2025, 11:30pm UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/5 "2025-11-28T23:30:49Z")

</div>

Hi DIlon, thanks for your quick responses. Like this? It hasn’t seemed to change anything in the adalo end? I did run the test and save in the user’s collection.

 ![auth me 1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/0/e0eb88c6c3211ccb5f6589918c506d7f07bb20b0.jpeg)

 ![auth me 2](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/4/e4ada2957c5077b6a416e1ae1e60e72f4d26c1f9.jpeg)

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [November 28, 2025, 11:47pm UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/6 "2025-11-28T23:47:29Z")

</div>

Hi @renee,

You’re very welcome!

What about the, users/ {users\_id} (GET) endpoint? Have you added the addon into the output and published the changes?

Thank you and have a great day!

---

<div class="post-metadata">

**Author:** ![renee](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renee](https://forum.adalo.com/u/renee)\
**Post date:** [November 29, 2025, 12:30am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/7 "2025-11-29T00:30:59Z")

</div>

And it’s working! Champion, thanks so much!

---

<div class="post-metadata">

**Author:** ![renee](https://avatars.discourse-cdn.com/v4/letter/r/9dc877/32.png) [@renee](https://forum.adalo.com/u/renee)\
**Post date:** [December 3, 2025, 1:26am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/8 "2025-12-03T01:26:06Z")

</div>

@Dilon - Do you know why the same options don’t appear when selecting an image?

I want to go: Image Source: Database _ **→** _ logged in user’s _ **→** _ school’s _ **→** _ profile picture.

It gives me this.

 ![image 1](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/1/5/1526c1e16f125a5080bb500865ccd6578cb31749.jpeg)

When I try the URL route instead of the database, the right option appears, but the image doesn’t appear in the previewer.

The field type in Xano for profile\_picture is image metadata, though in Adalo it shows as text.

Thanks!

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [December 3, 2025, 1:30am UTC](https://forum.adalo.com/t/xano-database-difficulty/59627/9 "2025-12-03T01:30:07Z")

</div>

Hi @renee,

You need to go with the URL option instead the Database option. For an image column in Xano, there should be several properties that you should get along with the image URL which you can easily map it from magic text. Check out this video. : [https://youtu.be/\_ihJfliN124?si=0Nn4LnJt7j5pip7X](https://youtu.be/_ihJfliN124?si=0Nn4LnJt7j5pip7X)

Let me know!

Thank you and have a great day!
