Assuming used is required, the following 202 results were found.
-
how instead of a schedule, we can get Xero to tell ZohoCRM whenever an invoice or contact gets updated in Xero. Why? I used to use ZohoCRM schedules to pull when an invoice has been paid, but ZohoCRM schedules run only every 2 hours. You can set up 2...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging to the same school and updates some number fields on the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Recruit
- Language: *
-
herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the client script which will manage a subform. The module we are applying this client script to is a custom module called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets of code or screenshots below are made up. the Attachments.csv A data backup or export of the Attachments from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
// // you created an app that generated a client ID and a client secret and resulted in an access token // the client secret used when generating the access token should be entered here v_ClientSecret = "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"; // //...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
full template deluge/html/css code to put in a Zoho Creator page excluding the content (edited for Public display - Not the used final version): 0) { if(c_Quote.Name != null) { v_Firstname = c_Quote.Name.first_name; v_Lastname = c_Quote.Name.last_name;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
the key item to remember is that status is a mandatory field and it can either be "closed" or "open". If you have used ZohoCRM then this is obvious; if you haven't then it may be difficult to work this out. Put simply, "Closed" are events in the past...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Projects
- Language: *
-
completed then making the other optional. Why? My use-case is that the mobile or email field on a Zoho CRM contact record is used to authenticate the contact on a Wordpress portal. OTP or 2FA or MFA or OTC is in effect however; so a contact email OR...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
adapt to a module other than products. This function will also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
/ Widget Purpose: Given an account ID returns the credit safe details from CreditSafe Connect API. This function is used by a JS Widget. Inputs: string crmAPIRequest (webhook request from Zoho CRM) Outputs: - Date Created: 2025-08-15 (Ascent Business -...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
script specifying what triggers it (on load of the page when creating an invoice) then I'll just put the client script I used to map over all the applicable field values from the quote to the invoice within ZohoCRM. Set up the Client Script Login to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Bear this in mind during the installation process. Before we begin: I have to admit this took me a while. I had never used phpBB3 before nor were the instructions for applying the template and integrating it into Joomla that straightforward. It doesn't...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
items somewhere. How? The fix that I use involves a change to #__menu table in the database for that website. The example used here will be to create an about-us page but I already have two items using the alias "about" and "about-us": Login to the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
row 12 (so 2 rows will be returned). Sheet1$B11:AL Selects all data from column B, row 11 up to Column AL, row unspecified - used if I don't know how many rows there will be and if I want them all. NOTE: If you don't use column headings, F1 is the first...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to about once a week. In cases where there are no photos, SSRS displays a mini ugly red cross. On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
parameters. 4c. Add a dataset: the "Parameter Names" Under "Parameter Name" type the exact same name for the input variable used in your Oracle stored procedure (in my example: p_STUDENT_ADNAME). Under "Parameter Value" type the exact same name of your...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
in such a situation, here's the design mode of the report (apologies for the red censoring but this allows the images to be used in further demonstrations): Note that a footer exists (contains page number) because if printed, the page would end on a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
@myCounter = 0; SET @minStrLen = LEN(@p_SearchString) - 1; SET @maxStrLen = LEN(@p_SearchString) + 1; -- Populate Cursor1 (used to generate final SQL query to run) DECLARE Cursor1 CURSOR FOR SELECT 'SELECT ' + COLUMN_NAME + ' COLLATE...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB