Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming status is required, the following 74 results were found.

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

    with " + v_CustomerName); m_ScheduleCall.put("Call_Start_Time",v_SystemAppointmentDateTimeStart); m_ScheduleCall.put("Call_Status","Scheduled"); m_ScheduleCall.put("Call_Type","Outbound"); // // optional fields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    script on a server that will validate the Xero webhook. You're going to need to respond to Xero with valid and invalid HTTP statuses as their webhook validation process is a little stricter than Zoho's. Setup a Zoho CRM Function: Login to Zoho CRM >...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

    this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the zoho.crm.getRelatedRecords() not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. ZohoAnalytics: Pivot Campaigns vs Contactshttps://joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

    and save it as "Contacts vs Campaigns Pivot": SELECT * FROM ( SELECT "Contact Id", "Contact Name", "Campaign Name", "Member Status" FROM "Campaign Members - Contacts" ) t1 PIVOT ( MAX(t1."Member Status") FOR t1."Campaign Name" IN ( "Campaign...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Setting up your store to use SSLhttps://joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

    and press return. If it has been installed correctly the store should reload and a padlock will appear in the status bar of your browser software. If, on the other hand you get any warning messages or other errors please contact your hosting company to...

    • Type: Article
    • Author: Joel Lipman
    • Category: eCommerce Systems
    • Language: *
  6. Parameters not being used in report processinghttps://joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

    dateadd(d, tt.[WeekDay] - 1, @baseDate) = @SelectedDate AND wm.[WeekNumber] = @weekNumber AND tt.[SiteId] = @siteId AND tt.[Status] 3 -- Remove cancelled bookings AND upper(sd.[Descrip]) not like 'ADDITIONAL TIMETABLE%' ORDER BY Date ASC, Room ASC,...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  7. Importing Joomla articles to WordPress postshttps://joellipman.com/articles/cms/wordpress/importing-joomla-articles-to-wordpress-posts.html

    `fulltext`) 'post_content', title 'post_title', '' post_excerpt, CASE state WHEN '1' THEN 'publish' ELSE 'draft' END 'post_status', 'open' comment_status, 'open' ping_status, '' post_password, alias 'post_name', '' to_ping, '' pinged, modified...

    • Type: Article
    • Author: Joel Lipman
    • Category: Wordpress
    • Language: en-GB
  8. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    INSERT INTO mydb_upgrade_j25.myprefix_jcomments_reports ( id, commentid, userid, name, ip, date, reason, status ) SELECT id, commentid, userid, name, ip, date, reason, status FROM mydb_livecopy_j15.myprefix_jcomments_reports; --...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  9. SSIS Convert a string into a datehttps://joellipman.com/articles/microsoft/ssis/ssis-convert-a-string-into-a-date.html

    Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932). The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data.". Error: SSIS Error Code...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  10. Zoho Deluge - Update Creator from CRMhttps://joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

    Successful Response: { "criteria": "ID==1234567890123456789", "newvalues": [ { "FieldToUpdate": "ValueToUpdateWith" } ], "status": "Success" } Method #2: Using API v1 (using JSON not XML) Generate AuthToken: Browser Mode: Open a browser to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  11. Zoho Deluge: Duplicate/Clone a Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    } } // now override fields specific to the newly cloned/duplicated record m_Clone.put("Invoice_Status","Repeated Invoice"); m_Clone.put("Invoice_Date",zoho.currentdate.toString("yyyy-MM-dd"));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    y10 gRestart, Reload Gui, Add, ListView, w600 h528 +Hdr +Grid x0 y50, Old Name|New Name Gui, Font, s7, Verdana Gui, Add, StatusBar,, Ready. Gui, Show, w%Width% h%Height% x10 y10 Return ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  13. Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

    for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?status=active&limit=250&fields=id&order=id+asc&since_id=" + v_LastID; r_GetProducts = invokeurl [ url :v_Endpoint type :GET...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttps://joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    m_Product.put("published",true); // set to true when comfortable with it publishing correctly m_Product.put("status",ifnull(input.Publish_Status.toLowerCase(),"draft")); // // build up variant list under this product l_Variants = List(); m_Variant =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://joellipman.com/articles/crm/zoho/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    " New Template", "id": "aaaa1111bbbb2222cccc3333dddd4444eeee5", "permalink": "https://docs.zoho.com/file/a1b2c3d4", "status": "active" }, { "created_time": "2019-08-28T16:30:33Z", "modified_time_ms": 1567009834477, "owner_id": "34567890",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho CRM: Schedule a Meeting using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

    // with a reminder 5 minutes before (eg. "10 mins", "1 hrs") m_ScheduleMeeting.put("Remind_At","5 Mins"); // // the meeting status m_ScheduleMeeting.put("Status","Not Started"); // // send request and create record r_CreateMeeting =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    were: When an invoice is "Created or Edited" Execute the workflow when "When any field is updated" Filter the triggers when Status is "Paid" Just once or every time is "Everytime" Actions is a custom function called "fn_invoice_updatepaymentmethod" But...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoCRM: Integrate ChatGPT to ZohoZIAhttps://joellipman.com/articles/crm/zoho/zohocrm-integrate-chatgpt-to-zohozia.html

    r_Response = zoho.crm.invokeConnector("crm.getusers",m_UserType); if(!isnull(r_Response.get("status_code"))) { if(r_Response.get("status_code")==200) { l_Users = r_Response.get("response").get("users"); for each v_User in l_Users { v_LoggedInUserID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, CancelPending, Completed, Inactive, InProcess v_OrderStatus = "All"; // // calculate from...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    back to StaticAlias rather than member Email - Possibly still an issue with delayed payment (check this is not holding status) Date Modified: 2023-03-17 (Joel Lipman) - Enhanced debug messages as function not auto-triggering on receipt of Order -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 21 - 40 of 74

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.