Jump to content
Sign in to follow this  

Calculation based on value list result

Recommended Posts

Hi everyone,

I'm new to Filemaker and I'm attempting to make a employee timesheet, based on a two-week payperiod.

What I've done so far is create a drop-down list for the start of the pay period. The end of the pay period is then calculated based on the start + 13. This works fine.

Currently I have a drop-down list for day of the week. What I would like to have is a conditional drop-down list for date based on the day of the week for the pay period. For example, day of the week = Tuesday, the date drop-down list would contain 17/06/2008 and 24/06/2008. I am trying to build this with a case statement, but I'm not sure if I'm on the right path or no.

Any advice you could give me would be greatly appreciated.


Share this post

Link to post
Share on other sites

See if you can make use of this file. You can create a date range to use in a value list.


Share this post

Link to post
Share on other sites


Thanks for the file.

What I'm looking for, however is something that will allow me to choose a day, Monday for example. Seeing as how the pay period is two weeks (14 days) long, I wo

I have stored all of the pay period beginning dates in a value list. I instruct the user to enter the pay period for which they would like to submit a time sheet.

Then, for each individual day, they must enter their hours. So, below, they choose the day from a value list (Sat. - Fri.). Once the day is selected I want the date field to be automatically calculated based on the day (Fri. through Sat.) and the Beginning date of the pay period.

However, an employee might have multiple entries for the same day and date due to the fact that we attribute all hours worked to specific tasks. For example on Mon. June 16, an employee might work 3 hours on task A and 4 hours on task B.

I'm not sure if this can be done as I'm rather novice with Filemaker. Any help would be appreciated.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.