Search - Joel Lipman .Com

1. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
2. Zoho Creator: Copy Subform to other Subforms: / Zoho /; What? A quick article on a snippet of code which copies one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries ...; Created on 17 November 2021
3. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
4. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = m_Node.get("updatedAt"); // // transforms if(v_ProductTitle.contains(",")) { v_ProductTitle = "\"" + v_ProductTitle + "\""; } if(v_ProductHandle.contains(",")) { v_ProductHandl ...; Created on 20 February 2023
5. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
6. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... if I encounter any. This is simply how I fixed this error on this occasion. Consider the following code which loops through some Creator records, then loops through one of the subforms in each record: // ...; Created on 17 November 2021
7. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...; Created on 19 September 2021
8. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... transforms if(r_Result.get("Valid_Till") != null) { v_DateTill = r_Result.get("Valid_Until").toDate().toString("dd/MM/yyyy"); } if(v_QuoteTotal != 0) { v_QuoteTotalGBP = (v_QuoteTotal.toDecimal() ...; Created on 30 July 2021
9. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... and would get the following response when attempting: { "response": { "message": "Error occurred", "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7013, ...; Created on 10 December 2020
10. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... to ensure it's all saved in the system. Create the workflow Now go to a the "Design" mode of the report that contains the forms you want to be able to merge (multiple selection) and click on the "Actions ...; Created on 06 December 2020
11. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... and export using URL - Export a record template as PDF Zoho Creator v4 - Style based URLs for Embedded forms - Loading forms/reports without headers/functionality, Zoho Creator v4 - Navigational URLs ...; Created on 06 November 2020
12. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; ... item and filtering the options available for selection. Why? This was for a multi lookup with staff as the list entries. The lookup needed to filter against various forms such as Staff Rotas, Leave ...; Created on 28 June 2019
13. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; ... I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx = "^[A-Za-z0-9._-]+@[A-Za-z0-9._-]+\.[A-Za-z]$"; v_MyString ...; Created on 31 May 2019
14. Foreign Characters create symbols in PHP and MySQL: / Personal Home Page /; ... Ensure all text fields in the database are set to a UTF-8 charset (eg. utf8_general_ci) Ensure headers are setting the charset to UTF-8 Add the charset attribute to posting HTML forms: accept-charset="utf-8" ...; Created on 25 January 2016
15. Android: Replace return key with done, go, send...: / AndroidOS /; ... IME_ACTION_DONE // the action key performs a "done" operation, typically meaning there is nothing more to input and the IME will be closed. IME_ACTION_GO // the action key performs ...; Created on 03 November 2014
16. ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2: / Joomla /; ... \administrator\components\com_jcomments\models\forms\settings.xml (line 398) Replace the line KCAPTCHA With this KCAPTCHA PLAYTHRU STEP #4: ...; Created on 27 April 2014
17. Creating a custom form field type for Joomla XML fieldset: / Joomla /; What? I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom ...; Created on 25 October 2013
18. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... = "JL - to Mixed case" , Description = "Transforms selected text fields to Mixed case" , ComponentType = ComponentType.Transform)] public class MyConvertToProperTransform ...; Created on 04 October 2013
19. Leap Motion and AR Drone: / Quadcopters /; ... you like @ https://www.leapmotion.com/). It's noted for it's accuracy and response to finger gestures and it's compatibility with major platforms. The following videos were shown to me by a colleague ...; Created on 17 May 2013
20. Improve Default Joomla Search: / Joomla /; ... like the search term. Levenshtein: Allows for typos and matches to words that are 1 or 2 letters mistyped. Grammar: Account for singular/plural, past/present, and noun/adjective/verb forms. Referencing: ...; Created on 07 May 2013