I am using Integromat to extract data from Adalo. Within my adalo database, some line items are data collections and they’re showing up as numerical values instead of their actual text value. Is there a way to translate it back to the actual value?
To get the values for these records, you will have to:
add connection(s) to desired collection(s) in Integromat - e.g. Category, Sub-Category, User
add a “Get Record” operation after the current module
and use the 1st value of the array (e.g. Category[1]) as a RecordID.
To save credits and improve scenario speed, sometimes I add a text property to the original collection and copy the value from a related collection. But this depends on the exact app setup.