What I’m trying to accomplish
Delete/clear the data from a relation property in Notion.
The database I am updating (DB1) includes an email property and a property that relates to DB2. One route of my scenario searches DB2 by email and then updates the relation property in DB1 with the correct item from DB2. This works fine. (Side note: I’m very proud of myself for figuring it out on my own.)
What the problem is
When an item in DB1 gets updated by clearing the email, I want to also clear the relation. So far, every way I’ve tried to set this up has generated an error. (The same Notion update module includes clearing a multi-select property, and that is causing me trouble as well.)
This error message:
makes me wonder if this is even possible, as there won’t be a valid uuid if the point is to delete the relation.
Set ups that I’ve tried
This is the set up that generated the error message in the screenshot above:
I also tried using the map toggle like so:
and got error message:
I then changed {{emptystring}} to {{emptyarray}} and when I ran the scenario, the error message I got was specific to the next field in the update module, so I thought this problem was solved, and the only problem remaining was the multi-select property I mentioned above, but when I made an edit to the module to try to solve the multi-select problem, I ended up with an error to that AND an error to the relation property:
I tried {{erase}} and this is the error:
What am I missing? Is there a way to do this?
Thanks!
Blueprint:
Volunteer sign up notification to RAK and set up reminders.blueprint (1).json (353.8 KB)
