- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Trigger is not working when i link 2 tables
Hi,
I am facing issues with trigger which is not functioning as per my requirement.
I have below 2 tables and linked with "Name" and applied trigger on "Product Region".
When is select "Product Region" trigger is working, but when i deselect the same the trigger is not working.
Table1:
LOAD * Inline
[
Name, Product, Region
Rob, Mobile, AMS
Michale, Non-Mobile, APJ
Jim, Non-Mobile, EMEA
];
Table2:
load * Inline
[
Name, Product Type, Prod Region
Rob, Mobile, AMS
Michale, Non-Mobile, APJ
Jim,Mobile, EMEA
Rob, Non-Mobile, WW
] ;
I have to link the above 2 tables with "Name" and expecting trigger to be work. Please find the attached qvw.
Can anyone help me on this.
!
- Tags:
- document triggers
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You need to also define trigger for the onChange event.
Have a look at the application. When you deselect the Product Region, it will deselect the Region field.
Regards,
Kaushik Solanki
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
As Kaushik said,
define the trigger on On change > action clear field(field name )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Solanki,
Sorry, I haven't explained my issue correctly. Please find the attachment.
I have 2 triggers here. When is selects 'EMEA' in Prod_region its working but upon that selection if i select "non-mobile" in "product type" it's clearing the selection in "region" filed.
My desired output is
I selects "EMEA" in Prod_Region and then i selects "Non-Mobile" in "Product_Type"
it should select "EMEA" in "Region" and "Non-Mobile" in Proudct(Table1).
It seems tricky, can you please help me on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
see the attached