Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Hope all re doing good....!
I need help on selecting the month which has recent data as a default selection while opening the application.
For Ex: i have year filed 2015 and in 2015 i have data till may only.
so when i opened my application by default it has to show may.
my month filed has month names not numbers.
i tried Max(month) in document triggers but its not working.
Please help on this.....
Thanks in advance...
Nani.
In script add ceil(month(date_field)) as month_no and after reload put max(month_no) in document triggers.
Thanks for your reply...
is there any way we can do it without modifing in script?
Hi Nani,
Try like this
Settings -> Document Properties -> Triggers -> Document Event Triggers-> On Open -> Add Actions-> Add -> Selection-> Select In Field ->
Field - Year
Search String - =Max(Year)
Again Add -> Selection-> Select In Field ->
Field - Month
Search String - =Max(Month)
Finally give OK -> OK -> OK
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
Thanks for responding.
I did the same as u mentioned above, Year is getting selected but not month.
when I tried Max(Month) in a test object its displaying "5" as result instead of May.
my month field contains month names not month numbers. so it is not getting selected.
Thanks,
Nani
For me it dosen't work otherwise.
Try date(max(ceil(date_field)),'MMM') in document triggers.
See the attached file.
Hi,
Try like this
=Text(Max(Month))
Regarsd,
Jagan.
By default it is showing Jan as Month.
But I have to display May.
Hi Jagan,
Tried, But no luck result is same 5.