Hi,
Can we set to show view based on selection of fields such as attached screenshot below. Based on the field type Input Product as : Measurable or Ready Product I want the below table view to change. For ok instance if the Input Product as Measurable Product then I want view showing only following columns : Item Name,Qty,Pricelist Rate,Amount.
I have created the views accordingly.but not sure where to add the expression. Have tried link to view but it didnโt work.
Hi @Boa_Casa
You can.
I suggest you create slices with the columns you wish to display.
letโs say:
Then, letโs get back to your main table columns.
You must have a column, that you decided to rename โwindow blindsโ and that probably was named first: โRelated windowBlindsโ.
For explanation purpose, letโs call it โrelated Childrenโ.
Assuming its expression is:
REF_ROWS("yourChildrenTable", "yourRelationIDColumn")
your workaround will use its expression.
Please add a virtual column, letโs name it โchildrenCriteria1โ, and its expression will be:
REF_ROWS("yourSliceWithColumnsDependingOnCriteria1", "yourRelationIDColumn")
another one, same idea:
REF_ROWS("yourSliceWithColumnsDependingOnCriteria2", "yourRelationIDColumn")
Finally, you will use a show_if condition on these โlist of refโ virtual columns.
And you will set your show_if expression for the column โchildrenCriteria1โ this way:
[columnCriteria]="criteria1"
the same for the โchildrenCriteria2โ column:
[columnCriteria]="criteria2"
and please remember to untick the โrelated Childrenโ show option.
This way, the columns of the expected slices that you set for your criteria will be displayed, and the other will be hidden
Let us know if that works for you !
User | Count |
---|---|
44 | |
29 | |
23 | |
20 | |
15 |