I created “Submit” button with the following formula: after i click submit, the error msg prompt:“Invalid or non-existent document”. if i take out [IncludeDoclink] ,the error disappear… anybody can help me with this??
many thanks!
ToList:=@Unique(@DbColumn(“”:“NoCache”;“”:“”; “AdminStaff”;1));
Requestor :=@Name([CN];RequestedBy);
FIELD PStatus :=“Submitted”;
@If(Requestedby=“” ;
@Return(@Prompt([OK];“Error”;“Please fill in the requestor name”));
PhoneNumber=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the Tel Ext”));
Approver=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the Approver Name”));
StartDate=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the Date of Meeting”));
StartTime=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the StartTime”));
EndTime=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the EndTime”));
Purpose=“” ;@Return(@Prompt([OK];“Error”;“Please fill in the Title of Meeting”));
@PostedCommand([FileSave]):
@MailSend(ToList;RequestedBy:Approver;“”;“External Room Booking - Request for Boardroom Booking”;“”;
“Hi,”+@NewLine+@NewLine+“The following request has been submitted for booking a restricted resource.”+@NewLine+@NewLine +
“Requestor” +@Char(9)+ ": "+Requestor+@NewLine+
“Resource”+@Char(9)+ ": "+Resource+@NewLine+
“Date”+@Char(9)+@Char(9)+": "+@Text(StartDate) +@NewLine+
“Time”+@Char(9) +@Char(9)+ ": “+@Text(@Time(StartTime)) +” to "+@Text(@Time(EndTime))+@NewLine+
“Title of Meeting”+@Char(9)+": "+Purpose +@NewLine+@NewLine+“Click here to view details -->”; [IncludeDoclink] ):
@Prompt([OK];“Booking Request”;“Your request has been submitted to Admin staff”):
@PostedCommand([FileCloseWindow]))