Hi, A customer has asked us to do some scripting, so that when a new company is added, it is added with a status of Unapproved (and possibly linked with SAINT show some kind of unapproved image on the company card).  When the rep has done all the due dilligence checks, and attaches all relevant documentation to the customer record supporting these checks, then have them click a menu item on the task menu to send an email to an "Approver" SuperOffice user to approve the company.  This email would have a hypelink to the company record, which the approver could open, and select another option on the task menu to approve or deny the company. All of the above I can do with CRM script.  But they want users whilst the company is in an unapproved state, to be able to raise quotes and opportunities, but not be able to select the "Place Order" button on the quote until the account has been approved. I have looked at the "Before saving quote" event with the test code below. EventData ev = getEventData(); ev.setBlockExecution(true); ev.setMessage("Test"); But this seems to only fire on the quote record when you click the "Close" button, not when you click the "Send" or "Place Order" buttons, which will also perform a record save, and even when running on the close button, does not run the setBlockExecution line of the code. I also thought that maybe I could set in the backend the status of the quote to require approval on save to get round the problem that way, but they still want the users to be able to send the quote and create new revisions of the quote, just not convert it into an order, which is not the way the built in quote approval system works. Is there any possible way around this, with the current scripting events available?  I know we could probably achieve this with a custom quote connector, but that does seem a bit of an overkill for what we need to do. Many thanks, Trevor

Hi, I am sending an email from SuperOffice via a CRM Script (pretty basic code below, but in my full code I am also using reply templates, and the parser variables). //Send Email Email email; email.setValue("to", toEmailAddress); email.setValue("subject", subject); email.setValue("bodyHtml", bodyHtml); email.send(); I now want to archive that email in SuperOffice, so that it looks like a standard SuperOffice archived email, I.E. I can see values in the email to field, email subject, and email body. At this point, I cannot even seem to set the email body, with the code I have below not working (based on the AI results produced from SuperOffice Docs). NSDocumentAgent agent; NSDocumentEntity doc = agent.CreateDefaultDocumentEntity(); // set properties (name, contact, etc.) on doc //Set Document Template NSDocumentTemplate docTmpl; docTmpl.SetDocumentTemplateId(154); doc.SetDocumentTemplate(docTmpl); //Set Document Heading doc.SetHeader("Demo"); //Set Document Filename doc.SetName("POC " + getCurrentDateTime().toString("YY2MM2DD2HH24MI2SS2") + ".somail"); //Save Document doc = agent.SaveDocumentEntity(doc); NSStream stream; stream.SetStream(bodyHtml.toByteArray()); doc = agent.SetDocumentStream(doc, stream, true); The code does not error when I run it, but I do then get an error when trying to open the archived email that the CRMScript has created.  I haven't even got to the point of looking to set the email to address and subject. Is it possible to archive an email via CRMScript that was created using the Email agent? Many thanks, Trevor  

Hi,   I have generated my SystemToken, is there Code sample or Docus, how could i authenticate my .net-SO Api via SystemToken for SystemUser? Thanks!

hi, we want to auto-fill in Tickets the extra-field "Cost Center" (in Germn "Kostenstelle") depending on its Ticket Person (in German "Ansprechpartner"), because each person in our Company belongs to a certain Cost Center: This Association is stored in our Active Directoary. But in crm scripts there is no Connection to our AD. My Idee will be, seach in all Tickets, what is the most Cost Center for that Person, this will be auto. filled in new Ticket. In SO Database, i reach that with SQL-Statement for my Person, important is here group by in SQL: Now i want to convert it in SearchEngine in crm scripts,   but it posts me Runtime Error  by Using grouping.   Thanks!

Is it possible to pretty format a json string: Map m = Map (data); printLine(m.toJson()); Outputs: { "First": "Martin", "Last": "Andersen"} I would like to have it like this: {   "First": "Martin",   "Last": "Andersen" }   Regards Martin

Hi, I am trying to create a webhook via a CRMScript based on changes made to project members. It looks like it should be possible, https://docs.superoffice.com/en/automation/webhook/reference/project-member-events.html , but nothing fires when I add/edit or delete a project member. Here is the code registering the webhook. #setLanguageLevel 4; String targetCrmScript = "ProjectMemberWebHook"; String[] events = String("projectmember.created,projectmember.changed,projectmember.deleted").split(","); NSWebhookAgent webhookAgent; NSWebhook webhook = webhookAgent.CreateDefaultWebhook(); //NSWebhook webhook = webhookAgent.GetWebhook(1); webhook.SetEvents(events); webhook.SetName("Project Members Web Hook Handler"); webhook.SetType("crmscript"); webhook.SetTargetUrl(targetCrmScript); webhook.SetErrorsEmail("trevor.sharp@synergytechnology.co.uk"); webhook.SetState(1); // Set it as active! webhook = webhookAgent.SaveWebhook(webhook); printLine("Webhook succeeded with ID: " + webhook.GetWebhookId().toString()); And here is the webhook. #setLanguageLevel 4; String variablesAvailable = ""; Map m = getVariables(); while (!m.eof()) { variablesAvailable = variablesAvailable + m.getKey().stripLeadingAndTrailing(" ") + " - " + m.getVal().stripLeadingAndTrailing(" ") + "<BR>"; //Move To Next Record m.next(); } log(variablesAvailable); It writes ok to the log when I enable the webhook, but nothing is added to the log when I make changes to the Project Member, and I cannot get any traces from this script. Also with the new screen for creating the webhooks via the GUI, this does not reference the Project Members table, which makes me wonder if it is not supported, but then why have a whole help page on project member events if it is not supported. Does anyone know whether the project members web hooks should fire or not, have I missed something in my code, or am I trying to achieve the impossible. Many thanks, Trevor