Hi,I am new to this so please let me know if I miss any crit info. In Adalo :A simple restaurant app. Menu has multiple items. There are two collections. One called ORDER and other called ITEMS. ORDER collection has a relationship to another table called “ITEMS”. When an order is placed, a new recods is created which has name of all ITEMS that were ordered. This is working fine in Adalo. In Zapier :Connection to Adalo app is working fine. I am able to send emails on the trigger I want But the value for ITEMS is not fetched when ORDER record is fetched. That value comes as NO DATA. Any ideas?

Question

Adalo Relationship values are not being fetched. Shows NO DATA when composing email body.

Forum|Forum|1 year ago
November 20, 2024
3 replies
16 views

C

Chanderjeet
New

Hi,

I am new to this so please let me know if I miss any crit info.

In Adalo :

A simple restaurant app. Menu has multiple items. There are two collections. One called ORDER and other called ITEMS.
ORDER collection has a relationship to another table called “ITEMS”. When an order is placed, a new recods is created which has name of all ITEMS that were ordered.
This is working fine in Adalo.

In Zapier :

Connection to Adalo app is working fine.
I am able to send emails on the trigger I want
But the value for ITEMS is not fetched when ORDER record is fetched. That value comes as NO DATA.

Any ideas?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+6

JammerS
Zapier Staff
Forum|Forum|1 year ago
November 21, 2024

Hi @Chanderjeet,

Welcome to the Community.

The issue may be due to how relational data is handled in Adalo and Zapier. When a new order record is created, related data from the items collection may not be fetched automatically. To resolve this, ensure the relationship between order and items is correctly set up as "Many to Many" in Adal. Use a "Find Record" action in Zapier to look up the related items. Also, check that the items field is mapped correctly in Zapier. If the issue persists, contact Adalo support for additional inputs.

I hope this helps. Let me know if you have any other questions.

C