Assuming will is required, the following 358 results were found.
-
'[^a-zA-Z0-9]') -- returns all rows where the student surname contains non-alphanumeric characters -- eg. O'Brien will be returned SELECT * FROM STUDENTS WHERE REGEXP_LIKE(S_SURNAME, '[^a-zA-Z0-9\'']') -- returns all rows where the student surname...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
motherboard to the 3rd Dell monitor (my acers accept DVI not HDMI). This is the key connection for the 5th monitor and it will use my onboard graphics. My graphics card (RTX 3060) can only support up to 4 monitors no matter what configuration of ports I...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
you to provide certain information by which you can be identified when using this website, then you can be assured that it will only be used in accordance with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: en-GB
-
documentation and changelog under each project. This means you only update one documentation/changelog page which will be a Joomla! article. The Joomla! article will support whatever content based on however your Joomla! website is configured. My day...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
finalized version (following updates) making it as generic as I can in order to apply it to any client. How? Firstly, you will need to browse to https://accounts.zoho.eu/developerconsole and register your new app (or the one you will have completed once...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: en-GB
-
So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click of a link on a page. Why? Because alert (alert task) can...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
article to make it simpler for new developers to follow and learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably manage it in Zoho Books leaving it to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the Shipping Address... But let's say I don't know how to create a shipping address and retrieve...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
How? As per our use-case above, we are going to create a button off the contact record which when the user clicks on it will generate a PDF of the merged template and attach it to the CRM contact record under "Attachments". As a quick outline of the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
ZohoCRM: Get IT to do the DKIM The following are steps as to what to add in the TXT record. How to add the TXT record itself will depend on your mail server or the domain registrar's website to manage your DNS: Create a TXT record Specify the Host as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Other
- Language: *
-
]; Open the file / Download via Browser We're going to use an openUrl() function here in the hopes that your browser will just begin downloading it (failing this it will open up in the browser and staff member will need to be instructed on how to 'File...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
First of all, we couldn't find how to sync attachments from ZohoDesk to ZohoAnalytics using the integration. Other tables will sync but we couldn't find attachments, so our solution here is to create a data table and then to push the attachment from...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
This is an article to document how to produce a report which when exported to PDF will display images without a user wall. Why? Our client needs to send a report to suppliers that include photos of the faulty products. These display fine in a Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
invoice, this had to be added (don't ever remember having to do this) as contact_ids (array/list). Instead the below script 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
record but that's it. Processing the record must be done at a later time or in a different process but sometimes it simply will not process it all and respond to Shopify within 1 second. How? So let's begin with the code snippets as these might answer...
- Type: Article
- Author: Joel Lipman
- Category: Shopify
- Language: *
-
payroll system. If the data is incorrect in Zoho Analytics, and payroll gets run with these discrepancies, then they will have a fair few disgruntled employees who may have been paid incorrectly. As such this system has to be reliable and the system...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
you can 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...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
but here's the bits that I need: Updating a record with PUT (note that id needs passed for each row otherwise you will end up with duplicate line items): /* ******************************************************************************* Function: void...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
quick article to test when to use isNull and isBlank. Why? So I've noticed that looking at people's Zoho Deluge code, there will often be a check on a null before or after the variable: if(v_Test.isBlank()) {... } VS if(isBlank(v_Test)) {... }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *