Assuming note is required, the following 299 results were found.
-
in this custom field per line item, but also requires a change to the other fields in the line item. There is an additional note that when using v2.1, you no longer post to the "Product_Details" key but to the respective module line item API name as per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
field Publish it by going to Settings > Publish > Publish Component > and select the REPORT (eg. "Inventory Photo Report"). Note the embed code, specifically the long alphanumeric string. Create a connection from Zoho Creator to Zoho Inventory 3 lines...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
a file; then we'll use invokeURL to upload the file. Generating the CSV Here's the simplified code to generate the CSV - note that I am replacing commas with the HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"Question Number" You can take out the order by clause. I just have it here to preserve my sanity when viewing the output. Note that "Page Number" is my custom sorting mechanism so you would have to refer to the output without this column before...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
go through a resolution and get the official response on what impact this has on refreshing the token. Then I'll put all my notes I made along the way. When a Zoho Books bank feed stops syncing in the United Kingdom, there are a few possible causes....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha. Note: There is a Joomla plugin for AYAH and this works for the user registration form. I installed it but the below details how...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
AS PersonDays, CONCAT(r.CapexCode, ' - ', r.ResourceName) AS Resource, s.StaffActivity AS Activity, s.AdditionalNotes AS Notes, CONCAT(SUBSTRING(YEARWEEK(s.DateTimeCreated,1) FROM 5), '/', SUBSTRING(YEARWEEK(s.DateTimeCreated,1), 1, 4)) AS ActivityWeek,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Effects So I can now build a prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography Aerial Photography...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements: How? For the following examples, I am pretending to select rows from a table called `STUDENTS`....
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how I've achieved this across multiple monitors... and now multiple desktops. How? The following example is assuming you...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Club (the only places you're supposed to be flying). Black: Earthquakes & Extreme Weather: To avoid, or search & rescue (note there are laws about getting involved). Regulations: Flight regulations are fed from api.joellipman.com and currently default...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User = zoho.crm.getRecordById("users",...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
to the Sales Order in Books... but it isn't and doesn't. It only attaches the file(s) to the CRM record. See my "Additional" note further below in this article on how to sync the attachments to the CRM record, however for now, check the logic of this as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
then use the endpoint https://www.zohoapis.com.cn/crm/v2/coql 3. The Deluge Code - Uses the EU datacenter Note that using this method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0;...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Open a browser and Ensure you type the preceding “https” rather than the default “http” [Optional Step] This is an added note/step if you get the following error when trying to access your app on your localhost: “127.0.0.1 normally uses encryption to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Syntax #5 [image]: Update 2023 Again this example doesn't include the publish key but can be used across apps in Creator [note this is just for quick ref]. Where my form is called "My_Form" and the image field is "My_Photo" [also note: instead of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
quantity (defaulting to zero) alongside each serviceable item. How? So at time of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, a package slip/delivery note, a shipment order; as well as...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *