Trigger issue

[Anonymous]

Hi guys,

I have calendar and field Campaign.

When I select any Campaign from field Campaign, my calendar finds first and last dates for selected Campaign and combine dates

oDate

='>=' &date(vStart,'DD/MMM/YYYY') & '<=' &date(vEnd,'DD/MMM/YYYY')

But when I deselect Campaign, oDate keeps selected period.

How to update oDate for whole period?

Please see my attached file.

Thanks,

[Anonymous]

Any ideas?

[shawn-qv]

Do you need to use triggers?

I'm guessing you can probably achieve what you want without having to set triggers, which can be much cleaner and simpler to manage.

But if you insist on using triggers, then you can add another set of actions to the OnChange field event for Campaign.

S.

[jagan]

Hi,

Please find attached file for solution. I removed variable triggers and changed variables.

Regards,

Jagan.

[Anonymous]

Hi Jogan,

Thanks for your help.

The calendar stop working. When I select dates in calendar, it didn't combine in selected period.

But the main problem is deselect Campaign should automatically find the fist record and combine dates in oDate field.

Maybe for Trigger on Campaign wrong set up variables vStart and vEnd?!

The Campaign variable and calendar should works together.

If I select period in calendar, should work vStart and vEnd variables.

If I select Campaign, the calendar finds the first and the last days and use this period.

But when I deselect the Campaign, the calendar should show whole period and use whole period.

vStart and vEnd  combine period in oDate field.

Thanks,