Unable to find a referenced column with an slice

AppSheet AppSheet Q&A
1

Hi everyone,

I have this issue with finding a column in this formula:

3X_e_3_e31774d1e243955f1b9c2fa247ab4036d721df38.png
3X_e_3_e31774d1e243955f1b9c2fa247ab4036d721df38.png880×239 15 KB

i’m trying to do a security filter but this error appears, this are the tables wich are called:
Table Unidades

3X_6_2_62ad33ab0dc414663e36ec53b52f7c1f60611999.png
3X_6_2_62ad33ab0dc414663e36ec53b52f7c1f60611999.png1162×732 45.9 KB

Table Proyectos (From wich ProyectosID is called)

3X_5_7_5743abe89419d869edc94b5f04e9184680631fad.png
3X_5_7_5743abe89419d869edc94b5f04e9184680631fad.png1157×560 45.5 KB

Table usuarios
This is were the slice “users” is made

3X_6_2_629bcef43e8b4e2d9a5b111b73cd8eed4a7b3776.png
3X_6_2_629bcef43e8b4e2d9a5b111b73cd8eed4a7b3776.png1171×565 36.2 KB

3X_5_d_5df309d0a40e7260608754baad90630a9af37b1c.png
3X_5_d_5df309d0a40e7260608754baad90630a9af37b1c.png949×321 19.9 KB

I don’t know why the formula doesn’t recognize the ProyectID column, i think everything is referenced as it should be.

2

Hi @Oldsoul

That’s strange indeed, your expression looks fine to me.
But I better go with the data table directly, instead of slices.
You may want to try that instead:

OR(
  LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL")= "Admin",
  AND(
    LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL")= "Usuario",
    LOOKUP(USEREMAIL(),"Usuarios","UserID","ProyectoID")= [ProyectoID]
  )
)

or

OR(
  LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL")= "Admin",
  AND(
    LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL")= "Usuario",
    IN(USEREMAIL(),[ProyectoID].[Related Usuarios])
  )
)

or, equivalent (assuming [ROL] is Admin or Usuario only):

SWITCH(LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL"),
   "Usuario", LOOKUP(USEREMAIL(),"Usuarios","UserID","ProyectoID")= [ProyectoID],
   true
)

or

SWITCH(LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL"),
   "Usuario", IN(USEREMAIL(),[ProyectoID].[Related Usuarios]),
   true
)
2 Likes
3

The users slice probably doesn’t include the ProyectosID column of the Usuarios table.

1 Like
4

Thank you both @Steve and @Aurelien !

@Steve you’re right, it worked after i did this, ProyectosID Column was not included in the slice. I added that column after creating the table Usuarios and i tough the column will be added instantly as well.

@Aurelien This last formula worked just fine! thank you

SWITCH(LOOKUP(USEREMAIL(),"Usuarios","UserID","ROL"),
   "Usuario", IN(USEREMAIL(),[ProyectoID].[Related Usuarios]),
   true
)

Wish i could give you both the solution check.

2 Likes