Custom Views basd on user email address

Nin_o
Participant II

Hi,

Is it possible to have different views based on e-mail address?
In my table (Orders), I have a column named Store Location.
What I want to do is for a user to have a view only for 1 store location associated to hime (example: user1 will see only location1 orders, user 2 and 3 only for location2 view, user 4 only for location3).

If this is possible, how can I achieve this? Is there a step-by-step guide that I can follow?

Thank You

Solved Solved
0 9 217
1 ACCEPTED SOLUTION

Hi Steve,

Just wanted to thank you for all the guides. I managed to resolve this by:

  1. Creating UX Views from Slices by Store Location
  2. Use Show_if USEREMAIL() for the UX Viewโ€ฆIโ€™ve read about your post in using OR() and IN() expressions.

Cheers

View solution in original post

9 REPLIES 9

Steve
Participant V

Nin_o
Participant II

Thanks for this one Steve, Ive already came across these informational articles before I sent the question.
I guess my dilemma is how to execute this. I was looking for a a tutorial/guide on how to achieve/implement the info provided.

Based on the scenario I enumerated at the start, should I:

  1. Create Slice Views by Store Location?
  2. How do I associate a Slice View to a particular userโ€™s e-mail address?
  3. How do I present the Slice view associated with that userโ€™s email address when they log in? For example, If i define that Slice View as a table, and have it display as primary View on bottom leftmost, the view would only show the location associated with that user and not all views?

Currently, what I have is as shown below:

  1. An Order View (table). It shows all Orders on all Locations. What I hope to achieve is to just show 1 Location based on email-address of user.

Appreciate if you can handheld a novice here.

Thank You,

Ninia

How does your app know which locations are tied to a given userโ€™s email address?

I believe thatโ€™s one of my help questions I raised.

  1. Should I create a new table with E-mail address and Store Location association (1 column email address, another column Store location)?
  2. Should I add just another column in the existing table (example: E-mail address) and set its value as the e=mail address of the signed-in user that is creating the record?

Thatโ€™s a decision for you to make.

Nin_o
Participant II

I guess the proper question to ask is, are those solutions appropriate for what I want to achieve?

Yes, definitely! Myself, Iโ€™d go with (1).

Hi Steve,

Just wanted to thank you for all the guides. I managed to resolve this by:

  1. Creating UX Views from Slices by Store Location
  2. Use Show_if USEREMAIL() for the UX Viewโ€ฆIโ€™ve read about your post in using OR() and IN() expressions.

Cheers

Well done!

Top Labels in this Space