Solved

FM - Handling a time interval

Posted on 2012-04-02
4
494 Views
Last Modified: 2012-04-02
We want to know after 20 minutes whether a data entry person has not completed a lead.  I've set up the calc for the incomplete lead based on required fields, but there isn't a way is there of sending us an email for an incomplete lead, say 20 minutes after the Creation Date?  I don't think the pause script step lasts that long.  I could set it up on the server that on the hour a script is scheduled that would email us any incomplete leads > 20 minutes elapsed, but is there a better way?
0
Comment
Question by:rvfowler2
  • 2
4 Comments
 
LVL 24

Assisted Solution

by:Will Loving
Will Loving earned 100 total points
ID: 37797953
A scheduled script on the server is probably your best bet. You could in theory tie it to some other unrelated function that is frequently triggered, but to make it reliable scheduling would likely be best.
0
 
LVL 12

Accepted Solution

by:
North2Alaska earned 400 total points
ID: 37798242
And you would want to schedule it to run more often than every hour if you want to send a message after 20 minutes.  Schedule it ever 5 minutes and have it do a query of incomplete items.
0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 37798561
I was mainly looking to see if there was something other than a scheduled script, but I did forget about the minutes setting.  N2A, giving most of the credit to you because last month I accidentally burned you on one question and forgot to give you partial credit.  rvf.
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 37798805
Thank you, and it's all good.  I love the give and take of EE.  I am a user and contributor and as such I don't sweat the small things.  :-)  But thank you for the points.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
FileMaker PDF Page Size 4 103
Filemaker Pro 14 - Summary Fields 2 59
filemaker server 14 default database directory 1 63
FM - Problem with TitleCase Function 6 52
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now