How to setup cards with data from other table?

[gabrielmg004]

Basically I’m trying to display some informations in a card collection, while the user specific data are in another table.

I’ll give an example to understand it better: I want to display the systolic pressure from a patient inside a card collection with an image. The systolic pressure is a column in my user’s table, alongside with other data (diastolic pressure, glicemy, etc). The card collection source is from another table, so i can choose an image for each category.

Is there a way to do that?

[Federico_Fleitas]

Hi,

If you have the information in the table Users, you can use this information, because only the data into the table Users is Global, you use the card Collection, in this case you need add into the Tittle, description or Metate the UserRow, like This

[gabrielmg004]

If I understand it correctly, i can’t do that. If i select something in the user table like you’re doing, every single card will display the same value. Like, “systolic pressure 110”, “diastolic pressure 110”, “glicemy 110”

[ThinhDinh]

In the table where you hosts the Categories, add an if-then-else column.

If Category is A, return stat A from the signed-in user’s row.

And so on for the other categories.

Then, you can use that column to display with the cards.

[gabrielmg004]

Thank you so much, it worked just fine!