Very new to Adalo but have been building our first 2 apps. I have a relationship field set up to the User Collection (see image). I have a Zap that should be populating the User Field with the User’s ID number (an 8-digit number). You can see that in the relationship, it allows me to select any of the users based on this 8-digit number, but the Zap shows that it’s putting it into the field but Adalo shows it as blank.
Is this an issue with the type of relationship and/or should I do this another way? I am populating this 8-digit User ID via a webhook so this is the only info I have (versus using the user’s email address). The 8-digit User ID should always exist because the user’s data gets populated FIRST before the webhook will trigger.
How your zap has been setuped? Screenshots? When updating the record’s relation through zap, you linked user’s ID which Adalo automatically gives right?
Appreciate the reply. I am trying to populate these two relational fields (red box). They both are relations to a list of users (8-digit user IDs) and classes/sessions (a 7-digit session IDs):
The Zap works by receiving the webhook and then creating the row in Adalo (fairly simple I imagine). The two red squares are the same two fields in Adalo that should be populating those same two fields. The blue square is the same number but populating a separate (text) registrant ID field (not necessarily needed).
We paid an Adalo developer upfront a small amount of money to help with another Adalo app, but he hasn’t responded to any of our messages after meeting once, otherwise I would ask them. They are listed on Adalo’s partners/experts. We are a non-profit so I’ve already spent our budget on trying to get a solution working and we basically have this entire app built out, but I’m just trying to figure out some of the quirks (without having any previous Adalo or development experience). I’ve been watching tons of Adalo videos and looking through the forums for solutions. Appreciate any feedback. Thank you!
Thanks for providing information buddy! Same as I thought. Now to get the data, you need to pass the ID which Adalo automatically gives. If you open the users collection in adalo data editor and scroll to the end you will see a number property along with create and update date properties. That’s the ID you should use when updating relations. So now since you have 8 digit ID, before this update action add a get action with a filter for the 8 digit ID and then on the update action, add user ID got from that action. Same goes for session.
Now Zapier doesn’t have inbuilt actions for get and it only has create and update. So what you can do is that use the web hooks action and setup the get request following the Adalo api docs for users and seeisons collections. You can click the three dots next to the collection name and click on api documentation. You need to be on a team plan or enterprise. If you create the user and session before this update action then you should get access to the created record ID.
Oh… That’s not good! So they did not build the app?
Thanks for the reply. I remember this Adalo ID/Zapier ID weird write back functionality. I didn’t know that this was the reason on the backend.
Here is a question though: Here is my setup, we are using Zapier Tables as well in this mix. I have the webhook collecting the data and creating the record in Zapier Tables (as well as do the updates/ deletes to the attendance record in Zapier Tables and Adalo).
Then I have a Zapier that waits for a New Record to be created in Zapier Tables, then it creates an Adalo Record, then writes back the Adalo ID back to the Zapier Table.
Then I have a Zap that waits for the Adalo ID record field to be update (i.e. created from the prior zap) and then uses that Adalo ID to go to Adalo and Update Record with the User ID and Session ID that I am having issues getting to populate.
However, this doesn’t seem to work. What step am I missing or do I have incorrect?
The developers were supposed to help with some of the logic (like this) that I am having a hard time figuring out. We prepaid for 10 hours of 1:1 development. I don’t want to mention their name yet because I’m hoping they will get back to my messages shortly. After the first 1:1 dev session, I remember him mentioning this AdaloID quirk, but for some reason it’s not working like I thought it was supposed to work.
Appreciate any help! I’m getting down to the crunch time trying to get this thing to work correctly.
