USEREMAIL()=[Email] not working with error Unable to find column 'Email'

[abood89]

Hello

Im trying to use USEREMAIL()=[Email] to control which user can see a certain view through UX by using SHOW IF but im getting error Unable to find column 'Email' even though the column is there in the table 

[Marc_Dillon · Accepted solution]

You can't do that.

You may be wanting Slices or Security Filters?

https://help.appsheet.com/en/articles/895302-slices-the-essentials

https://help.appsheet.com/en/articles/954497-security-filters-the-essentials

https://community.appsheet.com/t/current-user-slice-how-to-conform-your-app-around-who-is-using-the-...

[Marc_Dillon · Accepted solution]

You can't do that.

You may be wanting Slices or Security Filters?

https://help.appsheet.com/en/articles/895302-slices-the-essentials

https://help.appsheet.com/en/articles/954497-security-filters-the-essentials

https://community.appsheet.com/t/current-user-slice-how-to-conform-your-app-around-who-is-using-the-...

[abood89]

Thanks for helping out

i did try it with security filter and it works but i can see that security filter needs appsheet core. is it possible to use security filter if im  not going to deploy my app and stuck with free plan ?

[graham_howe · Accepted solution]

If you use a Slice instead of a Security filter then that would not require Core. It is not a true security mechanism, nor does it help with performance as security filters can, but it should give the same user experience you are looking for.

[Steve]

https://help.appsheet.com/en/articles/1128148-limiting-users-to-their-own-data

https://help.appsheet.com/en/articles/962137-limiting-users-to-particular-tables-views-and-actions