initial value for slice column

[Phong_Lam1]

Hi all,  I have a master note table as below

From that master note table I create 3 slices, Customer note slice, member note slice and log note slice,  I ref_rows those 3 slices with table customer, member and log. to add note (inline view note slice)..

How this column Note category automatedly filled according to It's slice when I add new note ? For example If I add note on Log , then note category should be automatically filled "Log", the same with customer and member there should be "customer" and "member". 

FYI: ID member (note editor) should always have value, I use useremail() and lookup fomula to member table to find the Id member

I tried with this expression on [Note category] but not work, It's always return "customer"

ifs(
count(Master Note[ID Customer])>0,"Customer",
count(Master Note[ID Log])>0,"Log",
and(count(Master Note[ID Members])>0,
count(Master Note[ID Customer])=0,
count(Master Note[ID Log])=0
),
"Member"
)

Thanks

[WillowMobileSys · Accepted solution]

---

@Phong_Lam1 wrote:

How this column Note category automatedly filled according to It's slice when I add new note ? For example If I add note on Log , then note category should be automatically filled "Log", the same with customer and member there should be "customer" and "member". 

---

Since each Slice requires its own view, you use the CONTEXT() function to identify which view is being used when entering the note.  something like this (note that the views names are just place holders...you will need to use your actual app view names):

IFS(
    CONTEXT("View") = "Customer Slice View Name", "Customer",
    CONTEXT("View") = "Member Slice View Name", "Member",
    TRUE, "Log"
)

[Phong_Lam1]

Thanks @WillowMobileSys , that's working