Assuming would is required, the following 210 results were found.
-
few seconds. Analyzing the report through the ReportServer databases (internal auditing) only showed how long the SQL query would take to recover the data and present it in a report, which would average about 0.4 seconds. We're obviously not interested...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
label "Group Name" but API name "Grouping" in a list item column. The standard code you used to use even for REST API v2.0 would have been something like the following: // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
and pasted for each field, especially if they're doing the same thing for example displaying a preview in a notes field. We would rather only have to update the code for 1 workflow rather than 20 workflows every time we want to tweak the code. There are...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Program or a work based on the Program. To “propagate” a work means to do anything with it that, without permission, would make you directly or secondarily liable for infringement under applicable copyright law, except executing it on a computer or...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it would only understand the questions I have programmed it to and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
commits but unfortunately SSRS process both the Stored Procedure and the SELECT at the same time; this meant the report would say the process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). The...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
departments so for example: SELECT Date, Reservation, Contact, JobTitle, Dept FROM my_imaginary_table WHERE Contact='Joe' Would become SELECT Date, Reservation, Contact, JobTitle, CHAR(10) + Dept + CHAR(10) AS Dept FROM my_imaginary_table WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Say you want to get the value of the 1st element in the 1st form, which will be the Search for Keywords Input Box. The path would look like this (a collection of objects starts at 0): Code: document.forms[0].elements[0].value Now if you want to show the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
restores a missing webhook as well as the snippets when receiving the webhooks and storing them. Why? We found that Shopify would intermittently remove our webhooks. This would make the entire synchronization of the system go out of whack and some...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
It's a cop-out I know, but it beats the accounts staff having to enter the adjustment each time. The create invoice process would be treated the same. The below are all the various methods I tried to resolve this but the truth is that I do not have a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
and you are going to edit the _buildQuery() function, search the file for the following comment and text. As always, I would recommend you make a copy of the file before making the change just in case you need to revert the change: // We need to get a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
GPU to run more than 4 screens they said): Stopped my RTX 3060 (in PCIe 3.0 x16 Slot) from extending to multiple monitors (would only display 1 monitor or 2 mirrored monitors)... I solved this by taking the old GPU out and doing the steps listed in this...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
create a popup using the built-in popup of Zoho creator and gives you the freedom to style the notification as any modal would. 1. Create a page This will be the page containing the styled modal. I'm going to call it "Notify". Add the 2 parameters...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The scenario is that my client has quite a long...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client wanted that if the status had changed to something else, the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
v_Response = m_Choice.get("message").get("content"); } } } } else { // store in response text v_Response = "I don't know. Would you like me to Google: [" + v_Message + "](https://www.google.com/search?q=" + zoho.encryption.urlEncode(v_Message) + ")?"; }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
to them. Prepare for Go Live This migration script is not a silver bullet. It was created to take away the hours I know I would spend without it. This is not an upgrade; it is likely that your client may reconsider the template they are using or may...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
example (as I did). Why? The previous article meant that the Google map was your main activity and any other activity would be a sub-activity; returning to the map activity would restart the app as a menu item, it would need to launch a new intent... I...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *