Assuming instead is required, the following 103 results were found.
-
Additional Here are some other queries that are required for the above but you may want to use the out-of-the-box modules instead: Sometimes, a salesperson or user might be generating an invoice on behalf of the account manager (person who manages the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5 for each file with the filename appended. Because of MS Windows 11 limitations (any MS...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Lookup field isn't being populated: Find the lookup field suffixed with _ID and send the correct record ID to this field instead. The lookup field (name only) can be omitted from the request.
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
I only resolved this by not using "endCursor" in my GraphQL and instead looped through the nodes to get the last cursor. Not sure if this meant any data was missing. Perhaps by forcing the sort criteria to be by order of cursor alphabetically; but we...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
which gets autopopulated with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the same code worked great on one Zoho CRM, another client's ZohoCRM was not accepting "\n" as a new line character and instead would render/display it as "\n"... What I have Me,Myself,I\na,b,c What I want Me,Myself,I a,b,c How? So in this article I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
So annoyingly, the variable broadcast was unreliable in storing message conversations despite it's purpose being ideal. Instead, let's use a CRM function to store the conversation between ChatGPT and the CRM User. This way, we can also ensure that the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
m_InvoiceDetails.put("payment_terms",-3); // adding label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
"code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the quick answer is to build a nested map in your request instead of using the Creator/JavaScript period/dot character... Some might suggest it's an authorization error but if you do a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
I thought having a file and then using ZohoCreator .content would be a good way to store data exceeding 64Kb but instead I found using additional multi-line fields performance-wise was better: // // bigger than 64kb c_Check.Cached_HTML = v_HtmlToCache;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
improvements right out of the gate. Then the client comes back and says things like "can we add this?", "can it say this instead?", "can it be in a bigger font?"... without pushing back too much, it can end up looking like those old websites with HTML...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
set it to only remind on business days excluding Saturdays and Sundays but you could modify the above to simply AddDay(n) instead of AddBusinessDay(n) if your guys operate over the weekends. The task will be on the lead record as soon as it is created...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
connection:"zcrm" ]; info r_QuoteDetails; } Creating a record Pretty much the same as above but instead of the method/type PUT you will use POST with an endpoint of https://www.zohoapis.com/crm/v7/Quotes. Showing Off Just a note here for myself where...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
noticed that if the accepted content on an invokeURL in ZohoCreator is not JSON, then isNull() preceeding will not work. Instead you will need to do something like the following: m_Header = Map(); m_Header.put("Authorization","Bearer ");...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
This was because I was trying to include the parameter addIfNotExist and I was using POST as the method in the invokeURL instead of PUT. INVALID_UPDATE_CRITERIA_CONFIGURATION","data":{"errorCode":8130,"errorMessage":"Invalid criteria configuration....
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
not using the CRM integration and this is a public Survey with an email field on it, then you may need the following query instead: SELECT concat('REF-', left_pad(to_integer(substring(r2."ID", 8)), 6, '0')) AS "Attempt ID", s."Title" AS "Survey",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use the Items module in Xero and instead puts the product name in the description field How? Because my head is a little fried, I'm putting the two functions I used...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to Open Banking connections handled by Plaid. The “via Plaid” or “via Yodlee” tags no longer appear in the UK interface; instead, you’ll see the bank listed as “& Country (United Kingdom).” Deleting accounts: Deleting a bank account can affect balances...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
to recieve mail on user@domain.com, you must *not* set your hostname to domain.com. We recommend using server.domain.com instead. You must make sure that you add the A record for server.domain.com so that it resolves. 2) The hostname must be in the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install JComments on your upgraded website (at time of print: Jcomments v2.3.0 on Joomla v2.5.4) Copy...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *