Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

17 August 2022 working for you without this issue. By changing the workflow to execute not "When any field is upddated" but "When any selected field is updated" and then selecting the fields "Status", "Balance", and "Notes". (not sure which one fixed it but I now add...

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

ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

17 October 2022 super admin or ascentcloud admin account) Log in to https://accounts.zoho.com/developerconsole Click on Add Client ID Select "Self Client" Provide the details and register your application Upon successful authentication, you will be provided with Client...

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

Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

06 August 2024 will know this takes a while to do: You have to find the contact record in CRM for example Click on "Send for Zoho Sign" Select the template document or upload one Add the fields that you will complete, and the ones that other recipients will complete...

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

Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-using-remove-key-on-a-map.html

03 March 2025 the same name), then it only copies over the name: v_TotalCount = 0; v_TotalProcessed = 0; v_PerPage = 100; v_CoqlQuery = "select id, Contact_Name.Tag 'Tag' from Deals where Tag is null and Contact_Name.Tag is not null order by id asc limit " +...

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

ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

06 May 2025 certain tabs on a deal record based on the pipeline. Why? A request from a customer asked if a tab specific to the pipeline selected can be shown while others hidden. Standard tabs such as Notes, Attachments, Emails, and Timeline should remain. Code...

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

How to run a .RUN filehttps://www.joellipman.com/articles/linux/how-to-run-a-run-file.html

19 September 2009 the .RUN file is in this one Type 'sudo sh nameoffile.run' Through the Gnome GUI Right-click on the file you downloaded Select 'Properties' Select the 'Permissions' tab Tick the 'Execute' checkbox Conclusion The solution using the terminal worked for me...

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

Joomla banners not rotatinghttps://www.joellipman.com/articles/cms/joomla/joomla-banners-not-rotating.html

20 October 2009 the same client OR the same category. The setting is in your Joomla > Module Manager > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display,...

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

SSRS Report Builder 2.0 - Error during processinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 interface of Report Builder 2.0 for the problematic report: Right-click on the reported DataSet (in my case: DataSet1) and select 'Dataset Properties' Select 'Parameters' and click on the duplicated field Click on the 'Delete' button and you should be...

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

SSRS Use T-SQL Like with a Parameterhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 auto-scroll down to the desired name. Our advanced users are exceptions to the rule. Problem Consider the following query: SELECT rb.[GivenDate] , rb.[DateStart] , rb.[DateFinish] , rb.[ContactUsername] , rb.[ContactName] , rb.[Room] , rb.[BookingNotes]...

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

Oracle SQL - Convert given list (CSV) into Rowshttps://www.joellipman.com/articles/database/pl-sql/oracle-sql-convert-given-list-csv-into-rows.html

30 August 2011 this as a rows in a table. This is for Oracle PL/SQL. My List: 1, 2, 3, 4, 5, 6 Yields: 1,2,3,4,5,6 Using this snippet SELECT EXTRACT (VALUE (d), '//row/text()').getstringval () AS AppNo FROM (SELECT XMLTYPE ( '' || REPLACE ( '1, 2, 3, 4, 5, 6' , ',',...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Convert a delimited string to tablehttps://www.joellipman.com/articles/database/convert-a-delimited-string-to-table.html

26 October 2012 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname'; SELECT @myXml = CONVERT(xml,'' + REPLACE(@myStringToParse,',','') + ''); SELECT [Value] = T.c.value('.','varchar(20)') FROM...

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

MySQL: Find all non-alphanumeric rowshttps://www.joellipman.com/articles/database/mysql/mysql-find-all-non-alphanumeric-rows.html

09 September 2013 non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that are non-alphanumeric but ignore...

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

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttps://www.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 Tools" and open "Sql Server Configuration Mnaager". Right-click on "SQL Server Integration Services 10.0" and select "STOP". Right-click on "SQL Server (SQLEXPRESS)" and select "STOP".

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

Setting a rocket theme background to fixedhttps://www.joellipman.com/articles/cms/joomla/setting-a-rocket-theme-background-to-fixed.html

06 September 2009 about. Go to Extensions -> Template Manager> Edit the CSS for the template You should be given an option of css files, select styles.css and click on the Edit button Look for these lines: body.bgstyle1 #main-background {background:...

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

Converting SQL date in PHP to European date format and vice-versahttps://www.joellipman.com/articles/web-development/php/converting-sql-date-in-php-to-european-date-format-and-vice-versa.html

17 September 2009 This is what I use to convert 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,...

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

Can't play music after Firmware Update Version 3.0https://www.joellipman.com/hardware/cant-play-music-after-firmware-update-version-30.html

21 September 2009 you can play music again. What a bummer you can't play music and use anything else anymore. I can still play some games and select my own music... but they're dumbass PSN games that iPhone users would have got for a pound or what have you...

• Type: Article
• Author: Joel Lipman
• Category: IT Support
• Language: *

Using MetaMod to hide buttons from logged in usershttps://www.joellipman.com/articles/cms/joomla/using-metamod-to-hide-buttons-from-logged-in-users.html

22 September 2009 a new menu module for the regmenu menu, mine are called - 'pubmenu' and 'regmenu'. Edit your original menu module and select everything you want your registered users to see and then copy over to the newly created 'regmenu' module or what ever you...

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

Mediawiki Extension for Camtasia Studio SWF videoshttps://www.joellipman.com/articles/cms/mediawiki/mediawiki-extension-for-camtasia-studio-swf-videos.html

08 October 2009 and produce the SWF files Finish doing your video Go to File > Produce Video As... > Custom production settings > Next Select 'Flash (SWF/FLV) - Adobe Flash Output' > Next ExpressShow (complete optional settings) > Next Video Info (complete optional...

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

Error during processing - Converting Date/Timehttps://www.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 was inserting the parameters into my query. Once you've added your parameters (date/time type): Right-click on the DataSet. Select 'DataSet Properties. Find your parameters in the Query. Check that there are no apostrophes enclosing the parameters....

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

Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/alternate-row-background-colour-in-reporting-services.html

04 February 2011 pane and scroll down to the "Fill > BackgroundColor" row and copy the value to your clipboard or notepad, etc. Then select all the remaining cells in the row and paste your expression in the "Fill > BackgroundColor" properties row... Done! Borders: I'm...

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