How to link collections via id of users

Hello, I am using retool with firebase, and I would like your help on this problem! I am new on retool, thanks in advance :smile:

"How to retrieve the ID of a person in a Firebase Firestore collection based on a specific value, and then use this ID to extract data from another Firestore collection and display it in a table on Retool?"

Thank you :grin:

Hey @alban47!

Are you looking to do something like this?

Let me know if that's helpful at all, or if you have any other questions!