How to Display Data from Two Firebase Collections in a FlutterFlow DataTable?

Database & APIs

I'm working on a FlutterFlow project where I need to display data in a DataTable. The data is split between two Firebase collections:

  • Users Collection: Contains fields like profile, name, and appliedDate.

  • User Details Collection: Contains a list of user details, including status.

I want to display the following in the DataTable:

  • Profile (from the users collection)

  • Name (from the users collection)

  • Applied Date (from the users collection)

  • Status (from the user details collection)

The challenge is that status is stored in a separate collection (user details), while the rest of the data comes from the users collection.

How can I query both collections and combine the data to display in a single DataTable in FlutterFlow? Any guidance or examples would be appreciated!

What have you tried so far?
  • I’ve successfully queried the users collection to display profile, name, and appliedDate in a DataTable in FlutterFlow.

  • However, I'm struggling with how to fetch the status from the user details collection and combine it with the data from the users collection in a single table.

  • I tried using separate queries for both collections, but I’m not sure how to link the status field from the user details collection to the correct user in the users collection.

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