Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Trapping a signature from touchscreen into a DB

  • 08-02-2011 11:41pm
    #1
    --amadeus--
    Closed Accounts Posts: 5,096 ✭✭✭


    Hiya,

    One totally outside my experience here! A client has a system of mine that they like where XL forms have embedded SQL that updates a database and VBA saves a copy of the file to a unique network location. They now want to use teh same functionality for a different category of forms, replacing a hard copy book they currently use.

    The difficulty is that they need to track a physical signature on the forms and would like a tablet PC that someone can sign (like when you accept a parcel) and that the signature will then be saved with the file / in the database.

    Anyone have any experience or advice?

    Thanks!


Comments

  • #2
    Giblet
    Registered Users, Registered Users 2 Posts: 11,989 ✭✭✭✭Giblet


    If you have access to the generated image, there are a number of ways to save it.
    A signature is probably monochrome and limited resolution (so the generated string length may be limited), so it could be worth saving it to Base64 and storing it that way, or a step up, and using BLOB storage which allows binary data to be saved directly to a database and has a larger capacity but might be missing from the excel spreadsheet.


  • #3
    conor.hogan.2
    Registered Users, Registered Users 2 Posts: 5,246 ✭✭✭conor.hogan.2


    The user/you save the image from the device and then add the link to the image into the database (or BLOB it)


  • #4
    stevenmu
    Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭stevenmu


    When InfoPath (2007+, not sure about earlier) is used on a touch/tablet screen it can take a hand written signature into a field. This can then be used to digitally sign the form to validate it's contents etc.

    If you already have the form in Excel, InfoPath has an import wizard to bring it in, but if not InfoPath is a far better forms tool. Once you get a bit of experience using the rules/formatting/views etc you can do a lot of cool things in seconds that would take serious macro/VBA work in Excel.


Advertisement