Knowledge base / Since 1999
Advanced
search
Practical notes on CRM development, automation, APIs and everyday IT.
Browse all notes17 results
Formatting a date in an MDX query
... M/yyyy") ... Mon 04/04/2011 European and Now: The above is about formatting dates and times but if you want a NOW timestamp in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved ...
CSS Ordered List 1, 1.1...1.10 Formatting and Alignment
What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to include their terms and conditions in quote/inv ...
Zoho CRM: Add and Update Products from Zoho Analytics Discrepancies
... ther table. The example below follows the revised function, with formatting cleaned up and the organisation, workspace, view and connection identifiers replaced for publication. string standalone.fn_Products_AnalyticsDiscrepancies() { /* ** ...
ZohoCRM: Import Attachments
... "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data backup or export of the Attachments from ZohoCR ...
Zoho Deluge: Push a value to a datetime field in CRM
... that goes something like: datatype: datetime How? Here are some formatting examples: Creator to CRM: v_CreatorTime = zoho.currenttime.toTime(); v_CrmTime = v_CreatorTime.toString("yyyy-MM-dd'T'HH:mm:ss") + v_CreatorTime.toString("Z").subSt ...
Zoho CRM & Zoho Books: Custom Related Lists Deluge
... e used 2 URL methods of linking to the Creator app and some data formatting that I tend to use regularly for my benefit later on when I simply copy & paste the below code templates. Zoho CRM // // initialize v_Index = 0; // // search in Cre ...
Windows OS: Alt Codes / Symbols / Special Characters
... ncoding will help but there will be times when you have lost the formatting and get weird question mark characters instead such as: . How? Ensure you are using the numbers on your numeric keypad and NOT the numbers at the top of your keybo ...
Zoho Deluge: Convert Map to HTML Table without a FOR loop
... "1"},{"First_Name":"Another","Last_Name":"Person","id":"2"} Some formatting and a lot of replaceAll: l_Keys = List(); l_Keys = v_Data.toMap().keys(); v_DataHtml = v_Data.replaceAll("},{", "}{", true); v_DataHtml = v_DataHtml.replaceAll(l_Ke ...
Windows 10: Shortcut Apps to Settings
... tings ms-settings:regionlanguage-jpnime Region ms-settings:regionformatting Language ms-settings:keyboard ms-settings:regionlanguage ms-settings:regionlanguage-bpmfime ms-settings:regionlanguage-cangjieime ms-settings:regionlanguage-chsime- ...
Excel - Check a column for values found in another column
... d end up with something like this (I have added some conditional formatting which colors the cells red or green for demonstration purposes): If you understand this article, you may have noticed that the range of words to find from Sheet2 in ...
Convert XML UTF-16 to JSON UTF-8 with PHP cURL
... basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header ...
Submit form as a server and not the client with cURL
... e($reply_array); echo $json_array; // field validation, variable formatting/transform rules, and user logging are also done via this script. Issues? - Internal Server Error - I can get this when the third-party API doesn't return expected X ...