I’m trying to figure out how to return all records created by a specific user within the past 11 hours.
Any idea how to set this up?
The report will be run at 5pm, so I want to collect all records that have been run since 6pm.
It seems like I want to do this when the created date is less then the current date/time by 11 hours.
Here’s where I’m currently at.
Any idea?
Can you enter a negative value in +(hours) ? If so, enter -11, change “<” to “>” and you are done 
Let me check on that. Thanks!
But maybe if you don’t want to miss things in your report, you should add a flag “reported” then do a search on things that have “reported” set to false, create your report, then set the flag “reported” to true for all the things in the report ?
Using 11hours instead of 12 will make you miss some records
I can’t do negative, I just tried.
I like the “reported” idea. Would “reported” by a new field that is tied to each new record?
So the process would be
Is that basically it?
That’s it!
Althought I would have used the “reported” field the other way (first set it to false by default, and then send it to true once the email is sent).
Got it. I see where you’re coming from, set it to false in that it hasn’t been reported but needs to be.
I’ll let you know if I have any questions about setting this up.
By the way, adding a negative hour value does work for me 
But the reported option is better I think (that way if a workflow is canceled, you still don’t miss records)
Ok thanks.
Another quick question. This report is for the number of sales appointments that have been booked by specific sales person. I need to return just the count for booked appointments, for a specific sales person, for that date.
With this, it will return all of the calls for the day.
How do I also specify the count itself not the entire list?
if you click one “more…” after the search result, you can pick “:count”, which returns the number of items in the list.
Does it answer your question ?
Yes, that makes sense. Do I need to specify sales person before doing the “:count”?
If you just want to count the results that correspond to a specific sales person then yes you should add a constrain to your search
Ok, I think I fixed it. I need to have some calls logged and then I can test it to make sure it’s worked. Thanks for your help.
@florent.bocquelet ok, so I’m trying to add this contraint to my search but I’m not sure how to do it.
Basically, I have a table called “sales rep” and there’s 5 people in it.
I’m trying to find calls with only the name of the sales rep only matches one of the sales reps name.
Here’s what I have so far.
Any idea how to fix it?
I figured out how to return the count of ALL calls within the past 12 hours, but I can’t figure out how to segment that by “Sales Rep”.
Any ideas?
mm like this I am not sure. Could you share a link to the edit mode of your app ? Or at least some screenshots of the data pannels to see how it is organized
Does this link work? https://bubble.io/page?type=page&name=startcall&id=callbosstest&tab=tabs-1
I think I set the setting to “anyone can view”, do you need to be able to edit?
Yes I will look into it right now
Can you precise a little what you want to achieve ?
You want to get all the calls whose Sales rep is … ?
If I look at what you started; I see that before displaying the calls count, you display the name of the sale rep #7, do you want to count all the calls for that sales rep in particular ?
If this is the case, just add the constrain “HEA Lead SHeet: Sales Rep = Search for Sales Reps:item #7”
Good question.
There’s 7 sales reps, I need to get the count for each rep. I only picked number 7 as a test.
