Auto fill check box according to result of calculation?
I have a Filemaker database for an upcoming kids holiday program that I am trying to automate a bit more. We scan in name tag barcodes and then manually fill in a check box for attendance (Mon, Tues, Wed etc).
Is it possible to automatically fill in a checkbox when the name tag is scanned in?
For example, can you write a script or calculation to look up the days date (say Monday, 1 May 2015) and then tick the "Monday" check box field?
Any advice will be greatly appreciated!