Assuming instead is required, the following 103 results were found.
-
Purpose: Gets a SessionID to use the Auth'n'Auth (Authentication and Authorization) method instead of Oauth Date Created: 2021-09-22 (Joellipman.com - Joel Lipman) - Initial release More Info: - API Explorer Test Tool:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
this in one workflow because of the delay/lag in that searchRecords will not find the corresponding CRM sales order record. Instead, do the above workflow to attach the files to the Sales Order in Zoho Books, then in your Creator app, do the following...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
zoho-extension-toolkit If you get errors like “Missing write access to/usr/local/lib/node_modules” then type the following instead: sudo npm install –g zoho-extension-toolkit You should get prompted for the Mac/Admin password which you type in the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
screenshot: Following the API names in this example, the Deluge code 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(); //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to match the colors or style the next client wants. Why? The scenario is that my client has quite a long Creator form and instead of scrolling down while entering data, they would prefer if they could have tabs along the top to display each section....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, and display 12.5% instead of 12.50%. Well there might be a longer...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
the EU datacenter (zoho.eu) rather than the US datacenter (zoho.com). Update 2023: This solution has been superceded by instead directing the ZohoTicket Attachment trigger (internal webhook in ZohoDesk rather than on Ticket Edit) and creates a row in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
for an invoice in ZohoBooks to be sent. How? So the key here is that there were no contact persons on the customer record. Instead, when building the invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list)....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
on line 344 INSERT using JDatabaseQuery Note: for Joomla v3.x, use db->execute() instead of db->query() $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->insert($db->quoteName('#__my_users')) ->columns(array('name', 'username'))...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
This is a very quick note with the code to determine the English ordinal of a date (eg. "st" of "1st"). So in a date, instead of "Tuesday, 6 November 2018", I could want "Tuesday 6th of November 2018". Why? Well there's a long a way to do it (but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
field not found","status":"error"}: Happens if you put "JSONstring" instead of "data". Depending on the context of your code (ie. Books API v3=JSONString; CRM API v2=data), you will need to put either. Or your request is missing a field that is required...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
are 2 sets of documentation and the other is that the majority of the documentation doesn't refer to OAuth 2.0/json and instead uses the deprecated authtoken v1 and XML. How? The trick in this solution was more about the process and what that process...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
"UNKNOWN"); m_Sku_IDs.put(v_ProductSKU, r_ShopifyProduct.get("id")); // // getting the last ID from the Shopify sort instead of making Zoho sort a list v_LastID = r_ShopifyProduct.get("id"); } } } // // output info m_Sku_IDs; info m_Sku_IDs.size(); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of zoho.appuri, we are hardcoding the appowner and appname as this is used across Creator apps, ie. images are stored in a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Zoho Support as we could be blamed for any website / mail server issues not related to any of this setup / configuration. Instead, we prepare the following set of instructions for the client to give to their IT administrator. If the client registered...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
of "my_new_database" to the name of your new Joomla 3.0 database (don't change the table prefix for the new Joomla and instead do this as the next step). Rename any instance of "my_new_database.my_prefix_" to the name of your new Joomla 3.0 database...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
on the row (CR & LF). Fixes of interest: -- assuming This_Decimal="00000.00" or "123456.78" (Do NOT use "Replace" and instead "Add as new column") (DT_DECIMAL,2)TRIM(This_Decimal) -- assuming This_Numeric="0000000.0000" or "1234567.8901"...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
in a mySQL database where we use some JOIN statements. Why? It is never recommended to delete from multiple tables and instead to use the system you were given. Given a Relational Database Management System (RDBMS) where deleting some erroneous rows in...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
A Workaround: New line inserted before and after So this is where I am at the moment without VBCode and other suggestions. Instead I add a newline in front of and after the smallest data value (one that I know will never be two lines (or two words))...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
swipe left/right to reveal another screen of app icons. The same can be done to the desktop versions with open applications instead of just their icons. Why? MS Windows 10 has made a major step but when you close down your PC and log back in, all the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB