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