Hi, I’m a newbie to Glide. I have a data table called ‘productions’ and another called ‘allocate tickets’. I have created a form to allocate tickets. What is the best way to pull data from another table? All I want to be able to do is display the contents of a field from the ‘productions’ table in my allocate tickets form.
I have tried using a text component, but all I get is this:
You need to bring the value you need into the current table. The best way to do that depends on your table structure, but it could be as simple as a Single Value column.
Can you share screen shots of both tables?
Thanks Darren,
The first screenshot is of my productions table, the value that I want to add is the tickets remaining.
The second screenshot is of my allocated tickets table
Okay.
So I assume each row in your Productions table represents a discrete Production?
And each row in the same table should link to one of more rows in the Allocated Tickets table?
Given the above is correct, what you want is a single relation (or query) from your Allocated Tickets table that matches the correct row in your Productions table, and then use a Lookup through that relation/query to fetch the value you need.
It looks like you already have a couple of relations, but I can’t tell if they are correct.
I’m also curious about how you are calculating the remaining tickets value? I have a feeling that might not be quite right.
Hi Darren,
Yes, you are correct about the productions table. I have used AI to help me so far!
To calculate the tickets remaining, I have a linked productions table and I I’m using a rollup field to calculate the number of tickets allocated from the allocated tickets table and then using a math field to subtract the rollup field from the tickets offered column.
Okay, that sounds right. Is it giving you the correct result? (difficult to tell from your screen shots).
Did the Lookup column work for you to get the value into the Allocated Tickets table?
Yes, that all worked, but I’m struggling to get that value from the productions data table into the form. I want to be able to display that value so that there are not more tickets allocated than are available
Is the relation a single of multiple relation? (It needs to be single).
If your Lookup column returns a value in a “bubble”, that means it’s an array and your relation is a multiple relation.
1 Like