Working on getting some very custom intigrations working again after an upgrade from 8 to 10. I originally had some code that added Appointements to projects that worked using the old VBScript toolset. Now I wanted to switch this over and just add it using straight SQL  (Microsoft SQL) When I do this I create the record in the APPOINTMENT table with an ID of the MAX Current ID +1 Then Create the record for that ID in the TRAVELTRANSACTIONLOG  for that ID. I make a record in the VISIBLEFOR table and again the TRAVELTRANSACTIONLOG table according to the documentation. Everything is displayed correctly but I can not add a new Appointent in the UI till I delete it. Assuming because it is trying to add it with the ID I just added. Is there another table controling the IDs I need to update so the system will grab the next avalaible? The Table COUNTERVALUE is completly empty. FYI Thank You, Jeff

Hi, I have created some TAGS for our tickets in SuperOffice (Service).  How can I delete old TAGS that are no longer needed?  How do I correct any errors in the TAGS that have been created for use? Is there a list somewhere that contains the TAGS that have been created? Thank you in advance.

Hi there,   I was wondering where exactly in the database I can find the link between a custom field (ProgId) and the corresponding column name in the database. For example if I have a custom field "SuperOffice:45" for the person entity, how do find out the column name in the UDPERSONSMALL table (e.g. "long06")? Unfortunately, none of the system tables (sys.columns, sys.tables etc) seem to map directly to the info found in the UDEFFIELD table and I was unable to locate any dedicated mapping table. We do regular bulk updates of custom fields and for now the only way to find out the right column name is by changing the value in the UI and checking for differences in the UD-tables.   Any hint would be greatly appreciated!

Hello! I am trying to figure out how to write handle batches in CRMScript for the online version of SuperOffice. I am trying to update a custom field on all contacts in my database using a few if-statements, but the database is too large for me to be able to run it all at once. The problem is that I want this code to run once a week, without me having to go into the script, tell the code to run the first 100 companies, then the next 100 companies and so on. Is there any way for me to be able to create a shedueled task each week, and tell the schedule to run one script many times, and for the database to somehow know how many times the script has run, and therefore how many companies it has completed before, and how many times it should run again? Below is some pseudocode for how I wish for it to run, but I don't know how to actually write the code or if it is even possible: SearchEngine se; se.AddField(Information about all companies); se.setLimit(100); se.criteria(currentCustomerId > lastHandeledId) //This is where the problem lies se.execute(); and then some code for changing the custom fields based on the information Is this possible at all, and how? Thank you in advance.

Hi (On Premise 8.3) I have a single user that has the alarms windows popping up all the time. If I remove the applointment from Outlook and wait for sync, the next appointment will do the same.  Has anyone seen this behaviour?

Some companies sell products that are assemblies.  In context assembly means that you have a main component, (always), and, that you on top of that, have several optional parts (some that are mutually exclusive - but set that aside for the moment). when entering products in the quote calculator itself, these parts have a price, and the combined assembly will then have a total price. However, the quote document should ideally have the main component as item one, ideally with a larger font, and the parts should be listed below in a separate section, possibly with a smaller font/colour, or some other type of visual to separate the parts from the main assembly,  and the price should be a total (turn key) price. Is the only way to do this, only possible using conditional formatting in word in the template itself, ie IF product type = MainComponent, then: etc or is there something in SO that can be used.  Are there some examples that anyone can share.?  

Hello, Does somebody know if it's possible to create an attendance schedule in de the service module? For example: We have only part-timers, so every week on the same day we need to manually change the status from "normal" to "away". And often they forget it, so the requests are also distributed to employees whom aren't available. The goal is to let the system automatically set the availability of the users per their working days.

this is a SuperOffice CRM OnSite 10.2 Release_OnSite_10.2.1_2023.01.31-02 I received a call after quite a long time since last that my contact wanted to add/edit some udefs on a sale card. Note below for current page in regular program:   However; switching to settings, there are no visiblle fields:     Thre are however visible fields as it concerns the company udef page:     suggestions welcome.

När man registrerar ny användare endera direkt i systemet eller lägger till via arkivering av ex mail vill vi få en fråga om att lägga till kontaktintresse på personen. Ofta missas detta idag och kontakter registreras utan intresse vilket gör efterarbete större med att uppdatera i efterhand. //Per-Erik Ålander/Christian Berner AB   --------------------------- When registering a new user either directly in the system or by adding them through email archiving, we want to prompt the user to add contact interests. This step is often overlooked today, resulting in contacts being registered without any specified interests, which increases the workload for subsequent updates. ---------------------------