Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a trigger for a single tab in my app that when one month is selected, the prior 3 months are automatically selected also. Is there a way to do this? My months are labeled as Jan, Feb, Mar, etc.
Thanks.
Consider that you have InvoiceMonth Field... If you have month field having different than InvoiceField, change name accordingly.
Create an Alterante State
Go to Document Properties - General Tab - Alternate States - Add - A
Now go to Document Properties - Triggers
Select InvoiceMonth from Field Event Triggers
On Select
Add Actions
Add
Selection - Select In Field
Field
InvoiceMonth
Search String
='(' &
Month(MakeDate(Year(Today()), Max(InvoiceMonth)-2)) & '|' & Month(MakeDate(Year(Today()), Max(InvoiceMonth)-1)) & '|' & Month(MakeDate(Year(Today()), Max(InvoiceMonth))) &
')'
Make sure you select A in Alternate State in Action Tab.
Now Create InvoiceMonth List box and assign Alternate State A for it.
Try to select any month.
Let me know if you are not getting desired output.
Thank you, but it is not working. I think it is because my months list box is static throughout each tab so when a new selection is made it flows throughout. I need a single tab to show all 4 months when 1 month is selected.