I think I know the answer, but I thought I’d ask. I have a table with rows of data sorted by date. I was hoping I could look up rows by date and use them to populate a data grid component.
I suspect that the data grid component just points to a table and can’t be derived.
Do I have that right?
I love to create an relation to this table and select by date, then display that in a data grid column.
As always, help appreciated.
Why can’t you use a relation, query, or filter to do that?
As always seems to be the case with me, now that come back to glide it’s working. Sigh…
Is there a way to easily remove the display of the index column from the left?
Nope, have you tried using the new table component instead?
So, I can get the relations and lookups to create columns in the data grid component. I can’t figure out how to do the same in the table component. What is the difference?
Can you tell me what you mean by “create columns”? It should be the same method between the two components (add a new column and point to the right value).
I have a table of dates. Columns are date-as-key, start, best and end.
In a different table, I capture a date selected by the user. In this table I have a relation linking the selected date to rows in table of dates by the date key column.
I create 3 lookup columns, one for start, one for best, one for end thru the relation.
When I create a data grid and select a look-up, say start, for a column value, the data-grid column is filled with the data from the lookup.
When I use a table and select the same look-up for a column, it populates the column with the entries from the start column, not from the specific start look up value.
You can see from the images, I’m using the same columns/look-ups for values in both cases, but the results are different.
All help appreciated.
But you’re having multiple values in the lookup right? If you want a single value, your relation should be single.
How are you creating the relation/lookup and what do you want to achieve here?
It’s working perfectly for the Data Grid. I want the multiple values from the relation/lookup to populate the column of the grid or table. That’s exactly what I want.
I use the exact same sheet with the exact same lookup columns in a Table and I get the different answer.
With respect to how am I creating, not sure what you mean. I’m using the Glide interface, adding columns, selecting types and options in the pop-ups. Nothing fancy or custom.
What I’m confused about is that the same exact information source, used in the same way in the two components behaves differently.
Interesting! I’ll double check it. That would explain it. Thank you.
