When using the Table element to create Salesforce forms, you can use the simple table or the advanced table.
The “simple table” refers to the most basic table you can create for working with SF. It is not hierarchical - It has a single level, with which you can only “Read” data from SF, and you can do so from only one SF object.
In order to configure a simple table all you will need is to change the table’s “Basic” settings and set the “Get” integration.
The “Advanced table”, in comparison, is more powerful. It refers to a hierarchical table, that enables you to work with multiple SF objects. and allows you to “Read” from SF objects as well as “write” to SF objects.
Creating a simple table is easy - just follow these steps:
1- | Enter a new / your form in the form builder |
2- |
Drag a table element from “Elements” panel > Salesforce > Table |
3- |
|
4 |
Once selected, the table’s properties will open in the “Properties” panel (on the right side) |
5- | Change the default column values from Col1, Col2, Col3 to the SF object fields you would like to display in the table. For example: if you wish to display information from the “Account” SF object you could set the following columns: Account Name, Account Phone, Account Website. * Please notice that this table is “Flat”, it has no hierarchy and its columns can belong to only one SF object. |
6- |
You can, of course, add more columns, or remove columns according to your requirements. |
7- |
You can add a filter row to the table, just below the headers, to help the user search for specific data - by turning on the "Show filter" checkbox. |
8- |
|
9- |
make the style changes in the relevant categories. For example: Choose “Table” in the “Apply style to” dropdown, and specify a pale blue color in the background. |
10- |
All that is left to do now is to connect this table to the Salesforce object. Go to the “Properties” panel > “Form” tab > “Settings” > open the “Salesforce Integration” category * Notice that there are two sections here: the top one is “Push to Salesforce”, in which you configure the “writing” operations (creating, updating, upserting, deleting data in SF objects). and the bottom section is “Get from Salesforce”, in which you configure the “Reading” from Salesforce objects. Choose the in the “Get from Salesforce” section and press on the “Map Fields” button. |
|
|
12- |
|
13- |
Turn on the “execute on form load” checkbox - this will “pull” the data from SF and populate the table once the form is loading. |
14- | There is no need to set a condition in this case, however, we will choose to display “All” matches found. As well as limit the number of accounts we show to 200. |
15- |
|
16- |
|
17- |
|
18- |
|