Hello,
We are trying to build a visitor registry. We manually enter the visitor's information, but the visitor has to write down his/her signature. We currently have 2 ideas. The first, we will use some tablet or something like that for a signature. The second, the visitor will enter his/her information and we will simply ask for a proof of ID and signature.
registry.xlsx
The one that we currently fill by hand has more fields, but this is a workbook example of what we want to do. The purpose here is to save time.
I *believe* the correct way to doing this would a database... Like Microsoft Access. Is that correct ? Thoughts ? The problem is the signature part. How do we accomplish this ? For example, if we add a signature line to Excel, it makes the file read only. If we want to edit, the signature gets removed.
I am looking for the correct way of doing this. A new "sheet" will be created every day. It will renamed to that current day's date.
If we go for the second idea, the visitor will have to enter its own information, but it should be only visible for us and locked down (so other visitors can't mess with the registry and can't see another visitor's information).
Is an automatic backup possible so we do not lose data, just in case ?
What the correct way to do this ?
Thank you for your help !
Bookmarks