Search - Joel Lipman .Com

1. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... display related POs linked by a custom Sales Order lookup field on the Purchase Order line item. Inputs: salesorder Outputs: Related List Date Created: 2024-07-09 (Joel Lipman) ...; Created on 09 July 2024
2. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... (aka the Quote Builder) will need to post a new quote to the system as well as show previous orders. How? We're going to use the Zoho Extension SDK. You should refer to my previous linked article ...; Created on 14 March 2024
3. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived from an existing form (called "Document"). Mainly, because ...; Created on 26 January 2024
4. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... = ifnull(p_DownloadImageUrl,"https://joellipman.com/tmp/icon_linkedin.jpg"); v_FileName = v_ImageToDownload.subString(v_ImageToDownload.lastIndexOf("/") + 1); // // get file object f_File = invokeurl [ url ...; Created on 05 December 2023
5. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ---------------------- QUOTE LINKED POTENTIAL/OPPORTUNITY ---------------------- if(!isnull(r_QuoteDetails.get("Deal_Name"))) { m_CreateEstimate.put("zcrm_potential_id",r_QuoteDetails.get("Deal_Name").get("id").toLong()); } // // ...; Created on 18 September 2023
6. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = r_Result.get("ID"); m_DataRow = Map(); m_LinkedValue = Map(); m_LinkedValue.put("value",r_Result.get("Quote_Name")); m_LinkedValue.put("isExternal",true); m_LinkedValue.put("link","https://app.zohocreator.eu/"+v_OwnerName+"/"+v_AppLinkName+"/"+v_FormLinkName+"/record-edit/"+v_ViewLinkName+"/"+v_CreatorQuoteID+"?param1=my_param_value"); v_DateTill ...; Created on 30 July 2021
7. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... - USE ARROW KEYS OR MOUSE): As you can see from the screenshot above, there are modules concatenated with one module an "X" and then the name of the linked module. A module called "Opportunities_X_Products" ...; Created on 28 April 2021
8. List of Font Awesome: / Web-Development /; ... folder (my preference) and add the linked stylesheet in the head section of your webpage. I'm selective of what icons I copy over but the full directory can be found at https://github.com/FortAwesome/Font-Awesome: ...; Created on 04 September 2015
9. SSRS Subscriptions cannot be created: / SQL Server Reporting Services /; ... because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How? I'd like to say that the solution is far more complicated then this, but ...; Created on 22 November 2013
10. Problem creating SSRS report subscriptions: / SQL Server Reporting Services /; ... webpage Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. Why? The problem happens because of ...; Created on 11 November 2013
11. Delete related records from multiple tables: / MySQL /; ... Deletes all sessions dated after February 1st 2013 -- and all related records (linked by ID) in relevant tables. Delete from specific tables but not all Simply don't refer to the table after the ...; Created on 11 January 2013
12. Excel PivotTable Filter List Ordering: / Excel /; So I googled this for a while and there are a lot of solutions out there, none of which applied to what we meant and lots of people in the same boat. The Situation We have an Excel report which ...; Created on 05 September 2011
13. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... (request reference) number. The Report We start off with our detailed report page which lists all the details of a student. There is a textbox linked to an action which will open another report ...; Created on 02 September 2011
14. SSRS Redirect after a report is run: / SQL Server Reporting Services /; ... an overview of some: Method #1 Create one report with all selectable reports as subreports - toggle visibilty based on parameter. Method #2 Add a button below "View Report" linked to some ...; Created on 12 August 2011
15. Win32 Constants: / AutoHotkey /; ... Objects can be moved Const SFGAO_CANLINK = DROPEFFECT_LINK ;// Objects can be linked Const SFGAO_CANRENAME = $00000010 ;// Objects can be renamed Const SFGAO_CANDELETE = $00000020 ;// ...; Created on 05 July 2011
16. Migrate Joomla! 1.5.x to 2.5.x+: / Joomla /; ... a new user in your users table. The user who originally was assigned -- that ID will be moved to the end of the list and any associated content -- and events will be re-linked to ...; Created on 30 January 2011
17. SQL Calendar in Business Intelligence Development Studio: / Transact-SQL /; ... we would like this linked to events in a database. I'm calling this project "Reinventing the Wheel" because the request was a report that was similar to an MS Outlook calendar which will display any ...; Created on 14 January 2011
18. Terms & Conditions: / Static Items /; ... have no responsibility for the content of the linked website(s). You may not create a link to this website from another website or document without [business name]'s prior written consent. Your ...; Created on 30 May 2009
19. Licence GNU/GPL: / Static Items /; ... associated with source files for the work, and the source code for shared libraries and dynamically linked subprograms that the work is specifically designed to require, such as by intimate data communication ...; Created on 03 April 2009
20. Icons: Created on 22 October 2015