Capturing signature on form (1 Viewer)

JohnPapa

Registered User.
Local time
Today, 12:24
Joined
Aug 15, 2010
Messages
954
I have been asked to include functionality in my dental software which will enable the user to sign on a tablet and have the signature inserted in the form.

Specifically, there are two forms that need the user signature, the medical history form and the GDPR form (personal data management).

I do not want the the signature to be stored in the database, so that the database does not get bloated. Ideally the user would fill in the necessary info, would sign the form and the form will be output to pdf. The pdf file would be saved in a folder on the computer and would be accessible through the dental program through a link in the patient record.

I have done some research and have come up with the following two methods:
1) Use of the InkPicture control.
2) Use of the Fill and Sign Adobe Acrobat feature.

If the form just needed a signature 2) above would probably suffice, but any user entry would need to be stored in the database and once you sign you have to place the signature in the right place.

I would probably go for 1) and use a tablet that runs Windows.

I will investigate further solution 1) and report back.

Meantime, if there are other solutions available, please indicate.

Thanks,
John
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:24
Joined
Oct 29, 2018
Messages
21,357
Hi John,

I have used approach #1 and stored the signature in a memo field. Have you seen the demo on my website?
 

JohnPapa

Registered User.
Local time
Today, 12:24
Joined
Aug 15, 2010
Messages
954
Hi, can you please send me a link.

Thanks
 

isladogs

MVP / VIP
Local time
Today, 10:24
Joined
Jan 14, 2017
Messages
18,186
I also have an example of method #1 on my website
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 18:24
Joined
May 7, 2009
Messages
19,169
and here is my version.
 

Attachments

  • InkPictureControl.accdb
    608 KB · Views: 282

JohnPapa

Registered User.
Local time
Today, 12:24
Joined
Aug 15, 2010
Messages
954
Had a quick glance. Looks very good. Many thanks.
Also, from your experience, does the db get bloated when saving the signatures?

Most likely I will output to a pdf, with the signature, and save it on the hard disk
 

theDBguy

I’m here to help
Staff member
Local time
Today, 03:24
Joined
Oct 29, 2018
Messages
21,357
Also, from your experience, does the db get bloated when saving the signatures?

Most likely I will output to a pdf, with the signature, and save it on the hard disk
It will, but signature files are small. Also, you have the option to use a Memo field instead, which should eliminate the bloat concern.
 

JohnPapa

Registered User.
Local time
Today, 12:24
Joined
Aug 15, 2010
Messages
954
Yes and many thanks. The reply in #8 was for you, but was not specific.
I will post my solution.
 

Users who are viewing this thread

Top Bottom