Ref column using a google sheet table

tintin007 · 06-28-2023 10:06 PM

Hi,

I have a couple apps one using appsheet created table and the other using googlesheet table. My trouble seems to be that de-referencing does not work when using the same principle of ref columns with the google sheet table. Is there something different i need to do ? I did a search in here but couldnt see a solution

Appsheet set up

[User].[Email]=Useremail() This works and returns the correct user email

using google sheet table

[User].[User Email]=Useremail() returns false

would a show if expression used in a view affect the way the above works

Index(SELECT(User Role[CURRENT USER], ([Role ID] = Index(Current User[Role ID], 1))), 1)

the only difference i can make out between the two apps is the addition of the user role table.

hope that makes some sense,

Cheers

Tommy62

Normalerweise hat man nur eine Spalte zur Beziehung zu Benutzer-Mail() siehe: Benutzer Ansichten

tintin007

In The user table i only have one column as an email column. the formula used works when using an appsheet table but not when using a google table though. got me confused as how to fix it