Bringing value from one table to another like INDEX MATCH would do

Ask for Help
1

Hello
Ok so I have a user table where it tells me whether the user is a CLAIMANT or a DEFENDANT in a case.
I then have a case table - listing all the open cases.
In this table case, I’d like to list who the claimants and defendants are. I think in Excel I would do that with a INDEX MATCH formula. But I have not been able to find a solution to do this in Glide.
Thank you

image
image1437×490 63.9 KB

image
image1429×524 54.4 KB

2

You’ll need 4 columns in your Cases table. Two Query columns, and two Single Value columns.

  • queryClaimant: A Query column that targets your Users table and applies the following filters:
    – CaseID is This row → CaseID
    – Role is Claimant
  • queryDefendant: A Query column that targets your Users table and applies the following filters:
    – CaseID is This row → CaseID
    – Role is Defendant
  • svClaimant: A Single Value column that targets the first Query column and takes the first Name
  • svDefendant: A Single Value column that targets the second Query column and takes the first Name
4 Likes
3

Thank you. So I need to use Query so I can use the ‘filter’ feature - and not use relation and lookup.
Thanks for your help.

4

Yes, that’s correct.
Before we had the Query column, you would have needed Template->Relation->Lookup.
The Query makes it easier.

2 Likes
5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.