Hello,
Currently I use a Valid If expression to produce a picker like:
SELECT(Reference[TIME TRACKING Time Type],TRUE)
Can this somehow be based on what slice the view is in?
Or better yet, can I assign an Initial Value of a column based on what slice the entry is made in?
For instance,
The main table is Jobs_App View.
Slice #1 is for T&M entries
Slice #2 is for Time Tracking Entries
Both Slices are of Jobs_App View.
Is there way to have an Initial Value of โT&M Entryโ in a column based on the entry being entered while in Slice #1โs UX, meanwhile, set an Initial Value of โTime Tracking Entryโ in the same column (different row) based on an entry being entered while in Slice #2โs UX?
I donโt think there is, but thought I would ask.
Thanks in advance,
Joe
@Joe_Seiler
You may want to read these:
Interesting, thanks.
Iโll let you know how it goes
I tried this, but I must be missing something
Initial Value:
IFS(CONTEXT(โViewโ)=(โT&M Entriesโ), โT&Mโ)
It just gives me nothing in the column
Is T&M Entries
the exact name of the form view?
Yes. The form view is a slice, but it is definitely โT&M Entriesโ (just did a copy and paste)
Is it because itโs a deck view, and not a form view?
Yeah, so I changed it to Form View and it works. Thanks for pointing that out
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |