Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Consecutive Events


  • Please log in to reply
7 replies to this topic

#1 farhanisfarhan  newbie

farhanisfarhan
  • Newbies
  • PipPipPipPipPip
  • 5 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate

Posted 23 February 2012 - 05:22 AM

Dear Community,

I have a table containing records such as:

ID Date Name Attendance


01 01/01/2012 ABC Yes
02 01/01/2012 DEF Yes
03 02/01/2012 ABC Yes
04 02/01/2012 DEF No
05 03/01/2012 ABC No
06 03/01/2012 DEF No
07 04/01/2012 ABC No
08 04/01/2012 DEF No


I want to count consecutive absences of a particular name by dates. i.e Has DEF been absent consecutively for 3 days?

I found something on http://www.briandunning.com/cf/69 but I am not able get it implemented.

Please help...
  • 0

#2 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 20h 15m 53s

Posted 23 February 2012 - 05:42 AM

It's not quite clear from your example what "consecutive"means. Would DEF be considered "absent consecutively for 3 days" in the following example?

01 01/01/2012 ABC Yes
02 01/01/2012 DEF Yes
03 08/01/2012 ABC Yes
04 08/01/2012 DEF No
05 15/01/2012 ABC Yes
06 15/01/2012 DEF No
07 22/01/2012 ABC Yes
08 22/01/2012 DEF No
09 29/01/2012 ABC Yes
10 29/01/2012 DEF Yes


It would also help to know why you need this - and when (in what context).
  • 0

#3 farhanisfarhan  newbie

farhanisfarhan
  • Newbies
  • PipPipPipPipPip
  • 5 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate

Posted 23 February 2012 - 06:52 AM

I am working on an attendance system. Those who are have not attended consecutive 3 or more expected events will be sent a warning e-mail.

In the above example, DEF has not attended 3 expected events consecutively if sorted by date (08, 15, 22). I want him to be listed in the report also reporting how many consecutive he left, (maybe he has left 4 consecutive dates)...
  • 0

#4 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 20h 15m 53s

Posted 23 February 2012 - 07:06 AM

Those who are have not attended consecutive 3 or more expected events will be sent a warning e-mail.


Is there a table of the events they are supposed to attend? That would make it easy to get the IDs of n previous events and establish a relationship to their attendance records.

Otherwise you'd need a "cascading" relationship, which could get slow with a large number of records.
  • 0

#5 farhanisfarhan  newbie

farhanisfarhan
  • Newbies
  • PipPipPipPipPip
  • 5 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate

Posted 14 March 2012 - 03:45 AM

I have a table "attendance marking" which sends attendance record to another table "core attendance".

"attendance marking" table sends ID, Date, Name, Attendace as fields to the "core attendance" table.

I want report derived from "core attendance" uniquely showing only those names which have consecutively "No" sorted by date in "Attendance" field for 3 or more than 3 times.
  • 0

#6 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 20h 15m 53s

Posted 14 March 2012 - 05:03 AM

You haven't answered my question.
  • 0

#7 farhanisfarhan  newbie

farhanisfarhan
  • Newbies
  • PipPipPipPipPip
  • 5 posts
  • FM Application:11 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate

Posted 25 June 2012 - 03:47 AM

Is there a table of the events they are supposed to attend? That would make it easy to get the IDs of n previous events and establish a relationship to their attendance records.

Otherwise you'd need a "cascading" relationship, which could get slow with a large number of records.


Yes, there is a table of events. (which records if someone attended or not with unique id number allocated to each person.)
  • 0

#8 comment  consultant

comment
  • Members
  • 24,199 posts
  • Time Online: 329d 20h 15m 53s

Posted 28 June 2012 - 12:17 AM

Yes, there is a table of events. (which records if someone attended or not


That would be an Attendance table, not an Events table. The Events table would have one unique record for each event.

To put it another way, you cannot tell if someone missed 3 consecutive events unless you have a list of the events they were supposed to attend, alongside a list of the events they did attend.
  • 0




FMForum Advertisers