This is pretty urgent, please help! I have a webhook with a text input and I have a database collection with related records in another collection. I would like to put the following in my webhook text input: the text of the current record, and then the text of all of it’s related records (sort of like a list). It would all be just one text in the input for the webhook. Is that possible? Or any ideas? Thanks in advance!
Unfortunately, there is no easy way to do this in Adalo. I’d say, there is even no hard way to do this
In theory, this could be done with the help of Integromat + Airtable:
you copy items for aggregation to “proxy” table in Airtable
you select these items in Integromat from this “proxy” table, with the desired sorting
you aggregate the items in Integroma
and then return back the result.
It could be done without Airtable (using Integromat’s Data Store), but as datastores are limited I’d avoid doing that.
Also you can do “list Adalo records” + filter after list directly from Integromat, but I’m not sure what will happen if there are a lot of records.