FM - Handling a time interval

Posted on 2012-04-02
Medium Priority
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?
Question by:rvfowler2
  • 2
LVL 25

Assisted Solution

by:Will Loving
Will Loving earned 400 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.
LVL 12

Accepted Solution

North2Alaska earned 1600 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.

Author Closing Comment

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.
LVL 12

Expert Comment

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.

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
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…
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …

627 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