Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

15 May 2020 l_BuildUrl.add(v_PermalinkCode); v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // yields something like //...

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

Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 (untested). Widget File: upload the ZIP file from your dist folder. Index File: put here the root html file along with the path (do not forget the leading slash or your widget will error) Click on "Create" (bottom-right of your screen) Now go to a...

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

Zoho Creator: Set Up Custom Domain for Customer Portalhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-set-up-custom-domain-for-customer-portal.html

17 November 2020 Advise them that you have verified the domain using CNAME and that the CNAME record is setup. You will need to give the full path of the custom domain (eg. https://mysubdomain.joellipman.com), I include the app owner and app name. Then you need to give...

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

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 were given the following snippet of code (not tested yet!). It looks like we have to fill in the blanks and it's on the same path as we were. The main revelation was the function getEmployeesOnLeave and perhaps this can be combined with a function that...

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

Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 or have you mapped the field twice? {"code":"MANDATORY_NOT_FOUND","details":{"api_name":"Call_Type","json_path":"$.data[0].Call_Type"},"message":"Empty Call Type","status":"error"} ok specify a call_type...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 Error(s): {"errors":[{"message":"Field 'endCursor' doesn't exist on type...

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

ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

14 May 2024 settings I put in as a separate workflow: Step 3: Delete transferred tasks on converted contact Having disregarded the happy path, what if a lead gets converted to a contact? We then need to remove this task as it will transfer to the contact record on...

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

Invalid arguments passed in router.php on line 325https://www.joellipman.com/articles/cms/joomla/invalid-arguments-passed-in-routerphp-on-line-325.html

03 August 2010 [function.implode]: Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by...

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

MySQL Group_concat equivalent in T-SQL and Oraclehttps://www.joellipman.com/articles/database/mysql-groupconcat-equivalent-in-t-sql-and-oracle.html

28 November 2011 T-SQL SELECT STUFF( ( SELECT ',' + column_to_return_as_string FROM a_pretend_table WHERE a_condition=true FOR XML PATH ('') ),1,1,'' ) AS my_field_name FROM another_pretend_table Oracle SELECT ( SELECT wmsys.wm_concat(column_to_return_as_string) FROM...

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

List last modified files using FTP Command-linehttps://www.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 holding my site) Enter login credentials Type dir (lists files & folders in the current remote working directory) Type cd /path/to/my/website to change directory to the root folder containing your website. Type pwd to confirm the remote working...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *