Per user settings filter not working

[Savio]

Hi, i set this settings on my per user setting, so the user can select it service center location, and then i want to filter the tasks based on the selection on the first page, but its not working, how can i do it?

Atividades means tasks, in portuguese… I want to filter these tasks based on the first screen selection.

[Suvrutt_Gurjar]

Please create a slice on your tasks table with a filter expression expression something like

[SVC] = USERSETTINGS(SVC)

This presumes you have a column [SVC] in the tasks tabe as well.

[Savio]

I did that, but its still showing all of them

[Suvrutt_Gurjar]

Could you share relevant screenshots? Also hope you have taken a look at the Lifetime feature of the usersettings in the emulator environment as mentioned in the article referred to below.

help.appsheet.com

User Settings: The Essentials

Give users more control to customize app behavior.

[Aurelien]

Hi @Savio

@Suvrutt_Gurjar is correct.
A way to workaround that, is to look into the menu, click on Settings, then Save.

Please keep in mind you will need to do this every single time you Save in order to be able to use the usersettings.

[Savio]

I got it working! Thanks.

One more thing: i have the user selector on my first page, with a password field (set in user settings), and i have an expression to lookup the password, but its working only the first password of the table, how can i force it to match every login with every password?

I can login with every user, using the FIRST password of the list… and i do not want that

[Steve · Accepted solution]

You’re using LOOKUP() wrong.

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Savio]

Can you help me? I cannot figure how to do this

[Steve]

Read the help doc.