I’m trying to make a relation between the row ID of one table (table 1) and an if then else column in another table (table 2). when i make the relation in table 1, it doesn’t work and all the cells are blank. when i make it in table 2 in the reverse order, though, it works. Does anyone know what could be causing this?
I assume you are only expecting a match for the rows that have ven-001 based on your screenshots?
I can also tell by the grayed out rows that you have row owners applied. Are you trying to match to a row that the user you are previewing as doesn’t have access to?
What kind of data sources are you using? Glide Table, Big Table, Other?
What does the configuration for your other relation look like?
- For this particular example, yes, but the other row ID values will get filled in based on user inputs.
- Yes, I just started using Glide so I’m not sure what row owners is or how to enable it, but the row I’m trying to match to is the ID that’s automatically assigned when a row is added in Table 1 (Row ID) to the column in table 2 that inputs the Row ID when a user fills out a form.
- The data is from a form in Glide
- please see the picture below
