Published Articles

List of articles I have written over the years (since 2009)

I started writing articles back in 2009, over 15 years ago, when I joined Salesforce as a developer support agent in a Word document shared with my team. In 2012, I created my website using Visualforce and then Aura components. In 2016, I decided to make those articles on LinkedIn, and at the end of 2023, I moved to Medium.com. You can read the full story here.

Below is the updated list of all the articles I have written over the years.

Medium

(ELTORO . IT) Andres Perez - Medium

(ELTORO.it) Andres Perez

Data Cloud -- Other

View list

19 stories

(ELTORO.it) Andres Perez

Data Cloud -- Case Study: How could FIFA use Data Cloud?

View list

22 stories

(ELTORO.it) Andres Perez

Integration Certification

View list

10 stories

(ELTORO.it) Andres Perez

Salesforce General

View list

11 stories

Older Articles Published In Medium

• Hello World (Dec 29, 2023)
• The Perfect SFDX Starter Project For Any Scratch Orgs Development (Feb 24, 2020)
• Asynchronous JavaScript using Salesforce Lightning Web Components (LWC). (Fb 7, 2020)
• ETQR: A QR Code Generator And Scanner Written Using Salesforce’s Lightning Web Components (Dec 17, 2019)
• Tutorial: Learn How To Use The New Lightning Web Components Open Source (LWC OSS) (Jul 24, 2019)
• Lightning Web Components Support Lightning Out. (Jun 13, 2019)
• Lightning Out + Visualforce/Node.js + LWC/Aura (Jun 12, 2019)
• ETCopyData: SFDX Plugin to copy data between orgs. (Dec 1, 2018)
• Get hands-on with Salesforce DX — Take the Emerging Tech for Developers bootcamp at TrailheaDX ’18. (Jan 12, 2018)

LinkedIn Articles

1. Data Cloud Development — Chapter 2: Accessing Data Cloud Data Via Api (Postman) (December 28, 2023)
2. Data Cloud Development — Chapter 1: LWC & Apex In Data Cloud Org (Same Org) (December 26, 2023)
3. Salesforce’s Data Cloud Segmentation (December 21, 2023)
4. Preparing CSV Files In AWS S3 To Ingest By Data Cloud (December 11, 2023)
5. Software Development Evolution, From Eniac to EinsteinGPT. (December 6, 2023)
6. EinsteinGPT For Developers: How To Use It? How not to use it? (November 20, 2023)
7. ChatGPT vs. Perplexity.ai (June 8, 2023)
8. A SQL Developer’s Guide to Working with SOQL and the relationship queries (April 30, 2023)
9. Do you remember PONG? (May 27, 2022)
10. Digital Badge Using Microcontrollers — Can JavaScript do that? (March 26, 2022)
11. Salesforce OAuth Flows (March 16, 2022)
12. JavaScript Asynchronous Loops (September 20, 2021)
13. Pulse Width Modulation (PWM) on a Raspberry Pi using Node.js (June 5, 2021)
14. So, What is the Event Loop? (December 22, 2020)
15. The Perfect SFDX Starter Project For Any Scratch Orgs Development [Updated for Summer ’20] (August 1, 2020)
16. Understand JavaScript Array Functions Using Emojis (June 20, 2020)
17. Certification Days Workshop (May 13, 2020)
18. Order Of Execution, Apex Transactions, and Governor Limits (April 26, 2020)
19. (Near) Real-Time Salesforce Applications (February 24, 2020)
20. The Perfect SFDX Starter Project For Any Scratch Orgs Development (February 11, 2020)
21. Asynchronous JavaScript using Salesforce Lightning Web Components (LWC) (February 7, 2020)
22. ETQR: A QR Code Generator And Scanner Written Using Salesforce’s Lightning Web Components (December 17, 2019)
23. Free Tutorial: Learn How To Use The New Lightning Web Components Open Source (LWC OSS / lwc.dev) (November 30, 2019)
24. Do You Want To Understand How To Use The New Lightning Web Components Open Source? (July 24, 2019)
25. Lightning Web Components Support Lightning Out — Explained! (June 13, 2019)
26. ETCopyData: SFDX Plugin to copy data between orgs. (December 1, 2018)
27. Do you want to “really” understand Salesforce DX? (January 12, 2018)
28. ETLC_ApexBridge: Design pattern, and companion library, for communication between Lightning Components and Apex. (April 8, 2017)
29. ETLC_Events: Communication Between Lightning Components (August 23, 2016)
30. ETLC_ApexBridge: Lightning Components Communicating With Apex Design Pattern (July 12, 2016)
31. ETLC_SecureDB: Lightning Components Secured Data Access Helper (May 1, 2016)
32. Siri learns Lightning Components: Hello World (March 25, 2016)

ELTORO.IT Articles

1. ETLC_SecureDB: Lightning Components Secured Data Access Helper (May 1, 2016)
2. Siri Learns Lightning Components. Session #1 — HelloWorld (March 27, 2016)
3. How To Prepare Your ORG For Lightning Components Framework? (February 16, 2016)
4. What’s Lightning? (February 8, 2016)
5. Salesforce Security, What Every Developer Must Know. (January 31, 2016)
6. Make Long-Running Callouts from Visualforce pages using the Continuation pattern (January 19, 2016)
7. Salesforce Relationships (January 8, 2016)
8. SOQL / DML / Loops Performance (December 28, 2015)
9. Apex Collections (December 17, 2015)
10. Salesforce1 Demo: Building an Expense Tracker (December 6, 2015)
11. HTML5 Applications for iPhone Mobile Devices using Visualforce (November 25, 2015)
12. Working With Related Objects (November 13, 2015)
13. Force.com IDE v28 deployment error: Cannot deploy InstalledPackage (November 2, 2015)
14. What is a variable? Are they passed By Value or By Reference? (October 22, 2015)
15. Prevent automatic calendar pop-up (October 11, 2015)
16. AR WE RUShD? (September 30, 2015)
17. DML: Standalone Statements or Database Methods Which One to Use? (September 19, 2015)
18. Visualforce Security (September 8, 2015)
19. Standard Images (August 27, 2015)
20. Nice “Please Wait” message (uses Apex:actionStatus tag) (August 16, 2015)
21. apex:actionRegion (August 5, 2015)
22. Dynamic Apex to check CRUD and FLS (July 25, 2015)
23. Properties Vs. Getter/Setter Methods (July 14, 2015)
24. Test coverage for SOAP and REST Webservice callouts. (July 3, 2015)
25. How to skip Validation Rules when submitting a form? (June 22, 2015)
26. Multi-row: Editing Multiple Records At The Same Time (June 10, 2015)
27. Formatting DATES inside VisualForce (May 30, 2015)
28. Hiding the label for an inputField (May 19, 2015)
29. What are the standard available Style classes that can be used? (May 8, 2015)
30. Show an image while the page is loading (April 27, 2015)
31. JavaScript dependent pick lists… (April 16, 2015)
32. Formating Page Created using <apex:page RenderAs=”PDF”> (April 4, 2015)
33. API access with no password expiration (March 24, 2015)
34. Assignment Rules Using APEX (March 13, 2015)
35. URLFOR() explained (March 2, 2015)
36. apex:inputCheckBox OnChange vs. OnClick Events (February 19, 2015)
37. Different Document Types (February 8, 2015)
38. Visualforce Templating (January 28, 2015)
39. Functions for Encoding (January 16, 2015)
40. LINK: Examples of Advanced Formula Fields (January 5, 2015)
41. Dynamic Apex: Sample using Schema Describe, Dynamic SOQL and Dynamic DML (December 25, 2014)
42. How to find out who deleted the record? (December 14, 2014)
43. How to test triggers? (December 3, 2014)
44. SOQL Filter by Date/DateTime field. (November 22, 2014)
45. Initialization structures in Apex (November 11, 2014)
46. API using AJAX Toolkit in VisualForce pages via JavaScript (October 30, 2014)
47. Launching Local Application From Browser (October 19, 2014)
48. Javascript Show Characters remaining (length of input text typed) (October 8, 2014)
49. apex:tab setting styles (September 27, 2014)
50. Sending Emails From an Apex Trigger Using a VisualForce template. (September 16, 2014)
51. How To Work With Aggregate Queries? (September 5, 2014)
52. Which Trigger Event Am I processing? (August 25, 2014)
53. Displaying Errors in VisualForce page, using yellow background box. (August 13, 2014)
54. Setting css styles for apex:column’s header in apex:pageBlockTable (August 2, 2014)
55. Label in Apex/VisualForce to use user’s Language. (July 22, 2014)
56. Display the Visualforce page or Page Layout Based on the User’s Profile (July 11, 2014)
57. Detecting JavaScript Event for apex:inputField when it’s a Lookup Field (June 30, 2014)
58. Blobs, Strings, Encoding, … (June 19, 2014)
59. VF email templates with images (June 7, 2014)
60. Using Dynamic Apex to read the picklist values and populate an apex:selectList (May 27, 2014)
61. How to convert timestamps between Salesforce and Excel? (May 16, 2014)
62. How to write a list of multiple radio buttons? (May 5, 2014)
63. Portal Account Sharing. (April 24, 2014)
64. One VisualForce that can be rendered as PDF or HTML. (April 13, 2014)
65. SOAP API Sample, Includes Metadata API (April 2, 2014)
66. Buttons on columns of the related records (standard page layout)… (March 21, 2014)
67. MailMerge code. (March 10, 2014)
68. How do I convert an ID from 15 to 18 characters? (February 27, 2014)
69. Webservices integration, using certificates to increase security (SSL). (February 16, 2014)
70. Crypto Code (February 5, 2014)
71. Implementing Site.UrlRewriter for Force.com Sites (January 25, 2014)
72. Displaying CRM Content in VisualForce (January 14, 2014)
73. VisualForce Counter Using apex:Variable (January 2, 2014)
74. System.LimitException: DML currently not allowed (December 22, 2013)
75. How to know how much time until timeout window shows up. (December 11, 2013)
76. How to work with Dynamic Apex methods and data types? (November 30, 2013)
77. Dynamic SOQL to Query Every Field (SELECT * FROM Account) (November 19, 2013)
78. Write-once data (November 8, 2013)
79. Using CSS Styles (October 28, 2013)
80. Create Excel files with multiple tabs (October 16, 2013)
81. Sending Outlook calendar invites from Apex (October 5, 2013)
82. VisualForce in sidebar (September 24, 2013)
83. CRM Content — how to find the most downloaded documents? (September 13, 2013)
84. Animation… Waiting. (September 2, 2013)
85. Linefeeds in email text templates. (August 22, 2013)
86. Visualforce page embedded in a Page Layout with target=_top (August 10, 2013)
87. CRM Content creation. (July 30, 2013)
88. ConcurrentPerOrgApex Limit exceeded (July 19, 2013)
89. Select RecordType in VisualForce (July 8, 2013)
90. Multi-row: Paging using StandardSetController (June 27, 2013)
91. Page Layout To VisualForce Convertor Tools (June 16, 2013)
92. Apex and multi-picklist fields (June 5, 2013)
93. Trigger for Lead conversion (May 24, 2013)
94. Multi-row: Avoid using an inner class to view/edit records I (May 13, 2013)
95. Navigate to anchors (Sections in pages, (May 2, 2013)
96. Dynamically showing or hiding sections in VisualForce page. (April 21, 2013)
97. Skipping code during unit tests (April 10, 2013)
98. VisualForce Email Template On Tasks Showing Related Data (WhatID). (March 30, 2013)
99. Javascript onChange event For An apex:selectList (March 19, 2013)
100. Multi-row: Avoid using an inner class to view/edit records II (March 7, 2013)
101. VisualForce can access data in a map directly (February 24, 2013)
102. Update SelfServiceUser object from Apex Code (February 13, 2013)
103. iframe cross domain (February 2, 2013)
104. VisualForce Extension test methods (January 22, 2013)
105. Custom Button to set a field in Standard Page Layout. (January 11, 2013)
106. How to invoke an Apex Webservice from C# (December 31, 2012)
107. How often can I schedule an Apex class? (December 19, 2012)
108. Passing parameters from Visualforce page to Apex controller via apex:param (December 8, 2012)
109. Using an Iterator Scope definition in Batch. (November 27, 2012)
110. RecordSet — Setting the views, Page Size/Show More. (November 16, 2012)
111. Render conditionally on Date field being null. (November 5, 2012)
112. VisualForce InputField for DateTime (simulation). (October 25, 2012)
113. Multiselect Picklists (October 13, 2012)
114. SOQL Queries (October 2, 2012)
115. Multi-row: Wrapper class with multi-select picklists (September 21, 2012)
116. Do not hard code RecordType (September 10, 2012)
117. Approvals — How to Submit, Accept, and Reject records (August 30, 2012)
118. Using the HTTP Headers (Client Variables) for Visualforce pages (August 19, 2012)
119. How to have a Visualforce page costantly refreshing? (August 8, 2012)
120. Only members of a profile can save data (July 27, 2012)
121. Maximum view state limit (135KB) exceeded exceeded with apex:inputFile (July 16, 2012)
122. Find Salesforce server where instance is running… (July 5, 2012)
123. Formatting Numbers inside VisualForce (June 24, 2012)
124. Special Related Lists (June 13, 2012)
125. Printing Formated Current Time and/or Date (June 2, 2012)
126. What browser is the user running? (IE, Firefox, Chrome, Safari, …) (May 22, 2012)
127. Passing Parameters Between VF Pages (May 10, 2012)
128. Passing values to a VisualForce page (April 29, 2012)
129. Formatting numbers inside Apex (April 18, 2012)
130. Multi-row: Edit rows using apex:inputfield (April 7, 2012)
131. How to show the standard page for an overriden page? (March 27, 2012)
132. How to show sections of the page on mouse over, and hide them on mouse out? (March 16, 2012)
133. How to check for boolean variables in Lightning Components?
134. Calling Salesforce APIs From Lightning Components
135. ETLC_Events: Communication Between Lightning Components
136. ETLC_ApexBridge
137. To Space or not to Space?

Old Medium Articles

These were some old articles that I also published in LinkedIn when I transitioned to that platform.

1. Pulse Width Modulation (PWM) on a Raspberry Pi using Node.js (Jun 5, 2021)
2. (Near) Real-Time Salesforce Applications (Feb 24, 2020)
3. The Perfect SFDX Starter Project For Any Scratch Orgs Development (Feb 24, 2020)
4. Asynchronous JavaScript using Salesforce Lightning Web Components (LWC) (Feb 7, 2020)
5. ETQR: A QR Code Generator And Scanner Written Using Salesforce’s Lightning Web Components (Dec 17, 2019)
6. Tutorial: Learn How To Use The New Lightning Web Components Open Source (LWC OSS) (Jul 24, 2019)
7. Lightning Web Components Support Lightning Out (Jun 13, 2019)
8. Lightning Out + Visualforce/Node.js + LWC/Aura (Jun 12, 2019)
9. ETCopyData: SFDX Plugin to copy data between orgs (Dec 1, 2018)
10. Get hands-on with Salesforce DX — Take the Emerging Tech for Developers bootcamp at TrailheaDX ’18. (Jan 12, 2018)