This bot is available for free, and its usage does not consume credits. For more information about credit usage, refer to this article.
General
The Pre-fill table with custom values bot simplifies the task of populating tables in your documents with predefined values. Whether you're streamlining data entry or ensuring consistency across documents, this bot automates the process, saving you time and effort.
Use case: Imagine you're managing a sales team, and you frequently send out sales reports containing tables with standardized information like product names, prices, and quantities sold. Instead of manually entering this data each time, you can employ the Pre-fill table with custom values bot to automate the process.
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 the Pre-fill table with custom values bot in the Process bot category or use the search bar to locate the one.
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. |
Action settings:
In the Fields section, select the document and the table column which you want to be pre-filled.
Set a value that will be pre-filled into the table cells in the column by selecting one of the item types:
Fixed: Assign a static, unchanging name of your choice. For instance, you could set a name like "Project Report"
Signer details: pre-fill the field with details from the signer, such as their name or email address.
Document field: automatically fill the field with data that the signer has already provided in another part of the document.
Date and time: insert the date, time, year etc. when the document is being filled out or signed.
Compound: Combine static text with dynamic data variables. For example, you can create a name using the "@" symbol followed by selecting from available data variables , example- Invoice_@{Document Number}
Note: Special symbols like: @#$ cannot be used for the pre-filling.
Enter the custom values that should be prefilled into the table cells in the column. If you want several cells to be pre-filled with the values, enter each value from a new line.
To add more columns for pre-filling, select Add field.
Testing
In the Test section, simulate the bot's performance by selecting Test. A green success message confirms proper configuration. Any errors will be displayed as an error message.
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 pre-fill the table according to the selected trigger.
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.