There is an issue I just can’t figure out. I have 2 notion databases : Job Offers & Applicants.
My Job Offers databases generates a unique email alias for every job offer thanks to a unique id field.
extract the alias email used to receive the application & unique ID of the job
search my Job Offers Database to get the database item id of the job offer that has this email alias
create the new applicant in the Applicants Database & link it to the Job offer he-she applied for
But my search object module doesn’t find any item in my job offer database with the formula (see screenshot).
I tried various type of filters, tried formating to text my email alias in both the database and the set multiple variables module that extracts it for me out of the outlook email…
unfortunately I’m not able to help you but I’m rather writing here because I have the same problem and I cannot find a solution either. Hope my reply gives your post another boost for reach and that someone is able to help us.
I also want to search an object (database item) on Notion based on a formular-output (email address). I also tried different set ups but nothing has worked.
So I looked around and googled but all I could find are people with similar problems but no solution.
Unfortunately it seems that Notion is not sending/providing any information from formular fields to make so make cannot compare it to anything.
I hope I’m wrong and someone can still help us here.
I kept trying around and turns out that for me the problem was not in the formular field but in the select field which I set as a second filter (“and” condition). I used the wrong filter selection (I used a text filter instead of a select filter).
So, for me the filter for the email address in the formular field works with “Formular: String - Contains”. I think you should try “contains” instead of “equal”.
Nice to hear that you solved the problem @Christin ! I had to find a workaround because no matter the filter i used “Formula - String Contains” “Formula - String Equals” “Text Contains”, “Text Equals”, etc etc, it didn’t work !
So i finally set up my “Search Object” module to search a page instead of a database item with a concise query string and added a filter between this module and the one after to ensure that the only page found by this module that will go through the next modules of my scenario was the one that belonged to my database “Offers”.
