What are you trying to achieve?
Trying to update a database item on notion once the record is created
Steps taken so far
Tried two different approaches -
- triggering a webhook from the N database to initiate the update
- Search Database Objects, then filtering to get the most recently created object (limit to the 1)
I’ve also looked through the “commonly asked questions” thread under Bundle Error and the 400 errors and none of them I could figure out
ETA: I haven’t even gotten to the point where I’m updating the database item because I can’t even get it to pass this point
(Also:
If anyone is interested in what I am actually trying to accomplish (with my 0 computer skills):
My husband and I are potty training a puppy. All pees and poops are entered into a database in Notion for both record keeping and also to trigger automations.
Every time we take her out to pee, if she pees, then we want to trigger a reminder (email-to-SMS on carrier, via Send from Gmail) exactly 4 hours after she pees.
If she doesn’t pee, then she immediately goes into the crate. And then we want to trigger same reminder exactly 1 hour after she’s put into the crate.
This I think I can figure out generally with the sleep (?) tool or some other way.
The issue is that one of us (ahem) doesn’t always remember to update Notion whenever said incident occurs (never mind the workarounds for this by adding iPhone shortcuts webhooks etc)
So, we have another field on notion called Manual Time Entry, where we enter the time in the form of Text (because, entering time in Notion using the Date/Time property field is very maddening… if anyone has tried it. much easier to enter in 14:01 than to enter the date, enable time, and use that wheel thing. We are already at the point where we forgot to log the incident at the time of the incident using the button tool, so… this prevents another deterrent)
So due to the existence of a text-based manual time entry, and Notion not being able to format a date/time based on a text-based time entry, need to get Make to parse the date and time.
So I have something like
Created Date/Time (date property)
Created Time Only (date property, in form of HH:mm, extracted from Created Date, time only)
Manual Time (text property, in form of HH:mm)
Actual Time in Text (text property, in form of format MM/DD plus either Created Time Only or Manual Time, depending on whether Manual Time is empty)
Actual Date/Time (date property, currently empty, this is the field that I need Make to update using parsing)
And then needing Make to parse Actual Time in Text into an actual Date Time property
And THEN finally I can do something with this (that part to figure out next)
So the trigger here is, either via webhook trigger (automation on Notion end, if entry is created, trigger webhook) or a Search Database Items / Most recent entry as above), then execute so that the Actual
But, I’m already even stuck trying to update the database item because it won’t even recognize it. And once I do figure this out, there is a Delay or Sleep module, right? )
Thank you for all who have bothered to read this far!
