Connecting a module to an existing table or a new table
Connect a target database to a module from a source database to sync exposed data
To connect a module – option to create new table
When you connect a module for the first time, all fields you map through the module interface are added to a new table by default. Choose Create new table if your existing tables don't contain any business logic yet, or if you want to rebuild some or all of your current business logic.
- From workspace home, click the card of the target database.
- Toggle on Edit mode.
- Click the Connect module card.
- Select a module in the Connect module dialog.
- Click the Next button.
- In the dialog, select a table or page from the menu, then select all fields you want to connect.
- Keep Create new table selected (this is the default when you connect a module for the first time).
- Click the Connect button.
- The dialog disappears and, if the connection is successful, the message Connected modules updated is briefly displayed in the upper right corner of your screen.
To connect a module – option to map to existing table
If you already have existing tables with working business logic—and you don't want to overwrite your current field names—choose Map to existing table.
For example, if you already have an Employees table and your workflows and formulas rely on the current field names, you probably don't want to create a new table and rebuild everything. In that case, mapping the module fields to your existing table lets you bring in the new data without disrupting what's already set up.
- In the dialog, select Map to existing table.
- In the upper-right corner, select the Data source (the source database that provides the module interface).
- Select the target table or page you want to map the module fields to.
- For each field on the left, use Map to field to select the corresponding field in your existing table on the right.
- Click the Connect button.
- The dialog disappears and, if the connection is successful, the message Connected modules updated is briefly displayed in the upper right corner of your screen.