Get started
Get started

Lookups

Intelastel uses ‘Lookups’ in Entity Attributes to retrieve specific values from existing/predefined tables.

These are the equivalent of Foreign Keys in database management systems.

What are Foreign Keys?

A foreign key is just a set of attributes in a column of a table that refer to another (primary) set of attributes in a column in a different table.

The column in the first table is called the Primary Key, and the related attribute in the second table is called the Foreign Key.

It is possible to have more than one foreign key. This is to say that it is possible to create multiple foreign keys in multiple tables. These keys must have a structured relationship to each other, and to the Primary Key(s).

Why would you need to use multiple foreign keys / lookups?

In terms of managing your data in your Intelastel application, having multiple lookups (foreign keys) means that you can configure an Event to select/update/create/delete information in/from more than one table at once.

This is done in a way that preserves the data integrity between the tables.


How to Create or Update a Lookup Value Using Integromat

To Create or Update an attribute value in an Intelastel Application using Integromat, you need to use the ID of the record in the destination table, for the field that you would like to update.

Assuming you already have imported data using Integromat (from an Excel or Google sheet, for example) you will be able to create and update these values:

  1. First, you’ll need to look up the relevant value in a table, using Integromat. To do this you’ll need to create an Intelastel Search By… module, and connect it to your scenario.
  2. Run the scenario once, then view the output of the Intelastel Search By… module to see the bundles it generates.
  3. You now need to see how the values are mapped – consider the order of the data in your spreadsheet; the first row will likely contain the headings, then your second row will contain entries and so on. Look at the output of your Intelastel Search By… module.
  4. If you expand the bundles in the output of the module you will see that your data is in the same order as in your spreadsheet.
  5. You’ll find that each of your records in the bundle has an associated ID – a 7 digit number. This is in effect the foreign key.
  6. You can then map or reference this value in a different module in Integromat, for example in an Intelastel Create Entity Value module.
  7. Once this is set up, you will then be able to use the Lookup in your Intelastel application.
Back to tutorials

Share this