Hi Expert
I wonder this is possible (not because I never use that) to filter off all the rows displayed where the column email value <> useremail()? E.g in the scrap list there are many users keying in data, I want it to display only the column [PERSON DECLARED e-PROFILE EMAIL}=USEREMAIL(). Where to key in that expression ?
Use a Slice.
Or a LINKTOFILTEREDVIEW() action.
Can show some example ?
You will find plenty of examples by researching either of those things.
You can add your expression [PERSON DECLARED e-PROFILE EMAIL]=USEREMAIL() to create a slice of the table that your âScrapâ view is based on to make a slice of that table. Then you can use that slice for the âscrapâ view rather than the full table.
Thank very much and that is very helpful. I try but it does not seems to display that email I want
Shows all row N
Have you saved the slice and updated your scrap view to see if it works? I find the Tests donât always directly correspond to the actually app function. The slice you made should do what you need
Wow I only know today that there are certain expression the sample data doesnât show up except you put in UX view. Itâs works. Thank you sooooo much. It works ! Very helpful
In fact I do more than that. I need 2 condition and it works
IF([PERSON DECLARED e-PROFILE EMAIL]=USEREMAIL(),
[PERSON DECLARED e-PROFILE EMAIL]=USEREMAIL(),
IN(USEREMAIL(),HOD[EMAIL CONTACT])
)
