Having issues with firebase queries - complicated, nested queries

Database & APIs

Hello everyone.
I am building a stock market app and I wanted to inplement the watchlist functionality on my app. To do so, I had a users collection, and a watchlists subcollection. The watchlists subcollection had a list of companies/stocks that it tracks.
My issue is, how can I access properties of the company? In flutterflow, I can request the watchlist documents, but each document does not directly the information I need, I have to go into a list, and then into the document referenced in the list, and get a name.

Has anybody done something like this? How can I solve it?
I dont really want to change the backend arquitecture, but if you have any suggestions of a different schema let me know.

Ps. I will attach an image for reference

What have you tried so far?

So far, I tried to query the watchlists page, and then within my component, select the list. Couldnt find a way of accessing properites of the document referenced

I was also thinking of accessing through code, which would be more flexible

Did you check FlutterFlow's Documentation for this topic?
Yes
2