Xano Database Difficulty

Get Help External Collections, Custom Actions & Collections
1

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
Adalo DB1586×1036 146 KB

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

xano bd
xano bd1458×1556 153 KB

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!!

Xano Database Issue
2

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

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

Thank you and have a great day!

3

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
add on2544×1380 309 KB

4

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!

5

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
auth me 11831×896 120 KB

auth me 2
auth me 21834×898 108 KB

6

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!

7

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

1 Like
8

@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
image 12212×1214 103 KB

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!

9

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

Let me know!

Thank you and have a great day!