Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Calculation based on drop-down menu


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.



Link to comment
Share on other sites

  • Create New...

Important Information

Terms of Use