I want to schedule an event. I have the list with he first person starting at 9:00 am. I want to loop and add 7 minutes to each in the list. How can I do this? Thanks, Cheryl
The Community Feedback space is for comments & issues with the JIVE forum or your membership here.
These instructions may help you move this thread:
To answer your question -
Time math in FileMaker is quite easy. 7*60 = 420 (seconds in 7 minutes). So
GetAsTime("8:00") + 420 = 8:07// increment each time+ 420 = 8:14+ 420 = 8:21....
GetAsTime("8:00") + 420 = 8:07
// increment each time
+ 420 = 8:14
+ 420 = 8:21
Of course, you'll probably have times to stop or other "breaks". But let's get your calculation right first.
You may post screenshots or copied formulas. Sometimes a PDF must be attached by clicking the "Use Advanced Editor" in the upper right after you click comment/reply. Then you will have more options.
If you are very new using FileMaker, you may wish to move this to:
New to FileMaker
Reply back if you have more questions!
Sent from miPhone
As beverly suggests (and was done with your other post), I will move this to the Discussions Space. You can then still move it to the New to FileMaker Space by clicking "Move" in the top right under "Actions", if you prefer.
Thanks Beverly. I'll work on this tomorrow. I've done quite a few databases in FM but very little on time and looping.
Retrieving data ...