ContributionsMost RecentMost LikesSolutionsLimit the times on Calendar reports?is it possible to have calendar reports limit the hours that they show? I have a calendar report of daily appointments appear on my dashboard, but when I refresh the screen, it automatically defaults to showing 12 midnight and I'd like it to default to showing business hours.Re: Dropdown only showing certain options, possible?Let me ask this....Can I take it another level? Here's the situation: I use the process you outlined above and now see only the purchase orders for that vendor. I have different purchase orders for different lines of service...we'll call them Directorate A, Directorate B and Directorate C. Based on a field designating the Directorate the job is coming from, can I show only that Directorate's purchase orders? Let me know if I need to clarify that a bit.Re: Dropdown only showing certain options, possible?Worked like a charm! Thanks!Dropdown only showing certain options, possible?I use several vendors, for jobs and when assigning a Vendor, I chose their name from a drop down. After choosing the Vendor, I chose the purchase order that I will use to pay for the job from a different drop down. In the Purchase Order drop down, I see all vendors purchase orders. I like to know if it's possible to only see the purchase orders related to the vendor I've chosen.Re: usertoemail from user lookupIt's List-User. Staff-Supervisor is actually another lookup field from the Supervisor field in the Supervisor table. Could that be it?Re: usertoemail from user lookupI guess I should also say what I'm trying to get. I'm trying to return the user's email address, from a user field in a related table.Re: usertoemail from user lookupNope....no luck.usertoemail from user lookupHrere's the formula that I have for a Forumla-Email Address field: UserToEmail([Staff Member - Supervisor]) I'm getting this error: orclose Formula error -- Bad or missing arguments in function call The types of the arguments or the number of arguments supplied do not meet the requirements of the function UserToEmail. The function is defined to be UserToEmail (User x). You may need to do one of the following to fix the problem: Choose the right number and type of arguments. Use a type conversion function to convert the arguments you are using to the correct type. Choose a different function. Help!Re: Using Forumla URL, perhaps, to generate an email in an email client?We're thinking it's our firewall. #GovernmentRe: Using Forumla URL, perhaps, to generate an email in an email client?I would love to know how to do it with webhooks, but I don't have that type of expertise. I'm working on a formula-url forumla now. If you have ideas on webhooks, I'd love to see them. And yeah, our notifications sometimes get delayed, up to hours. :(