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

Question

Question

Embedding Multiple Pictures in a Form

Forms Workflow How To
Updated December 7, 2018
asked on August 3, 2016 • Show version history

We have a client who's seeking, in addition to document management and a great repository structure, to be able to capture input from site surveys. In completion of the site server whether in office or at the client location, the survery would put attached photos to the form/document before the form is moved to another part of the workflow where a new form is generated based on the assessment of the previous form. 

 

How would we able to achieve this with minimum scripting?

0 0

Replies

replied on August 4, 2016

Hi Subina,

Are you trying to attach user uploaded pictures to the form or predefined images on form creation?

0 0
View 3 previous replies
replied on August 4, 2016

Hi Xavier,

It's user uploaded pictures. We would like to pick the photos to embed into the document after taking a varied number of photos. The number of photos may vary depending on the location that the user is working from or the condition of the site he is evaluating. 

0 0
replied on August 4, 2016

Is there a reason you can't embed them using the custom html option?

0 0
replied on August 5, 2016

Hi Xavier,

Do you have a custom HTML that you could share?

0 0
replied on August 5, 2016 
<img src="path_to_image"/>

You can read more about embedding images here.

2 0
replied on April 27, 2017 • Show version history

Did you guys figure this out?  I am trying to do the same thing but don't know the code to derive the unique path to the user uploaded image(s).

1 0
replied on December 7, 2018

Looking into this I know that the binary data for the upload is held in the Forms database under table: 'dbo.cf_bp_attachment_data'

You can find the specific file via the 'file_name' but this value is not unique.  So you could resolve multiple rows if you aren't careful with the index value.  Which you can't really determine at the Form level.

Getting the correct row is one thing, but then rebuilding the binary file once you retrieve it is another.

The binary file, 'varbinary(max)' type can be very large.  I believe in SQL Server '(max)' anything caps at 2Gb.  This is convenient since the multi-line field caps at 2Gb as well.

I am looking for a simpler way to be able to pull an uploaded image file and embed it into an HTML field as well.

To take it a step further, I would also want to be able to draw on top of the image with a canvas tool setup in HTML.

 

If an engineer from Laserfiche could reply on this and help guide us a little further it would be appreciated.

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...