Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to open the document on access point with max month of data get selected by default on opening document first time.
I dont want to do this from On open document triggers.That is breaking my other functionality.Is there any other way to make default selection max of month dynamic on open without triggers?Any workaround is helpful.
Regards,
Mayank
You can do it with OnPostReload.
Hi Neelam,
How it can be done can you explain this.Is this without triggers?
Regards,
Mayank
It is with trigger. I thought you don't want to do it with OnOpen so OnPostReload is another option.
How is it breaking your other functionality?
Hi Wallo,
Thanks for reply.This is breaking my document chaining navigation part.Sheet navigation is not working properly.
Let me know if you required any further details.
Regards,
Mayank
A little more info would help. I don't know how an OnOpen trigger of select in field would hurt.
But if it does have you tried simply saving it with a search criteria something like
=max(MonthDate)
on your month date field?
I know expressions work as search criteria and I think this 'should' work for your situation, but I haven't tested it in your exact scenario.
Actually you would need something with Rank.
=Rank(MonthDate)=1
Actually you would need something with Rank.
=Rank(MonthDate)=1
You can pass parameters with URL but not sure how to do it dynamically using Max(month) etc..