Glide Columns not available to List compontent

Hi. I’ve got a tab with a list, which is sourcing from a Google Sheet with data in Columns A:M. No problem.

I added a couple of columns in Glide Data tab and I don’t see them available in my components, as I’d expect. I think I’m overlooking something dumb.

  • Google Sheet and Glide data Tab are the same and the tab is pointed at the correct source.
  • I went as far as to break away from the correct source Sheet and re-establish it correctly to try to force it to take up all the columns.
  • The columns I added are a Relation and a Lookup - both populated with data as they should have
  • None of the DATA fields (pull-downs) in any Component on that tab has visibility to the new Lookup column.

Thanks in advance for your help!

Did you have a multiple relation?

Yes, the Relation column is a Multiple Relation. And the Lookup uses that relation to pull from another sheet. It does it correctly in the Data editor. But I can’t select that column in the Properties editor.

A lookup against a multiple relation could potentially hold thousands of values in an array. Because of this, you cannot place an array of multiple values into a component that can only hold a single value. You either need to change your relation to a single relation, add a second single relation with a lookup and use that, or create a Joined Text column that will create a joined single value delimited list as a single string of text.

2 Likes

Got it! And for anyone else learning from my fumbling around… it wasn’t enough to simply change the RELATION column to a single relation. I also needed to delete the LOOKUP column and re-create it. Otherwise the returned data would flash momentarily then disappear.

Thank you both, gentlemen. I’ll bring more of these as I try to master Glide. Having a ball.

Onward!

2 Likes

Feel free to ask us if you need help :wink:

1 Like