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.