Assuming have is required, the following 415 results were found.
-
2", cp."Campaign 3" FROM "Contacts" c LEFT JOIN "Contacts vs Campaigns Pivot" cp ON cp."Contact Id"=c."Id" Caveat(s) You may have noted a few caveats with this solution: This query needs each campaign name specified to see the results per contact...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
up a nightly schedule which checks on all the shipments from a certain date and updates the shipment status for items that have been delivered: Login to ZohoInventory > Setup (Cog Icon) > Automation > Schedules > New Schedule > I'm calling mine Nightly...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
respective records in Zoho Inventory. We're using a ZohoCRM webhook, because CRM webhooks run more reliably then the ones we have found in ZohoBooks and other Zoho Apps. Prerequisites: Setup a connection called "joel_books" that has the necessary scopes...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in to their domain registrar's website and need to be assisted, perhaps via a remote session, on setting these up. If they have someone or a company which manages their domain, then they can give the following instructions to these instead. ZohoCRM: Get...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
the "Lead Conversion Mapping" page. How? This is a bit of a hack and most likely not recommended... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Additional: I'm just adding a little extra based on the further feedback, if we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
of print. Things can change though and if the function is changed to remove every instance of the "distinct" list, then I'll have to come up with a different solution. Maybe Zoho could introduce a removeFirst() if they change removeAll().. The number of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. void fn_Joel_Test() { /*** - tried with getUrl() but this doesn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer immediately) and then...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
changed the Top Level Domain (or Zoho DataCenter) from EU to COM as I was using this for a client on the US datacenter. I have a connection called "zbooks" and the v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple instances of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
will show you how to use this API having a few email addresses as the recipients: A sample code snippet: For the below, I have a connection to ZohoBooks from ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
write some Zoho Deluge code. Note that requesting an increase of the limit or an upgrade to the subscription will likely to have to be asked directly to Zoho rather than using the online subscription plan management section. Statement Execution Limit is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(!isNull(r_UploadResponse.get("data"))) { // looping but only have 1 upload so getting permalink for this upload for each m_ThisData in r_UploadResponse.get("data") { if(!isNull(m_ThisData.get("attributes"))) {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click on one to select it. When are colors used? Well in this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
as the response cannot be configured in ZohoBooks like we need to in this solution; namely the webhook response needs to have a header and a body. The 2nd caveat is a concern around security. It is difficult to guess a customer's Zoho ID; some might say...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
nor ID were necessary in the end, I can use shortcode for getting the tag. Note that on a fresh CRM instance where no tags have been used previously, I would use the code above to maintain tag colors. Here's the shortened version where the system...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
call. Once the new developer's application is subscribed to eBay marketplace account deletion/closure notifications or they have successfully opted out of the notifications, the keyset/App ID is activated, and they can begin making API calls." How?...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
but for a third-party app, such as a Zoho Creator app, to connect to the data within Shopify. Why? At time of print, we have woken up to the news that including a username and password, or a client and secret in the endpoint of a URL will no longer be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
created. Maps values from the related quote if loaded from somewhere other than converting quote to invoice.". Note that I have a workflow that when saved, uses an auto-number field, pads it with zeros, and prefixes it with "INV-" overwriting the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if(m_ThisInvoice.get("Status") == "PAID") { v_InvoiceTotal = m_ThisInvoice.get("Total"); v_PaidTotal = 0.0; // we have a partially paid status in crm so let's check those payments for each m_XeroPayment in m_ThisInvoice.get("Payments") {...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF