Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I have an issue searching in a table contains a trigger select in field:
I have a straight table with many columns as dimensions and expressions. One dimension contains a trigger, when the user select it, another sheet is activated. In the same table expressions are with searchable option.
When I try to search in field and press enter, the trigger is activated and I move the next sheet while I didn't select the field with trigger !
Something else strange, when I clear selections I move also to the next page !
I attach an exemple also.
Thank you
Hello,
i think it is working as expected. The problem is how you select the values.
1) While clicking on a specific amount in your table you will automatically select the dimension value -> and activate the trigger
2) same for your search field in Amount column
3) Your clear selection thing only activates the trigger if trigger field was selected before (like mentionied in 1 & 2)
Let me show you:
sample1:
click the yellow point in screenshot
this will select Type and Trigger Field (cause this are your dimensions)
sample2:
select >50 will select only your dimensions too.
Solution:
Create listboxes for each field. Or one multibox and test this.
I think you only want the listbox for amount.
Thank you for your answer, but I need to show values in table (because I don't have only 3 columns) and I need the trigger to be activated only when the user select in trigger column.
Thanks
Rek
no problem. Create your table with all columns you need. Then create a listbox with Amount. You can do the same input there. But this will only select Amount field. This way you dont activate the trigger.
Not sure if this is a possibility, but may be create another field from Trigger_field like this
LOAD *,
Trigger_field as Non_Trigger_Field;
LOAD * INLINE [
Trigger_field, Type, Amount
1, A, 50
2, B, 100
3, C, 150
4, D, 70
5, E, 20
];
Now you can use this field in the table where you plan to search the expression and may be have another list box with the other field for selection which triggers you to another tab.