ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 creating a custom module where our client wants to query Zoho Recruit via the API but couldn't find a database table to determine who has been associated to what job. In Zoho Recruit reports (Analytics), you can include the "Associate" module which then...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 = o_ThisLineItem.Vendor_Currency; // going to create a new set of line items a_NewSuformRows.push(o_NewLineItem); } } } // determine deposit amount // get grand total (note that formula for grand total excludes line items which were optional)...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 Warning - This is where a public announcement is made that mentions your name and that you have broken a rule. I will determine whether you knew what you were doing was wrong or whether a warning is necessary to explain it to you. If I do not give a...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

SQL Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 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 on. [Order] = DENSE_RANK() OVER (ORDER BY d.[Date]), -- date used in all calculations for date...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 $text = preg_replace( "/($term_rx)/ise", "search_highlight_do(StripSlashes('\\1'), \$color)", $text ); } return $text; } # determine colors to use function search_get_highlight_colors(){ return array( array('#ffffcc','#CA6C17'),...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

The ReportServer Databasehttps://www.joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 I have just spent all morning on Microsoft websites to determine what number is the TimeDataRetrieval column displaying. Thank you I know it's an INT. There is just a serious lack of documentation as to what this database is and how it populates its...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

SSRS External Images don't displayhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-external-images-dont-display.html

19 September 2011 depended on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks of trying to find a solution, I would...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

How to Display Report Execution Time in SSRS (milliseconds)https://www.joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 2. Check this result - Possibly from the Reporting Server ExecutionLog? Using the ReportServer Execution Logs, we can determine if this is correct SELECT TOP 1 c.Name, e.TimeStart, e.TimeDataRetrieval + e.TimeProcessing + e.TimeRendering AS TotalTime...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

T-SQL example of Case-Sensitive Soundexhttps://www.joellipman.com/articles/database/t-sql/t-sql-example-of-case-sensitive-soundex.html

10 October 2012 Not Yet Available data not yet available Daat oNt EYt Avialable Success! Now we can run this on a column in a table to determine if there are discrepancies in our default values. Additional Note how this also picked up typos in the 4th value which is...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://www.joellipman.com/articles/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

28 January 2013 a sort of reversed form. For argument's sake, I'm assigning this string to the variable "haystack". How? Perhaps we should determine the position of the last needle first (reverse the haystack string and find needle): DECLARE @Haystack VARCHAR(31); SET...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: en-GB

Administrator Program Shortcut without Prompthttps://www.joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 of Windows 7 Taskbar shortcuts (Pinned): %APPDATA%\Microsoft\Internet Explorer\Quick Launch\User Pinned\TaskBar. You can determine what %APPDATA% is by opening a command prompt and typing: echo %appdata%

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Restore MSSQL Error: Database is in usehttps://www.joellipman.com/articles/database/restore-mssql-error-database-is-in-use.html

08 March 2013 Database Backup Using SQL Server Management Studio Unable to restore database "..because it is in use by this session." determine who is connected to sql database Sources Microsoft Developer's Network

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: en-GB

Parse a HTML Table into a ListViewhttps://www.joellipman.com/articles/web-development/html/parse-a-html-table-into-a-listview.html

30 March 2013 the table in a listview format: ; tell the script which content to parse Haystack := CodeContainingMyHTMLTable ; determine markers (character positions) Needle1a := " My Unique Table Heading" ; Needle1a is a marker for a unique value in the whole...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: en-GB

Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=40

09 March 2015 "Search Area". This is the component to search so other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Accessing Apimo WebService APIhttps://www.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with each step of the development as the error messages were somewhat vague. I thought I'd quickly write this...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 where you enter your own email address and zoho password. Determine the EndPoint: Following the syntax: https://creator.zoho.com/api////form//record/update where ownername is the owner, format is the type (I prefer JSON), applicationName is the name of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

09 May 2019 get the remainder from dividing it by 26 (modulus)... This is NOT to be used for Booking Retrieval Codes as it is easy to determine what code if you have the date/time of the booking as well as the customer's surname (method #1 would not be guessed by...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Deluge - Counting in a Map dataTypehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-counting-in-a-map.html

02 September 2019 on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine which best fits your scenario: Counting total products: // // count total products for availability m_ProductCount = Map(); for...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: en-GB

Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-search-records-with-special-characters-coql.html

28 August 2020 or ZohoCRM.modules.all Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2. Determine the client datacenter Look at the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

28 April 2021 held in temporary CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create a standalone function called "Test"....

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *