Assuming where is required, the following 225 results were found.
-
rate held in a custom module. The custom module could only be created in Zoho Books at time of print but Zoho Inventory is where our workflow and code is sitting right now. The code snippet to get the item record from the price book Note that I'm using...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure you setup a Connection that does NOT use the credentials of the logged-in user and has as scope...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
My use-case here is that we have a client who uses their purchase orders and sales orders as part of a logistics solution where items are purchased from a supplier, sent to another supplier for grading, and then sent on to the end user/customer. A...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming? Here's the code to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Notification Many ways to add a button but here's how I do it (requires some basic HTML/CSS knowledge): Place the cursor where you want the button and give it some text, I'm going to start with Accept Quote Then click on the link icon and give it the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
on the value. Assuming I have a tab called "Sales Pipeline", and "Hire Pipeline": Go to the deal record and scroll to bottom where you can see an "Edit" button for this canvas. The edit mode of the canvas will popup in a new tab. Right-click on the tab...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
= r_ShopifyAPI.API_Version; // // url with client id and client secret (now to be deprecated July 25, 2025 by Zoho) // where p_OrderID is the shopify order ID v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion + "/orders/" + p_OrderID +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
at the bottom of this article), the simplest way was right in front of us. We're going to use the interface to find the form where staff have been entering employees goals, then we're going to query it and push it to Zoho Analytics. Find the form link...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Date%20DESC m_Params.put("order","UpdatedDateUTC DESC"); // // get the first page of Xero invoices v_FilterReceivables = "?where=" + zoho.encryption.urlEncode("Type=\"ACCREC\""); r_AllXeroInvoices = invokeurl [ url :v_DataEndpoint + "/Invoices" +...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
these lines: body.bgstyle1 #main-background {background: url(../images/backgrounds/bgstyle1/bgimage.jpg) 50% 0 no-repeat;} where 1 is the number of the style of the template I am setting the background for and I add the "fixed" attribute to this id....
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
a given SQL date to the standard European format: $this_date=mysql_result(mysql_query("SELECT my_date_field FROM my_table WHERE my_id='$this_id'"), 0, "my_date_field"); $this_date_array=explode("-", trim(substr($this_date, 0, strpos($this_date, " "))));...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
Add, Picture, x600 y70 w90 h90 vSearchButton gSearch, %A_ScriptDir%\images\program\search_button.png Add the input field where you type the text: Gui, Add, Edit, x55 y95 r1 w550 vSearchTextInput, Search... Add the submit button with a hidden attribute:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
MyALN is a web-project where the original developer ended their support for the site. I was called in to fix several underlying issues and integrate it into the university systems. The Additional Learning Needs team at Bournemouth University use their...
- Type: Article
- Author: Joel Lipman
- Category: Portfolio
- Language: *
-
Frontpage Item Orderinghttps://www.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html
Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
The Sandpithttps://www.joellipman.com/graphic-design/the-sandpit.html
I saw this on BBC News Click and was really impressed. It's an effect called "time-lapse tilt shift photography" where everything is made to look smaller than it actually is. As an update Mar 2011, I just watched Gulliver's Travels (2010) and it looks...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
MySQL Oracle equivalentshttps://www.joellipman.com/articles/database/mysql-oracle-equivalents.html
table_name from sys.dba_tables - Return a specific number of rows SELECT * FROM table1 LIMIT 0, 10 SELECT * FROM table1 WHERE ROWNUM
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
+ "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
1, 1), '/', SUBSTR(MD5(img_name), 1, 2), '/', img_name) AS img_path_with_file from wikimedia_image -- where -- SUBSTRING(img_timestamp, 1, 8)>=20110922 ORDER BY img_timestamp DESC Note that I've commented out the lines which specify images modified...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the server holding my site) Enter login credentials Type dir (lists files & folders in...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
So having moved desk from one side of the room to another, I have lost my view of the sea. Oh well, this is where technology has come to the rescue and returned my calming view... Note: I think this is running in British Summer Time (BST) rather than...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF