Assuming based is required, the following 104 results were found.
-
A super quick article on how to pre-select the pipeline on deal creation within CRM based on the department specified on a user's profile. Why? A client asked that when staff create a deal/opportunity record in CRM, the pipeline is automatically...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
-- Description: Gets the room bookings for a week based on a given date and campus -- =============================================================================== DECLARE @GivenDate datetime, @GivenCampus varchar(100), @setId varchar(10), @weekNumber...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to Transact-SQL (T-SQL) What? This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table. Why? I have a table that has all the days of sickness of employees. This table contains, which...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Make a backup copy of your old Joomla website (1.5.x) Download and install the latest Joomla CMS Go through the Joomla Web-based Installation GUI until the process deletes the Installation folder. Avoid installing Sample Data if possible (there will be...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
What I'm trying to do is display a set of results (comparing various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set. Something like: The DataSet This should work on your reporting server...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
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 job uses Team Foundation Server, Agile/Jira and even a bespoke project...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
What? An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Licence GNU/GPLhttps://joellipman.com/static-items/licence-gnugpl.html
other than the making of an exact copy. The resulting work is called a “modified version” of the earlier work or a work “based on” the earlier work. A “covered work” means either the unmodified Program or a work based on the Program. To “propagate” a...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
Logged in to Zoho as an Administrator of the system to access. Browse to the Zoho Developer Console at the appropriate link based on the clients datacenter: US datacenter: https://api-console.zoho.com/ EU datacenter: https://api-console.zoho.eu/ If this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
client script to is a custom module called "Deployments". The field which triggers it is called "Which_rate_card_is_this_based_off". The expected outcome is the appending of a row to the subform based on the start date (first field in the subform) match...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or listed building. Dynamic Zones are created using data fed for extreme...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
knowing any code and without needing to use your creator knowledge. I haven't been using this because I edit the content based on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
reason that the process would be: allow a user to apply for leave, then on save/submit, auto approve/reject the application based on a custom function that could calculate the percentage of staff who already booked the requested dates as leave....
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
1,GETDATE()),101) + '/01/2009 01:30:00 PM', Note = 'Event 6' ) SELECT -- Number the records based on the date, if multiple records have -- the same date then they will be numbered the same. Used in -- calculation to determine row record is to display...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from within the same select query based on a column that's different. So for example, I have data like the following: SELECT DATENAME(dw, StartDate) AS 'Day' FROM...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the student ID number Agenda Outline Note: As...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to cascade across my servers (average wait is 1 hour). JoelLipman.Com will develop the startup site using an Agile framework based on the initial requirements up to and including the User Acceptance Testing (UAT) date (not yet agreed, but about a week...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
program will confirm that it will begin batch processing, (if more than 20 then it won't list them all), it processes them based on the options you set under "Tools > Options". When it's done it will popup an alert and then try to open the folder...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
will be using examples that start with javascript: - which you will feed through the URL Address bar. These examples will be based on (and can be used with) the Search Forum webPage. Our first example will use the alert() method to pop-up a message box...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *