Hi all (and @Victor!) again
I have a “contact” database collection (name, phone number) and a “message” collection (number, message and relationship to “contact” collection).
Here’s what I’m trying to do:
An incoming text message (via Integromat) will contain a phone number and message. Integromat listens for incoming text and then creates an Adalo “message” record with the number and message fields.
Now what I want to do is show the contact name associated with the message. So a list of contact names where there is a message record. I need to lookup the contact record based on number field or add contact ID to “message” record.
Is this possible natively in Adalo, or is it possible to somehow do it in Integromat, but without having to get a list of all contacts into Integromat first (which would be a really long list every time).