Assuming case is required, the following 143 results were found.
-
display foreign characters on their website without the funny question marks in diamond symbols and how I solved it in my case. Why? My company has started using international country and region names which include foreign characters. When we copy and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
and CAP as the entity. (If your change spans different entities, just use the parent/root entity, usually STU) XML is case sensitive so bear this in mind, tick the "Valid for Export" and decide whether blanks are included in the output or not. Select...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
Row Seperator This follows on from my T-SQL Record Separator article. If you are using SQL Server Reporting Services (in my case version 2008 R2), then yes, you won't need to use the database level solution and can follow these quick steps: Right-click...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
In this case, I want to display the current month with today highlighted. As I was trying to get my head round writing this in a program using the qHTM.dll (to include HTML in an autohotkey GUI), the calendar will be in a HTML-autohotkey mixed code....
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Forum Ruleshttps://joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165
number if necessary. The only exeption to this rule is if your edit timer (24 hours) for the post has run out, in which case you may double post if you have something important to add. Spamming is also not allowed, and is defined as a post that has no...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
of disk space). Output Thumbnail File Type: can be BMP, GIF, JPG, PNG or TIF Time between page load and picture taken: in case your internet connection is slow, or your average website takes longer to load or not. The fastest it will go is 15 seconds...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Create Connection » Zoho Ensure you enable/tick "ZohoCreator/creatorapi". Note the name that you call it (displayed in mixed case but will be used in its lowercase form) Method #1: Using UpdateRecords() function with Connection Link: The syntax for this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
as I have other templates that work fine. How? The error is one of those that you wouldn't consider relevant in this case, after all, all styling was removed... Here are two screenshots to demonstrate the issue: Screenshot #1: This screenshot is of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
your new Widget to the page: Don't forget to click on the page settings (cog in the top right) and add a parameter, in this case "name": Great! Now access this application and preview your masterpiece! The following screenshot shows what happens when I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I am going to prefix it with "l_" (for list) and the plural of what kind of records I am sending as parameters (in this case "Quotes"). As the actual parameter value, select the form which is the singular of the records that you are sending (in my...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I'll get an array back of 2 records and I'll be looking for the 2 lookup fields (contains an ID and name) per record. In my case: .. "Requires_Approval_Users":{ "name":"Joel Lipman", "id":"12345600000987654" },... AND .. "userlookup221_2":{...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
of this article for you which we tried to use but only helped us out about half-way, the rest we guessed on our own: Our use case, is that we are developing a Zoho Creator app that will help staff log time and then push the creator record to Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
to send would be something like the following instead (reminder: instead of Product_Details, post to the API name in this case "Quoted_Items"): // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = "123456789012345678"; // //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= r_Event.get("Event_Time"); v_ThisEventNote = r_Event.get("Event_Details"); // // now lets add double-quotes for Excel in case the event contains commas v_NewCSVline = "\"" + v_ThisEventTime.toString("yyyy-MM-dd HH:mm:ss") + "\",\"" + v_ThisEventNote +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
article shows you how to customize the search results or response from using zoho.creator.getRecordById(). Why? My use case scenario is that I was trying to build a related list in Zoho CRM with a view on to related records in Zoho Creator. For some...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
+ v_QuoteRef + ""; // don't forget to escape quote name with CDATA in case of XML banned characters v_RelatedListXML = v_RelatedListXML + ""; v_RelatedListXML = v_RelatedListXML + "" + v_DateTill + ""; v_RelatedListXML = v_RelatedListXML + "" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
within a for loop or in other words 5 pages (as each page is limited to 200) and 1000 records is the sweet spot in which case the loading bar disappears but the function usually completes all 1000 every 5-10 minutes: // init v_CountFound = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
I've added to this the handling of new lines or carriage returns in between a pair of double-quotes. Why? Our use case is that we were trying to loop through rows of a CSV file which contained addresses which in turn contained commas. Saving this as a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *