AnsweredAssumed Answered

Bonus report by month

Question asked by TGreen on May 14, 2015
Latest reply on May 18, 2015 by philmodjunk

Title

Bonus report by month

Post

We are creating a bonus/commission report (thanks to Philmodjunk for your help on that btw) and I am trying to find the best way to accomplish this. We have 4 fields: bonusname, date, amount, salesagent, and I am using calculations to automatically set the amount based on the bonusname. This will be a monthly sort of report, where once a month we go in and set the bonusnames, usually about 8 of them from a dropdown list, such as "1st sale of the week" etc. Now, what I did not plan well was a way to save /archive that month in the view and clear it out and start the next month...is this best done through scripting you think? I thought about having a layout where they just input each bonusname record in by hand (using the New Record option) and setting the date, but I would like them to see which ones they have already chosen so they don't accidentally double them up...some sort of split view or something? again, I might be overcomplicating this :-)  (btw, I am still fairly new to Filemaker so please bear with me...I played with it a bit last year and am now just getting back to it)

Any advice appreciated

 

Outcomes