topic Re: Issue with default selection on Month using Bookmark in App Development

Issue with default selection on Month using Bookmark

punitpopli — Fri, 27 Aug 2021 09:21:28 GMT

Hi Experts,

I am applying a dynamic selection on a Month Field using expression and bookmark

Exp that have used on the month filed to select latest month is -

Num(Month(Today())))

and on the filed I have used "=Month =Num(Month(Today()))"

This is setting up the latest month every time user access the application. Everything fine till here

Their are some column which will be displayed on the basis of month selection and when the app is open as have used calculated exp to select latest month the expressions are not getting enabled. As in GetfieldSelection of Month it returns the expression and not the value

Any help on this will be appreciated!

thanks in advance

Re: Issue with default selection on Month using Bookmark

stevejoyce — Thu, 26 Aug 2021 18:13:12 GMT

Yea that does seem odd it does that.

Can you just reuse the formula in your expression enable condition Num(Month(Today())) = whateveryouwant.

It looks like this maybe resolve the formula with some extra stuff so maybe you can do...

subfield('$(=getfieldselections(Month))', '=', 3)

Re: Issue with default selection on Month using Bookmark

punitpopli — Tue, 07 Sep 2021 15:26:44 GMT

hi @stevejoyce

I have derived the expression the same way, details on the same in below -

vMonthDefault = SubField(SubField(GetFieldSelections(Month),'h=',2),'"',1)

Using this step I need to extract the exact formula to select latest month i.e. Num(Month(today()))

=IF(len(GetFieldSelections(Month,',',12)) <=26
,Chr(39) & GetFieldSelections(Month,Chr(39)&','&Chr(39),12) & Chr(39),Chr(39)&'$(=$(vMonthDefault))'&Chr(39) )

then using above formula I need to run extract the month value when its the default selection for rest of the timr it should just get the user selected months separated by a comma