Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have field with year like
Year_New
2018
2019
2020
I need to select whenever i clicked on button i want max year select,so i added action in button Actions select Field and value is =Max(Year_New),
problem is, initially when i click on button max year selected, if i select 2018 in Year_New field then if i click on button then max year function is not performed.
Please give any solution on this,
Thanks in advance
@sunny_talwar please can you look into this
I got the solution
Max({1}Year_new)
Thank you
It's because you have used Max(Year) function. If you don't select anything it will return max year, if you select any year then it will consider that year as a max year, hence you need to exclude the selection of year field in trigger. Use max({1}Year)
Thanks for the input kush,
yes, you are right,
I got the idea and it works perfectly.