AnsweredAssumed Answered

Script Parameter using Text

Question asked by rlamberts on Dec 13, 2013
Latest reply on Dec 13, 2013 by philmodjunk


Script Parameter using Text


     I am trying to set a script parameter using two text objects:

     a= "Insurance";b= "T24a_Insurance_Patients||Id_Patient|"

     Running the script:

     $$Filetype = Evaluate("Let([" & Get(ScriptParameter) & "];a)")

     $$Path = Evaluate("Let([" & Get(ScriptParameter) & "];b)")

     $$Filename = Let([PatientID = $$Path & "::ID_Patient"; FamilyID=$$Path &"::ID_Family"];

     Evaluate("PatientID") & "|" & Evaluate("FamilyID") & "|" & $$Filetype &  "|"  & 

     Year(Get(CurrentDate)) & "|" & 
     Left(MonthName(Get(CurrentDate));3) & "|" & 
     Day(Get(CurrentDate)) & ".PDF"
     This is to create a PDF from a database where different tables have the data needed.  The problem is that the script parameters require quotes.  I tried using single quotes embedded, but that doesn't seem to work.  I know there may be problems with the $$Filename portion of the script, but I can't even get values for the $$Path or $$FileType portions of the script.