# Zapier Record ID "not available through Adalo" **URL:** \ **Category:** Get Help\ **Created:** [March 30, 2020, 5:41pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491 "2020-03-30T17:41:57Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Eli](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/eli/32/707_2.png) [@Eli](https://forum.adalo.com/u/Eli)\ **Post date:** [March 30, 2020, 5:41pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/1 "2020-03-30T17:41:57Z")
![zapiernewrecordid](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/1X/f624253027d3ae3cab011b124f2d4777417d8899.png) I have been able to set up two zaps so far: new record from airtable pushed to adalo, new record from adalo pushed to airtable I’m trying to create a zap to “Update Record in Adalo” (Action) by creating a new record in Airtable (trigger.) The 2 previous zaps did not require a “Record ID” from Adalo. But the “update” action does need the Record ID. “That can be obtained from a New Record zap, but is not available through the Adalo interface.” When I do attach the closest possible option (“1. Record id: recYTBBGQAYhyueYI” that maybe came from connecting the api?) it still doesn’t work. Any advice here? Please let me know if any additional information would help find a solution. Thanks thanks. ---
**Author:** ![Ben](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ben/32/9_2.png) [@Ben](https://forum.adalo.com/u/Ben)\ **Post date:** [April 2, 2020, 1:38am UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/2 "2020-04-02T01:38:50Z")
To view the id of a specific record in the Adalo interface, go to the database tab, view the records for the collection, and then click on the specific record. The id of the record is the number at the end of the URL. ---
**Author:** ![Clement0909](https://avatars.discourse-cdn.com/v4/letter/c/d9b06d/32.png) [@Clement0909](https://forum.adalo.com/u/Clement0909)\ **Post date:** [June 17, 2020, 11:28am UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/3 "2020-06-17T11:28:28Z")
And is it possible to get the ID of row stored in Adalo trought a webhook in Zapier ? In adalo editor is not possible to get as a variable the ID of a row ? This will allow to avoid the processing time with “Adalo’s new record” in Zapier. ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 8:14pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/4 "2020-11-06T20:14:26Z")
Just following up on this, I am trying to Update an Adalo Record via Zap, but can’t figure out how to automate the selection of the Record ID. I hard-coded the first record for the Zap to fire properly using @Ben 's above method of clicking on the record in the db, and using the number at the end of the URL. But, that doesn’t scale. @anon78309838 ? @AXIOM@pford ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 8:44pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/5 "2020-11-06T20:44:44Z")
Hi @tdhi, If you don’t have the Record ID you will naturally have to perform a database lookup (Search) first to retrieve that ID before moving on to the next Zap step (Update record with the ID from step 1). ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 8:56pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/6 "2020-11-06T20:56:59Z")
Ahhh ok got it, thanks! What would be a good way to automate the database lookup and pass that to Zapier as Record ID (otherwise Zap will not run as currently hardcoded). ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 9:00pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/7 "2020-11-06T21:00:20Z")
It depends on your workflow, can you explain to me what would you like to achieve? so I can give you the best solution. ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 9:41pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/8 "2020-11-06T21:41:48Z")
I have a two sided marketplace and collection called “Notifications”, sent by one user to another. When the notification is received by the recipient user, he/she can login to post an answer which updates the original record in the Notifications collection. Until the recipient posts an answer, the Boolean in the record will remain “Unanswered”. I’ve set up Zapier to send emails to the recipient every 24 hours whenever the Boolean is true. After 24 hours has passed, and email has been sent, I’d like to update a property in Notifications called “Days Elapsed” to add a +1. I have another property which also records the number of emails sent. So basically, trying to Update the Record in Notifications collection with a “+1” on two different properties. thanks so much for your help and quick responses. Adalo is lucky to you have you guys on board. ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 10:22pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/9 "2020-11-06T22:22:45Z")
Nice Workflow by the way 😉, > [@tdhi](#): > > I’ve set up Zapier to send emails to the recipient every 24 hours whenever the Boolean is true. After 24 hours has passed, and email has been sent If you already set up this step then naturaly Zapier has that record right (user email…)? So all you need to do is add another step to your worflow and update your collection’s record with the +1 from the previous step. For the math operation (+1) you will need to add the **Formater by Zapier**. ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 11:00pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/10 "2020-11-06T23:00:54Z")
Zapier requires the Record ID (cannot skip) and there is no way to access this automatically to update the record. @Ben and others have asked us to manually click on the record and use the URL to figure out the Record ID. It isn’t sequential. ![Screen Shot 2020-11-06 at 2.52.12 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/5/5b319b2d6c7fd884b87fbff91eb40361c6b192bd.png) ![Screen Shot 2020-11-06 at 2.52.34 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/92f18ed3c93fe7ab02fe49d09470bc337ec5e09f.png) ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:19pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/11 "2020-11-06T23:19:05Z")
Yes I know, can you please show me the steps before **Action 3** as I need to see your workflow trigger, No worries we will get this done in no time but I just need to reproduce this workflow to show you 😉 ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 11:24pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/12 "2020-11-06T23:24:06Z")
Step 1: Select Adalo trigger (When New Notification Sent Record in Adalo…) Step 2: Continue if Unanswered is True Step 3: Delay for 1 day Step 4: Send Email Step 5: Update Notification Sent record (+1 day elapsed, +1 reminder sent properties) ![Screen Shot 2020-11-06 at 3.21.28 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/7/7832bf698c809af05a6a52653ae0ce0a9bd414e5.png) ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:29pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/13 "2020-11-06T23:29:04Z")
So this new Record trigger is from the Notification collection, right? Do you have a User field in that collection? ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 11:36pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/14 "2020-11-06T23:36:39Z")
Yes, I have two Relationships to Users (one for generating the Notification, and the other User receiving the Notification). ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:39pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/15 "2020-11-06T23:39:25Z")
So you should be able to retrieve that ID from **Step 1** right? ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:45pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/16 "2020-11-06T23:45:36Z")
![User](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/3/39678e9f8f8e073b698703b8e2abfada1d5b38e2.png) ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 11:51pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/17 "2020-11-06T23:51:41Z")
In my Collection, I don’t have a property with a User ID numeric value. In any case, the numbers don’t match anyways, and Zapier spits out an error. In the above screenshot, your Record ID is “5” while the User ID appears to be “1”. Were you able to Update a Record with User 1 instead of Record ID 5? ![Screen Shot 2020-11-06 at 3.45.34 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/c/cdc6bb70fef0d59afbc4e92c3e1b2c4b0adcfa3d.png) ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:56pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/18 "2020-11-06T23:56:13Z")
No **5** is the ID of my “ **Notification Record** ” and **1** is the ID of the **User** ---
**Author:** ![Devops](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/devops/32/3723_2.png) [@Devops](https://forum.adalo.com/u/Devops)\ **Post date:** [November 6, 2020, 11:57pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/19 "2020-11-06T23:57:43Z")
![NestedUserID](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/0/0a6375da772b2d6ae889a014c7396566d5d69422.png) ---
**Author:** ![tdhi](https://avatars.discourse-cdn.com/v4/letter/t/c77e96/32.png) [@tdhi](https://forum.adalo.com/u/tdhi)\ **Post date:** [November 6, 2020, 11:58pm UTC](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491/20 "2020-11-06T23:58:37Z")
Yes! And Zapier doesn’t accept the ID of the User, it wants the ID of the Record, which is only available manually by clicking on each record, viewing the last portion of the URL. Is there a workaround using the Collections API or custom actions? ![Screen Shot 2020-11-06 at 3.55.32 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/b/bc5eb0d0110fb520fe94a8bdc71b2a1e6b1af5f0.png) [Next page](https://forum.adalo.com/t/zapier-record-id-not-available-through-adalo/491.md?page=2)