When I do two functions simultaneously, the data blank appears. Inside the Virtual Column.
SELECT(CAMPUS SCAN SHEET[PAIR TYPES],[PAIR TYPES]= used pair)+SELECT(CAMPUS SCAN SHEET[PAIR TYPES],[PAIR TYPES]= used single pair)
Note: This expression could impact performance.
(The list of values of column 'PAIR TYPES'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'PAIR TYPES') is equal to ("used pair")) + The list of values of column 'PAIR TYPES'
....from rows of table 'CAMPUS SCAN SHEET'
....where this condition is true: ((The value of column 'PAIR TYPES') is equal to ("used single pair"))
Hello @Sayad , can you try this expression?
SELECT(CAMPUS SCAN SHEET[PAIR TYPES],OR([PAIR TYPES]="used pair",[PAIR TYPES]="used single pair"))
I want it to be visible only in detail view. How do I hide from form view?
This expression is working but one issue why showing this.
I take it the expression worked? you can use this expression on that virtual column show_if()
CONTEXT("View")="Your form view name"
That's just how lists show in table views, you might wish to further expand on your show_if() expression or simply remove it from that table view.
Virtual column name is not showing in View column. Then how to remove .
Are you sure you're looking at the correct view configuration? from the screenshot I'm not sure if it is a table or an inline view.
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |