I am currently loading various qvds based on their date. the user can type into an input box the values which they wish to load. I want to change this to just selecting from a listbox instead of having to manually type the dates in?
I tried putting the variable as concat(Date, ',') but the function cannot be used in the script.
Has anyone ideas?
Just to clarify - I want to enable the user to select in a list box which dates they want to reload the data for?
Don't write your expression in variable "vABC" just leave it empty.
Consider your LoadedDate field is "CreatedDate"
Go to Document properties --> Triggers --> FieldEventTriggers
And selecte the field "CreatedDate" and Click On Select Add Action --> External --> Set Variable --> Variable = vABC and Value = if(getselectedcount(ABC)>0, concat(getfieldselections(ABC), ','), getfieldselections(ABC)).
The issue for this is that when the variable is created the script does not recognise the getfieldselections function? this may work on a text box on the front end but when coming to a load it simply gives tries to load from:
abc.getfieldselections(fieldname).qvd which obviously does not exist!