Assuming separate is required, the following 43 results were found.
-
Making this field read-only to first-line agents also wouldn't help as some of the options should be selectable. Two separate fields weren't quite right either: 1 as read-only (permission only to higher level) and 1 picklist as selectable means that the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
the out-of-the-box PNL report that comes with Zoho Books. We needed a dataset that took into account "Delivery" as a separate line item on the purchase order. I'm writing this article as it had gone through several partners before us and even Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
for clients in the US, where there could be 4 different timezones between customer, agent, HQ, server; we would create a separate table to manage this data. I can't do this for every client, so here's a quick snippet to just check if Daylight Savings...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
v_BooksOrgID is the ID of the instance in ZohoBooks; so for multiple instances of ZohoBooks for the same organization, a separate call would need to be made with a different variable org ID. /*...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff can control that without the worry of updating an invoice and re-sending it.
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Note(s): Observation #1: Method Chaining: Contrary to my previously held belief, method-chaining still counted as separate statements; this is not true as the following counts 3 statements executed prior to the loop: // l_LoopInnerInner = "...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A separate article as a follow-on from my previous article in this series Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pages which may have grown a little but just wanted to record how to receive a Zoho Survey...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
can message: Send an email using the server that the “Site Email” uses. If this is web-based, then ensure you are using a separate instance of the browser to your Joomla one. Check that your template isn’t the problem: If you have a test site that has...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
My custom query To list access levels (this needs to check categories with access levels table), I have a separate table containing the wiki categories associated with local wiki groups (required to view the category): Page ID, Title, Content, Category,...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
'Date' TRIM(Date) != "" ? TRIM(Date) : "00000000" -- Derived column task 2: Add as new Column 'DC_Date' -- (note this is a separate task in the data flow to the previous one): (ISNULL(Date) || (TRIM(Date) == "00000000")) ? NULL(DT_DBTIMESTAMP) :...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
the Carriage Return (CR) or Line Feeds (LF) are being inserted, simply extract the entire row as a column and trim it. I separate out the first column as my index/key field so I can check if this is a valid data row (the blank ones may return special...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later. Why? I am...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
it. [Test2 Room] will both appear as a row and have 3 slots taken up (if you left the above to 30 minute slots). Tweaks Separate the field @GivenDate off into an SSRS parameter (note do not declare it in the SQL code if using as a parameter). You could...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and @p_Column and using only the code ** ** from the BEGIN to the END...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
from a string containing XML code. Why? I'm working with a system which stores XML strings in a database and rather than a separate file, it stores these in a row. How? Assuming the following data exists in the column "Event_XML" value of the table...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
The DBA responsible for the system asked me to look at ways of reducing the load on the server and the solution was to separate both tables (activities and users) rather than trying to join these, and to let PHP do a bit more of the work: User Query...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Explain every incremental change will render design less elegant and consistent Ask client to go over documentation (separate technical from layman)
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
though i had clear:both on the css for my #right div layer). For some reason, it has a more forceful effect in its own separate layer. In a joomla CMS template though, I wanted the "left" div to take over the whole page if there were no modules...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
A quick article on if you were given a webpage coded in HTML, what methods in AutoHotkey could you use to separate out the HTML Tables into a ListView. Why? I want a snippet of code that replicates any HTML table. How? I've been trying various ways so...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB