Xano DB label magic text

This screen shot is from an app using adalo’s database. In this photo I am using magic text to format a cell for the state name from the current fuel, then I can select State Tax, then name. State Tax is a reference to fuel.

When I try to do this same thing using an external DB “XANO” I see the reference to State Tax but it does not give me the option to pick the State Tax Name. So if I select state tax id it returns an integer.

Figured it out

You need to add a Addon to the query all records in your api

Hi Macgyver - is this the regular query all, get endpoint for your fuel table in xano?

Also, did you need to create a custom action in adalo to pull this data through, or was does it automatically update your magic text options?

Just trying to figure out why this isn’t working for me.