Critical Bug: Dereference formulas are failing after all troubleshooting

Hello,

I have a critical bug where dereference formulas are failing, preventing actions and virtual columns from working.

  • App Name: App

  • The Goal: In my Users table, I have a Ref column named [partner] pointing to my Partners table. I am trying to use a formula like [partner].[Partner Magic Link] to pull a URL from the Partners table.

  • The Problem: This formula always returns a blank value. This causes my LINKTOFORM action to fail (it does nothing) and my virtual columns to not appear.

  • Troubleshooting Steps Already Taken:

    • We have confirmed the data is correct in the Google Sheet (the User has a Partner selected, and that Partner record has the URL saved).
    • We confirmed all table Keys and Labels are set correctly.
    • We confirmed all table permissions (Adds, Updates) are enabled.
    • We tried clearing the browser cache, using different browsers, and forcing a full sync with “dummy edits”.
    • We just deleted the entire Partners table from the app and rebuilt it from scratch. The problem still persists.
  • Conclusion: The app is unable to dereference data from the Partners table. This appears to be a deep platform bug. Please investigate.

Where are you trying to use this formula?

How are you seeing that “this formula always returns a blank”?

1 Like

Hi, all sorted out