Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i'm trying to create a trigger for each tab which will autumatically select the current year and quarter. I have managed to do it for year but it is not working for Quarter.
For year my field would be PostingYear and the script for it is =Year(Today()) and for quarter the field would be PostingQuarter and the script i gave was =ceil(month(today())/3).
I have even tried =Max(PostingQuarter) but it failed.
Could someone help me on this. Thank you.
I think that your PostingQuarter is a string type, like 'Q1', 'Q2', ... right?
So:
- The ceil() function returns a numeric value so it will not match any value in your field.
- The max() function only returns numeric values. If the PostingQuarter field is a string type, the function will return null value.
Try these two options:
='Q' & ceil(month(today())/3)
= MaxString(PostingQuarter)
I think that your PostingQuarter is a string type, like 'Q1', 'Q2', ... right?
So:
- The ceil() function returns a numeric value so it will not match any value in your field.
- The max() function only returns numeric values. If the PostingQuarter field is a string type, the function will return null value.
Try these two options:
='Q' & ceil(month(today())/3)
= MaxString(PostingQuarter)
At first if did not work but later the request was changed from tab to document trigger and now it works just perfectly. Thank Fernando once again for saving my day.