You are viewing limited content. For full access, please sign in.

Question

Question

Forms Signature Location

asked on September 27, 2022

Does anyone know where in the Forms SQL database that the user signature is stored?  I am talking about the signature that you set under your account:


I assume that the image/base64 is stored somewhere in SQL.  I know that I can insert the signature into a merge field using a Word Doc.

In this situation we need to make a denial letter signed by the Chief.  The person who denies the form is not the Chief however, he only gets the final say in approval.  If denied by the Clerk there is no reason for him to "sign" the denial with a Forms task.  I'd like to query the forms SQL table and pull back that signature to insert to a Word doc. 

 

Thanks,

Chris

0 0

Answer

SELECTED ANSWER
replied on September 27, 2022

It's in the cf_user_profile table on the LFForms database.
You would see signature_type set to 1 if they have a signature image instead of the written/font version, and then the actual images will be in the data_url field (that is the large version) and the thumbnail_data_url field (that is the small version). 

1 0
replied on September 28, 2022

Thanks Matthew!

0 0

Replies

replied on September 27, 2022

The signature image is available in Retrieve Business Process Variables, you don't need to go through the database.

0 0
replied on September 28, 2022

Even if they don't get a task to sign?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.