After struggling to find a solution to this same problem for a year, I found an Mac OS program called hook. It creates clickable links to any local file on your computer that you can paste into any program. When you click on the link it tells the OS ...

We run a language school in Spain and we do it like this: Each Student is a record, each date is a dropdown field. Options are present, absent or late