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.
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).
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.
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: