ParaSQL has Signature Fields (v35 just released)

37 views
Skip to first unread message

ParaSQL Support

unread,
Apr 18, 2016, 5:54:58 PM4/18/16
to ParaSQL Support
You can now add a column of type Signature to any table... and then drag the Signature field icon into your app.

A Signature Field allows you to sign with your finger or stylus on a touch-enabled device or with a mouse on a non-touch device. The captured signature is stored along with the GPS coordinates of where the signature was captured (which can be displayed on a map by clicking View Signature Info). You can also place a transparent signature field over an image to annotate the image.


If you want to prevent a record from further changes after it is signed, you can use a database trigger to accomplish this. In the simple case, where you do not want further changes after a row has been signed, you can use a BEFORE UPDATE trigger similar to the following example:

BEGIN
   
/* prevent change if previously signed */
    IF
(OLD.MySignatureField IS NOT NULL) THEN
        SIGNAL SQLSTATE
'45000' SET MESSAGE_TEXT = 'Cannot change if already signed.';
   
END IF;
END

A more complex trigger(s) could, for example, check other tables in the database and disallow changes to itself if other related records were signed. ParaSQL can provide consulting assistance (at our normal hourly rates) if you need assistance with coding these types of triggers.

Jason

unread,
Apr 20, 2016, 2:35:32 PM4/20/16
to ParaSQL Support
This is great, 
How can I insert the signature image into a printable html snippet at a specific size?

Robert Dyas

unread,
Apr 20, 2016, 5:14:19 PM4/20/16
to ParaSQL Support
You can use the following in an HTML Widget that you are using with the Print As Document action:

<p>Insert Signatures like this: <script> document.write( '<img src=' + @FirstValue(ID1102).split(";")[4] + ' style="height:0.5in">' ) </script> </p>



Reply all
Reply to author
Forward
0 new messages