Using Salesforce SOQL Datatable with Click-to-Call Functionality

The Salesforce SOQL Datatable is a powerful tool for displaying Salesforce data in a dynamic, interactive table using SOQL queries. It simplifies data visualization and allows users to view, sort, and filter records easily.

When paired with Click-to-Call functionality, it becomes even more efficient by enabling users to initiate calls directly from the datatable with a single click. This integration is ideal for sales and customer service teams, streamlining communication and improving productivity within Salesforce.

Click-to-Call in Salesforce refers to a feature that allows users to initiate phone calls directly from a Salesforce record by clicking on a phone number field. It’s often used in conjunction with a phone system or integration (like Salesforce CTI) that connects Salesforce to a VoIP or telephony service.

When using Click-to-Call in an SOQL Datatable within Salesforce, this feature enables you to:

1. Display Clickable Phone Numbers: Phone numbers retrieved through the SOQL query in the datatable are rendered as clickable links.
2. Initiate Calls Seamlessly: Clicking a phone number triggers a call through the integrated telephony service, like Salesforce’s Open CTI or other call integrations.

Build a datatable that displays key fields like phone numbers, contact names, and other essential details for client interactions.

Use a SOQL query to retrieve the necessary data, ensuring call-related fields are clearly visible for easy access.

To do this, you’ll need to create a Lightning Web Component project with an HTML file, a Javascript file and an XML file to build the component.

The HTML file will display a lightning-datatable with columns for contact fields and include a button for initiating the call.

The JS file will fetch contacts using a wired Apex method and handle button clicks to initiate a phone call via the tel protocol.

The XML file will mark the component as usable in App Builder pages.

You’ll also need to create an Apex class in the Developer Console to provide contact data using an SOQL query.

After building your component, deploy it to your org to be able to add it in the Page Builder.

Go to the Lightning App Builder of your page and find your Lightning Web Component.

Drag and drop it to the section you desire.

Save your page and activate the page by assigning it as Org Default.

Once added to your page, conduct test calls from various records to verify that the Click-to-Call feature works without issues. Ensure phone number formats are compatible.

By following these steps, you ensure a seamless setup of Click-to-Call functionality in your Lightning SOQL Datatable.