Skip to main content

Pre-fill tables from Salesforce

Y
Written by Yuliia Biletska
Updated over 2 months ago

This is a paid bot, and its usage will be counted toward your plan's credit limit. For more information about credit usage, refer to this article.

Note: Ensure your document includes a table, or you won't be able to configure the bot.

General

Automatically populate document tables with multi-row data from Salesforce.

Use case: you need to finalize a sales deal by using this bot to populate a quote with product details (name, code, quantity, price) from Salesforce Opportunity Product records.

How to set up

To add the bot:

1. In the step settings, select Add bot or click the plus icon after a specific action.

2. Choose Bot and search for the Pre-fill tables from Salesforce bot.

3. Click on the bot to install it.

Trigger

A trigger is an event that causes the bot to start working. The moment of the bot's activation depends on its placement in the flow:

  • If the bot is added after a step or any other element, it will run once that element finishes its job.

  • If within the step, the bot will run based on the trigger you specify. Choose the trigger type most relevant to your case:

According to this, select the bot's trigger type that will be most relevant to your case:

Trigger type

Description

Step started

The bot activates when you start the workflow

Document opened

The bot activates when signers start filling out the documents or switch between them.

Field changed

Use for cases where a response or action is needed immediately after a user enters or updates information in the specific field. Select the document and the field that the bot should pay attention to complete the setup.

Document completed

The bot activates once the signer completes a document you specify in the trigger settings.

Connection settings

In Source, select and connect your Salesforce account.

To add a new connection, choose a Salesforce instance (Production, Sandbox, or custom domain).

Select a base object in Salesforce (for example, Opportunity Product) as the source for pre-filling document table fields.

Lookup

In Find record, set rules to locate the Salesforce source record:

  • Sent by the airSlate Workflow integration app: The system auto-defines the record ID.

Tip: Use this option only if the process starts from the Salesforce record you want to pre-fill data from. For example, Opportunity is the base record, and the workflow starts from Opportunity as well.

  • By bot lookup: Match document fields to record fields or custom values, like matching Opportunity ID.

Tip: This option can be used for workflows started outside or from Salesforce with different starting records. For example, if Opportunity Product is the base record but the workflow starts from the Opportunity record.

Mapping

In Data mapping, select Map fields. Drag and drop Salesforce fields onto document table fields to show the bot to show the bot where to populate the Salesforce values. Blue highlights show available fields. Mapped field names appear on the canvas.

To add new fields, select Edit document.

To cancel mapping, hover over the connected field name and select Unmap, or click the corresponding icon next to the mapped field in the document.

Testing

In the Test section, check how the bot works by selecting Test. You will see a success message if everything is set up correctly. If there are issues, review the connection, mapping, or trigger configuration.


If you skip testing by selecting Skip testing, you may miss issues with the bot setup. Testing is recommended to ensure everything works as expected.

  • Enter the ID of the record from which the document table should be pre-filled, but only if the starting record matches the base record.

Note: To find the Salesforce record ID, go to the specific record and copy the ID from the URL.

  • Enter the matching value (like Opportunity ID) if you have set up a lookup for your workflow.

Conditions

Set conditions to control when the bot activates, tailoring it to your specific needs for more efficient automation. For detailed guidance, refer to this article.

Without defined conditions, the bot will default to activating whenever recipients complete the documents or the previous element (for example, another bot) finishes its job.

Best practice: If you configured the lookup to locate the Airtable record, set conditions to ensure the lookup field is not empty.

Advanced settings

This section allows you to choose how the process proceeds in case the bot fails:

  • Select Proceed to allow the workflow to move to the next signer and automation if the bot isn't crucial.

  • Select Stop if the bot is critical; this prevents the next signer from receiving documents if data wasn't pre-filled from the source of your choice.

Did this answer your question?