Assuming format is required, the following 101 results were found.
-
reminder time","status":"error"} There was nothing wrong with the date time format here. Just that I was submitting a TRIGGER=DATE-TIME but without the correct additional parameters omitted/needed (in my case the UNTIL given a CRM/Atom date time...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to HTML4.0) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rs:Format=XML Where XML can be any of the following: HTML3.2, HTML4.0, MHTML, IMAGE, EXCEL, WORD, CSV, PDF, XML, defaults to HTML4.0 So...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS Internet Explorer. Parameters ntext NULL Parameters and the...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
&S is not workable. Instead I want to use &G[] and get both the code and the lookup value: -- What I have: no export format 5826 -- What I could have: export format set to get lookup value -- &GCOD_NAME.COD.SRS England -- What I want: export format to...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
I did it and what worked for me... Set the default values for your from and to date respectively: -- From Date (european format - dd/mm/yyyy) =CDate("01/" + cstr(month(today.now())) + "/" + cstr(year(today.now()))) -- To Date (european format -...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
, "System.Audio.ChannelCount" , "System.Audio.Compression" , "System.Audio.EncodingBitrate" , "System.Audio.Format" , "System.Audio.IsVariableBitRate" , "System.Audio.PeakValue" , "System.Audio.SampleRate" , "System.Audio.SampleSize" ,...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
} How? We're going to parse the created date and time parts as well as the timezone, add 10 minutes, re-assemble it in a format that CRM likes, and update the field: // // parse date into yyyy-MM-dd (using subString - reliable) v_LeadCreatedDate =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_LocalStartDate.setMinutes(v_LocalStartDate.getMinutes() - v_LocalStartDate.getTimezoneOffset()); // return in yyyy-mm-dd format (on save this will display as per the format on the CRM record) v_StartDateFormatted = v_LocalStartDate.toJSON().slice(0,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
"same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably not in the Zoho order, but that of the normal week (in other words, not alphabetical,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_WebhookLog.put("Event_Type","Inventory Update"); m_WebhookLog.put("Source","Shopify"); m_WebhookLog.put("Data_Format","JSON"); r_WebhookLog = zoho.crm.createRecord("Webhook_Payloads",m_WebhookLog); */ return {"crmAPIResponse":m_ResponseHeader}; The...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
for (ie. the SQL query creating the dataset does not use the parameters in its query). Problems: Given a date, the date format was reverting to US format as opposed to European Given a Campus as a text value, the SQL query was ignoring this completely...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
----------- ----------- ----------- ----------- -- 1 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014 Last Step: Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when you...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server
- Language: *
-
on this error. Bearing in mind that this is a general data type error and not just because I tried to convert a date in SQL format to a Month name. An error occurred during local report processing. An error has occurred during report processing. The...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
you specify a different image type (default is PNG) (eg. PNG to JPG -> means module has to re-download thumbnails into JPG format) - Fixed Bug: Weblink hit counter now works through Joomla! CMS - Date Uploaded: Wed, 13th Jul 2011 1.3.1 - Modified code...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
Const WM_INPUTLANGCHANGE = $0051 Const WM_TCARD = $0052 Const WM_HELP = $0053 Const WM_USERCHANGED = $0054 Const WM_NOTIFYFORMAT = $0055 Const WM_CONTEXTMENU = $007B Const WM_STYLECHANGING = $007C Const WM_STYLECHANGED = $007D Const WM_DISPLAYCHANGE =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
Comments (for Product Reviews/Feedback). --- Auto-increment minor/major version number / Assign naming convention. --- Date Format for files (mysql format please cos unix will take my server's one). --- Enable Captcha to download? --- Specify News...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
I'm going to call mine myZohoConnector, with the scope: ZohoCRM.settings.fields.READ Then check your URL is correct. The format for API v2 is: https://www.zohoapis.{eu or com}/crm/v2/settings/fields?module={module-name} You can then use the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
[ { "document_id": "12345678901234567", "file_name": "dummy.pdf", "file_type": "pdf", "file_size": 13264, "file_size_formatted": "13 KB" } ] } Additional: Attach to Zoho Books Sales Order and Attach to Zoho CRM Zoho Finance Sales Order If you want the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
A quick article to remind me of the regex to change a date from the format dd/MM/yyyy to yyyy-MM-dd. Why? Irrespective of server, organization or user settings, the date handling can vary. If we are getting a date from a CSV or other external source as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *