Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, need some assistance in displaying dynamic titles on selections made, for this I wrote =getcurrentselections(),
but the problem is I'm loading one date field in the format of 42060.... where i converted it to Date(PurgeChar([Field Name],'[]'),'DD-MMM')) but when selected this particular list box its showing up as number not in the date format,...how to write a condition to show up two or three fields in title....
Regards
krishna
Use =GetFieldSelection(FIELD,';')&' '&GetFieldSelection(ANOTHERFIELD,';')
Hi Krishna,
Try something like below:
=Date(Date,'MM-DD-YYYY') &chr(32)&if(GetSelectedCount(Plant)>0,'- '&GetFieldSelections(Plant))
Thanks,
AS
Thanks Amit, I made it to appear for date thing, but how about other selection in list box2.
I would like to add more in detail here ,suppose i have list box1, list box2. I want them to get displayed both on title..side by side .in the image i want another field name to be displayed next to the date.
Regards
Krishna
Use =GetFieldSelection(FIELD,';')&' '&GetFieldSelection(ANOTHERFIELD,';')
Try like below:
=Date(Date,'MM-DD-YYYY') &chr(32)&if(GetSelectedCount(Plant)>0)&' '&if(GetSelectedCount(Another_Field )>0)
You just need to use &' '& between two conditions.
Thanks,
AS