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

  1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    public class ScriptMain : UserComponent { // Method that will be started for each record in your dataflow public override void Input0_ProcessInputRow(Input0Buffer Row) { // C# alternative for VB.Net StrConv uses cultureinfo and threading // See:...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. MessageBox or AlertDialog in Android Javahttps://www.joellipman.com/articles/else/app-dev/android-os/messagebox-or-alertdialog-in-android-java.html

    .setTitle("Some Title") .setMessage("some message") .setPositiveButton("OK", new DialogInterface.OnClickListener() { public void onClick(DialogInterface arg0, int arg1) { // Some stuff to do when ok got clicked } }) .setNegativeButton("cancel", new...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  3. Android: Function to let user take photo or choose existinghttps://www.joellipman.com/articles/else/app-dev/android-os/android-function-to-let-user-take-photo-or-choose-existing.html

    final int REQUEST_IMAGE_CAPTURE = 1; private static int RESULT_LOAD_IMAGE = 1; private static int TAKE_OR_PICK = 0; public void chooseOrTakePhoto(View view) { final View v = getLayoutInflater().inflate(R.layout.dialog_edititem_photo, null);...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  4. Android OS: Add GoogleMap as fragmenthttps://www.joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    .newCameraPosition(cameraPosition)); // Perform any camera updates here return v; } @Override public void onResume() { super.onResume(); mMapView.onResume(); } @Override public void onPause() { super.onPause(); mMapView.onPause(); } @Override public...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  5. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/component/content/article/basic-webpage-controls-with-javascript-com.html?catid=48&Itemid=165

    from the webpage. Now lets start controlling the webpage. Note - if the JavaScript doesn't end with a Method, use void 0. Focus on a Webpage Element - focus() Sets the focus to the Search for Keywords Input Box: Code: javascript:...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    (for this example I will leave this on "Default") and set the return type (again in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our example I am going to prefix it with "l_" (for list) and the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    didn't tell me much first time I ran it but I can use it later on to check if my "setting the notifications" process worked. void API.fn_eBayQuery_GetNotificationPreferences() { /* Function: fn_eBayQuery_GetNotificationPreferences() Purpose: Retrieves...

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

    and using since_id to not list the same one twice. It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // your shopify...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    The Deluge code for workflow /* ******************************************************************************* Function: void fn_AB_AssociateVacancy2Candidate(int p_CandidateID) Workflow: AB001: Associate Job Openings with Candidate Trigger: Workflow...

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

    invoice only generated on edit) Date Modified: 2023-03-29 (Joel Lipman) - If an eBay order comes through as cancelled, then void the sales order, void the invoice, delete the package and shipment. - Added chart of accounts lookup to set purchase account...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  11. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID = "12345678901"; r_PaymentTerms = invokeurl [ url...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. 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

    ZohoCreator called "zbooks". It has fullaccess as a scope but I'm sure you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /*...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    up with duplicate line items): /* ******************************************************************************* Function: void automation.fn_Quotes_OnEdit(int p_QuoteID) Label: Fn - Quotes - On Edit Trigger: Used in a workflow when a quote is modified...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  16. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    allow patents to restrict development and use of software on general-purpose computers, but in those that do, we wish to avoid the special danger that patents applied to a free program could make it effectively proprietary. To prevent this, the GPL...

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

    } } This next version is a more generic form of the above function uploading the photo to Shopify: void API.fn_ShopifyQuery_UploadPhoto(int p_ProductID, int p_Position, string p_ImageSrc) { m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-item-transaction.html

    Zoho Creator: Push to eBay Listings. Then you can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: int p_ItemID (eBay Item...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    step. STEP 4: THE REST A Zoho Flow would submit the request ID and document ID as part of a map to the following function: void fn_SignDataAndAttach(int v_RequestId, int v_DocumentId) { // // TLD as com or eu depending on whether you access zoho.com or...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    same as on the Shopify website. Included in this is the feature to export all the data as a CSV and to email it to myself: void API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 1 - 20 of 29