Zoho Creator: Change Radio into Tabshttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

22 October 2021 tab, the selected tab didn't stay a different color or style. One theoretical way around this could be that I restyle the "::after checked", hide the circle line and somehow style the inner dot to overlay or serve as background on the tab. But that was...

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

Zoho CRM: Schedule a Task: Timesheet Reminderhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-task-timesheet-reminder.html

02 December 2021 v_LastName = ifnull(r_User.get("last_name"),""); // // single out this person (can be removed after testing) if(v_LastName.containsIgnoreCase("Lipman")) { // // get user id v_UserID = r_User.get("id"); // // startofweek is a sunday but we want to start...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 a summary of your import: You can then setup a schedule for the import to automatically download the data file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings you may need on your quest to...

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

Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)http://mail.joellipman.com/articles/crm/zoho/zoho-crm-using-a-function-for-validation-rules.html

11 February 2022 and not really knowing which one defines the stage the lead is at. How? Well this can be done through a validation rule. After working in Zoho CRM for over 3 years, this is the first time I'm using it so I'm documenting it. For this example, we're going...

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

PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttp://mail.joellipman.com/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html

12 March 2022 will load up on my one monitor connected to my motherboard, but my windows login screen will appear on my central monitor (after further reboots my daisy chained 2 monitors now load the bios logo with the primary monitor displaying the windows login) >...

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

Zoho Analytics: Determine profits from invoices and purchase ordershttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

03 November 2022 one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or missing associated purchase orders altogether. I had to break this down into several queries to generate...

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

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 which is possibly all your data being mapped, associated, and imported... I personally had to refresh the screen a few times after about 10k records as the browser webpage seemed to hang or get stuck. It just resumes where it left off and ultimately...

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

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

20 February 2023 } updatedAt } cursor} pageInfo { hasNextPage } } }"; } else { v_GraphQl = "{ productVariants(first: " + v_PerPage + ", after: \"" + v_Cursor + "\", query: \"updated_at:>'" + v_UpdatedSince + "'\") { edges { node { id price sku barcode inventoryQuantity...

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

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 "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 estimate ID and I'm...

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

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 Image=c_ImageRow.Image File_field=f_DownloadFile Subform_Row_ID=c_ImageRow.ID ]; } // // store this after the record is created/updated (was getting error if included in record creation - if in same row). // c_ImageRow.File_field = f_DownloadFile; // //...

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

Zoho Webhooks & Shopify API: Keep Disappearinghttp://mail.joellipman.com/articles/crm/zoho/zoho-webhooks-shopify-api-automatically-restore.html

22 April 2024 called Shopify - Webhook - Order Notification. It's a standalone function but you'll need to hover the mouse over it after creating the function so that you can enable the REST API endpoint of it. This will need to be triggered whenever there is an...

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

ZohoDeluge: eBay marketplace account deletion/closure notificationshttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-ebay-marketplace-account-deletion-closure-notifications.html

13 March 2025 containing only letters, numbers, underscores (_), or hyphens (-), which eBay uses to verify ownership of your endpoint. After entering your Notification Endpoint URL and Verification token, click Save, triggering eBay’s validation process, which...

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

Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

25 September 2025 = Map(); m_Params.put("CONFIG",m_Config.toString()); // // in analytics, browse to the target table and note the URL IDs after workspace and view v_Endpoint2 = "https://analyticsapi.zoho.com/restapi/v2/workspaces/" + v_WorkspaceID + "/views/" + v_ViewID...

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

Migrate MediaWiki to another serverhttp://mail.joellipman.com/articles/cms/mediawiki/migrate-mediawiki-to-another-server.html

23 September 2009 'YourPassword' ; MediaWiki Upgrade copy all the new files to wiki folder and then run php update.php from maintenance folder after updating AdminSettings.php More Information http://www.mediawiki.org/wiki/Manual:Moving_a_wiki

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

Does Google Chrome Frame really improve performancehttp://mail.joellipman.com/articles/google/does-google-chrome-frame-really-improve-performance.html

23 September 2009 Manager Select the template and click on 'Edit' Click on 'Edit HTML' Look for the beginning tag Insert the code above just after the tag Click on 'Save' and you're done More Information: http://code.google.com/chrome/chromeframe/

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

Prices get rounded up in Virtuemarthttp://mail.joellipman.com/articles/ecommerce/virtuemart/prices-get-rounded-up-in-virtuemart.html

27 September 2009 Another suggestion was to alter the main virtuemart database table (jos_vm_prodcut_price)... Don't do any of these things! After modifying tax rates and ensuring these were all the same, we also found that this was due to a country not being specified...

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

Add default to a picture buttonhttp://mail.joellipman.com/articles/automation/autohotkey/add-default-to-a-picture-button.html

10 November 2009 more confusing then anything else. My solution is to set up the default button and the image to respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press...

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

Joomla - How to preview module positions in a given templatehttp://mail.joellipman.com/articles/cms/joomla/joomla-how-to-preview-module-positions-in-a-given-template.html

02 April 2010 like USER 1 and TAB 4 etc..." To open a web-browser window or tab with this preview, type the following in the address bar after your website URL: http://www.yourdomainname.com/index.php?tp=1&template=thetemplatename where yourdomainname.com is your...

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

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

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

Frontpage Item Orderinghttp://mail.joellipman.com/articles/cms/joomla/frontpage-item-ordering.html

16 September 2010 Having trouble ordering your frontpage articles? After re-ordering articles wondering where it was taking the order it puts the articles in the front page (or landing page) was confusing me. The quick answer is that it is within the menu manager > main...

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