Authenticated User “User Reference (users ref)” not available in FlutterFlow, causing Firestore query filters to resolve as “Unknown” and fail data fetching

🧾 Issue Summary for FlutterFlow Support 📌 Project Context

• Platform: FlutterFlow (Web Builder)

• Backend: Firebase (Firestore + Authentication)

• App Type: Journaling / Reflection App

• Core Flow:

  • User logs in via Firebase Auth

  • User creates a reflection (stored in Moments collection)

  • Each moment is linked to a user via a Doc Reference (users)

  • UI fetches latest moment using:

user == current user reference

🧱 Firestore Structure

1. users collection Fields:

• uid (String)

• email

• display_name

• created_time

• etc. 👉 Document ID = Firebase Auth UID 👉 uid field = same value (verified)

2. Moments collection Fields:

• user → Doc Reference (users) ✅

• reflection → String

• mood → String

• context → List

• created_at → DateTime ⚙️ What Was Working

• Firebase Authentication works correctly

• Users are created in Firebase Auth

• Users collection exists and matches UID

• Moments documents are being created successfully

• Firestore rules are working (no permission errors now) ❗ Current Critical Issue 🔴 Problem 1: "User Reference" Not Available In FlutterFlow: Location:

• Create Document → Moments → user field

• Backend Query → Filter (user == ...) Issue: Under:

Authenticated User

👉 All options are greyed out Specifically:

• ❌ User Reference (users ref) is NOT selectable

• ❌ Only fields like email, UID, etc. appear (non-reference)

• ❌ Selecting anything results in:

Unknown ❌

🔴 Problem 2: Query Filter Not Working Query:

Moments
Filter: user == [Unknown]
Order: created_at DESC

👉 Because value is Unknown, query returns no data 🔴 Problem 3: UI Shows Placeholder Data Due to failed query:

• pMood

• pReflection

• "Context" 👉 These are fallback/static placeholders 🔍 What We Tried (Step-by-Step) ✅ Step 1: Verified Firestore schema

• user field is Doc Reference (users)

• users collection exists

• UID matches document ID ✅ Step 2: Fixed Security Rules

• Removed restrictive rules

• Enabled authenticated access ✅ Step 3: Verified Data Creation

• Moments documents are being created

• user field stores correct reference path:

/users/{uid}