Assuming like is required, the following 186 results were found.
-
as a minimum, the scope ZohoBooks.salesorders.CREATE is ticked. Click on "Authorize" Read the notice saying Creator would like access to bla bla bla and click on "Accept" Get the file URL (ie. the PermaLink) So if you've been googling how to download a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= m_Currencies.get(ifnull(r_AccountDetails.get("Currency"),"GBP")); info v_BooksCurrencyID; Yields something like: { "EUR": "123456789012345678", "GBP": "234567890123456789", "USD": "345678901234567890", } 234567890123456789 Get Taxes Same as above but...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
parameters: m_Params.toString() connection: "joels_coql_connection" ]; // // output info r_Coql; But this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001"...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
:POST headers:m_Header parameters: m_Params.toString() ]; v_Output = r_UploadPhoto; } return v_Output; } Sends something like the following request (sent using Zoho Deluge but the cURL breakdown as follows): curl -d...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "12345678", "last_opened_time":...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
group positioning v_Css = v_Css + ".zc-Tabs-group{margin-bottom:0;margin-top: -103px;}"; // styling the form wrapper to look like a tab panel v_Css = v_Css + ".zc-form-scroll-wrapper{padding:20px;border:1px solid #eee;margin-top:100px;}"; // move the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
A quick article on a code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Inventory
- Language: *
-
Order ID" WHERE poitm4."Item Name" = 'Price Disrepency' OR poitm4."Item Name" = 'Price Discrepency' OR poitm4."Item Name" LIKE '%Discrepancy%' GROUP BY po4."Purchase Order ID" ) pdiscrepancy ON pdiscrepancy."PO ID" = po."Purchase Order ID" WHERE...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
to center, changed "Display As" to "Image", and set the image dimension to "64 x 64": I should end up with something like this: Create a query table with images Irrespective of where the images are hosted, you can now write a SQL (more precisely an...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
the variable but in more complex method chaining, I can see myself accidentally doing this. It's more that I saw other code like this and when reverse engineering or debugging the code, it may be worthwhile having a definitive idea of what will happen....
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
don't know why you would order by this ordering => the setting it's on if you haven't made this modification. I don't like it and nor do u if you've been trawling the web for this solution. archived => is or not approved => again params => what params?...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
postal address textPassword // password type field textVisiblePassword // um... textPhonetic // text that will sound like number // changes keyboard to numeric numberDecimal // allow a decimal number phone // enter a phone number datetime // enter a...
- Type: Article
- Author: Joel Lipman
- Category: AndroidOS
- Language: *
-
+ " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
a matrix because this will automatically group the rows by room (you need to do this anyway otherwise it will look a bit like a staircase of bricks). 4. Design the Matrix: In other words, put where all the values are going to go. [Time] into "Columns",...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
this at the time of print so there may be a million better solutions out there, this is just how I did it. This may look like a horrible report which would fail an accessibility test but visually it says straight away which is the better report; and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I have a PHP script which behaves like PhpMyAdmin, in that it automatically lists a database structure and the fields to modify similar to an excel spreadsheet. Now without using PHP, I need standalone SQL scripts that can simply be used to search an...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
copy, paste and run against your SQL database. Simply run the query that the above outputted and you should get something like the following: Value Source Count ------- ------------------------- -------- dnya myTable1.Title 2 DNya...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
a system that is both up and running via the front-end and back-end. It's MediaWiki CMS used by Wikipedia.org and the like. I like queries against this database because it involves linking a lot of tables and outputting... just articles and their...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
idea of a slideshow with the MooTools javascript framework. Basically, I want to create a div layer that I can see through (like a window with no glass) and for all the flashy stuff, to only appear within the boundary of the parent div layer. Why? I'm...
- Type: Article
- Author: Joel Lipman
- Category: MooTools Framework
- Language: *
-
really simple, we could try: $search_term_esc = AddSlashes($search_term); $sql = "SELECT * FROM Content WHERE content_body LIKE '%$search_term_esc%'"; Great! Few problems though, multiple terms are not supported; quotation marks and apostrophes may be...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB