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 action is required, the following 38 results were found.

  1. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    r_LeadDetails..insert( ); Events I have used this task which contradicts documentation: In a custom function In an Action item in Report In a schedule workflow Source(s): Zoho Creator - Insert rows in Subform (via Deluge Script)

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho Creator: Create a Widget which uses JavaScripthttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    your browser page should now display something similar to the following: Note that for every action you are doing in the Safari browser, there will be a log in the terminal: Editing the Widget So let’s modify the widget.html file in this app by opening...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    code and without needing to use your creator knowledge. I haven't been using this because I edit the content based on the action using values from the form invoking it but for generic messages you could get the "Notify" page to read from a form/report:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-sort-a-map-by-a-specific-field.html

    m_UnsortedRecords.put(v_SqlDateTime, r_Record); } } // // now sort list in descending order and action each record l_SortedKeysDesc = l_SortingKeys.sort(false); for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    if this was a task and not a call: v_ReminderDate = v_SystemAppointmentDateTime.subMinutes(15); v_ReminderStr = "FREQ=NONE;ACTION=EMAILANDPOPUP;TRIGGER=DATE-TIME:" + v_ReminderDate.toString("yyyy-MM-dd'T'HH:mm:ss") + "-05:00"; m_ReminderAlarm = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-text-sms-using-twilio-api-localsense.html

    Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the function below with the parameter "p_CallID" being the Calls - Call ID value. // r_CallDetails =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Books: Error 7008: There are no contact persons associated with this Invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohobooks-error-7008-there-are-no-contact-persons-associated-with-this-invoice.html

    mark it as sent. As the function I use before this to generate the invoice, also updates an invoice, I wanted to keep the action of sending separate so that staff can control that without the worry of updating an invoice and re-sending it.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho Deluge: Determine your Statement Execution Limithttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-your-statement-execution-limit.html

    = " ".leftpad(5000); l_LoopInner = l_LoopInnerInner.replaceAll(" ", ","); l_Loop = l_LoopInner.toList(); // 3 actions so far // for each index v_Iteration in l_Loop { info v_Iteration; } // yields an incremental count from 0 to 4997 But the following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-remove-duplicate-product-records.html

    other than products. This function will also try to delete the duplicate but if the duplicate is the one used in a transactional module record (eg. quotes, sales orders, invoices, purchase orders), then it will delete the older one (referred to as keep...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    Fields > Accounts [or whichever module the button needs to be on] > Buttons > Create New Button Give it a name, Define the action as Open a Widget, Select Page as In Record, select position as Details then click on Configured Widget - Choose Click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    AS "Response Date", CASE p."Title" WHEN 'DEMOGRAPHICS' THEN 2 WHEN 'AWARENESS' THEN 3 WHEN 'ENGAGEMENT' THEN 4 WHEN 'SATISFACTION & FEEDBACK' THEN 5 WHEN 'USABILITY' THEN 6 WHEN 'FEATURES' THEN 7 WHEN 'PRICING' THEN 8 WHEN 'SUPPORT' THEN 9 WHEN...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  12. Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/component/content/article/running-internet-explorer-6-7-8-as-standalones.html?catid=80&Itemid=165

    on the first boot device Select "CDROM" Press "F10" to save and exit the BIOS. Load your ISO or CD into your CDROM Go to "Action" in the menubar and select "Reset..." Additional Information Taming your multiple IE standalones...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  13. Administrator Program Shortcut without Prompthttps://www.joellipman.com/component/content/article/administrator-program-shortcut-without-prompt.html?catid=80&Itemid=165

    spaces). tick the checkbox Run with highest privileges. set "Configure For" to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path which is usually...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  14. T-SQL concatenate an incremental row numberhttps://www.joellipman.com/articles/else/database/t-sql/t-sql-concatenate-an-incremental-row-number.html

    produces an error which can only be seen when using more records and more employees. PARTITION BY So a sort of "group" action will allow this if we add "PARTITION BY" to the ROW_NUMBER() statement: SELECT q.Employee AS EmployeeNo, RIGHT('000' +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  15. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    blur --no dof f/1.8 f/1.4 f/2.0 f/2.8 Style of Art/Film Same image again but let's try some of these keywords out: Abstract Action Painting Alien Art Nouveau Baroque Bokeh Clip Art Collagraph Comic Conceptual Cubism Cyberpunk Dazzle Dream-like Engraving...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
  16. Add "Command prompt from here" to right-click context menuhttps://www.joellipman.com/component/content/article/add-command-prompt-from-here-to-right-click-context-menu.html?catid=80&Itemid=165

    Click on the File Types tab Scroll down and select (NONE) Folder as file type Click on Advanced Click on New... For the Action type what ever you want the context menu to display, I use Command prompt from here For the Application value type...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  17. How to make a HTML form post its variables to itselfhttps://www.joellipman.com/articles/cms/website-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

    you want the same PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hypertext Markup Language
    • Language: en-GB
  18. The greatest invention in IThttps://www.joellipman.com/component/content/article/the-greatest-invention-in-it.html?catid=116&Itemid=165

    if your mistake is ancient history." - Learning GNU Emacs (page 42) Undoing can itself be undone. After having undone an action, you can redo it... - Docs.Gimp.Org Synonym: redound Latin - Etymology - From unda ("a wave")

    • Type: Article
    • Author: Joel Lipman
    • Category: IT Support
    • Language: *
Results 21 - 38 of 38