Hi all! None of my views are finding the colu...

(Alex Meraru) #1

Hi all! None of my views are finding the columns in the tables.

Ideas?

(Aleksi Alkio) #2

Would you please give us more information about this problem, thanks.

(Alex Meraru) #3

I want to use Show if [email]=useremail() As soon as I type [email] (or any other column) I get the message “Unable to find column [email]”

(Alex Meraru) #4

the way I did it: (I am new to this- just a few days)

row filter on the slice : [Email]=USEREMAIL()

  • works UX-slice_view

Show_if= OR(USEREMAIL()<>"office@gmail.com",[Email]=USEREMAIL()) - doesn’t work. Can’t find the column

(Alex Meraru) #5

Solution: user_view Show_if= Useremail<>"office@gmail.com"

but still, why would I get that message if I want to refer to a column?

(Aleksi Alkio) #6

Now I probably understand. You are trying to use the Show_If for the view, not for the column, correct?

(Alex Meraru) #7

yes!

I got it working as above.

(Alex Meraru) #8

is the problem because in the view details

For this data = Slice

and not

For this data

= table

?

(Aleksi Alkio) #9

You can’t hide the view because of the column’s value. This is because the view will be confused when there is both TRUE and FALSE as condition results.

(Aleksi Alkio) #10

It sounds weird. The only thing I can think is that you don’t have Email column name in your table structure.

(Alex Meraru) #11

@Aleksi_Alkio it is weird but I have tried all the columns. I’ve tried on other views as well.

Unable to find column […].

I had a security filter on the table =“admin@mail.com”

I have removed it.

Same message :unamused:

(Aleksi Alkio) #12

What is your formula exactly?

(Alex Meraru) #13

@Aleksi_Alkio

OR(USEREMAIL()<>"office@gmail.com",[Email]=USEREMAIL()) Translate

(Aleksi Alkio) #14

Okay… the format is correct

(Aleksi Alkio) #15

This means that who ever can see the row except office@mail.com. The 2nd part [Email]=USEREMAIL() is not even needed if that’s the purpose.

(Alex Meraru) #16

it is because what I need is:

1.main table for admin (me) with full access 2.slice for the users as there are some columns for my eyes only 3. the rows must be filtered because the users will see only the records that they’re assigned to by [Email]

(Alex Meraru) #17

I don’ need to see the slice view as I have full access to the main table and i do need all the columns