AnsweredAssumed Answered

Is there a way to limit the size of an image in a container field? Can this be a button?

Question asked by Mingrl88 on Oct 8, 2011
Latest reply on Oct 13, 2011 by raybaudi

Like • Show 0 Likes0
Comment • 4

Title

Post

Hello All,

I have searched google and the FM forums and can not find a straightforward answer to this, so I thought I would post my own question in hopes to find a clear answer.

In my database I have 4 container fields per material record. I'd like to make a limit on the size of the file (in this case image) that can go in the container field. I have heard that one way to do this is you can make a validated calculation with a "length limit" and I tried entering into the validation calulation:

Length (Image1) < 204800

I was told this was about 200kb and I am ok having it even be 500kb but when I tried to insert an image that was about 1.7Mb it did not object. What am I missing?

Also, I have read multiple times that having a button for "insert image" will prvent users from copying and pasting images which increase the size and disjoin the filepath. I'd like to make this button but when I tried it asked me for a specific path which I do not have, nor will I ever, since the user who uploads the image is the only one who would know it, but my users may not understand this and I'd like for them to just be able to choose the image from a "browse" screen like the one that shows up when you right click the conainter field and hit "insert image".

PLEASE help! Thanks!!

philmodjunk Oct 13, 2011 11:14 AM

Correct Answer

Hmmm, it worked for me.

Here's what I did:

I opened a DB test file with a container field.

I defined cLength as the calculation: Length ( ContainerField ) and placed it on my layout.

I used Insert Picture to insert an image without the "by reference" option selected

I copied the value of cLength to the clipboard. (2503647)

I then added this validation calculation to containerField:

Length ( self ) < 2500000

I then created a new record and inserted the same image with the same options.

When I committed the record by clicking the layout background, the validation error message popped up. If I has specified a custom validation message, this message could have told me that my image file was too large.

See the reply in context

No one else had this question

Outcomes

philmodjunk Oct 10, 2011 9:44 AM

When you inserted the 1.7Mb image, was "store by reference" enabled? This is a checkbox that appears in the dialog where you select the image file to insert. If "store by reference" is used, then only a file path to the image file is entered into the container field and this will be much smaller than your specified length limit.

You should be ablet to configure Insert Picture so that the user gets the same "browse" dialog box that you get when you manually select the same option if you don't select any sorce file. Use Go To Field to put the cursor in the container field first, then your next step is Insert Picture. You can then control whether or not "by reference" is the default setting, but I don't see any way to make sure that the user doesn't select this option anyway...

Actions

Mingrl88 Oct 13, 2011 11:01 AM

Hi Phil,

Thanks for the advice! I was able to get an "insert image" button to show the browse screen when it opens but I am still having trouble limiting the size of the picture. I typed: Length (image1)<204800 into the validation calculation box for the field "image1" and tried to insert the image without the "store by reference" box checked and it still let me insert a 7mb image.I would like it to be limited to 500kb at least.

Any thoughts!?! Thanks!

Actions

philmodjunk Oct 13, 2011 11:14 AM

Hmmm, it worked for me.

Here's what I did:

I opened a DB test file with a container field.

I defined cLength as the calculation: Length ( ContainerField ) and placed it on my layout.

I used Insert Picture to insert an image without the "by reference" option selected

I copied the value of cLength to the clipboard. (2503647)

I then added this validation calculation to containerField:

Length ( self ) < 2500000

I then created a new record and inserted the same image with the same options.

Actions

raybaudi Oct 13, 2011 1:25 PM

you could try to use an auto-enter calculation, instead of the validation option. Something like:

Case(
Length ( Self ) ≤ 204800 ; Self ;
Self & " ( " & Round ( Length ( Self ) / 1024 ; 0 ) & " kB ) is too large"
)

Actions

4 Replies

philmodjunk Oct 10, 2011 9:44 AM
Mark Correct
Correct Answer
When you inserted the 1.7Mb image, was "store by reference" enabled? This is a checkbox that appears in the dialog where you select the image file to insert. If "store by reference" is used, then only a file path to the image file is entered into the container field and this will be much smaller than your specified length limit.

You should be ablet to configure Insert Picture so that the user gets the same "browse" dialog box that you get when you manually select the same option if you don't select any sorce file. Use Go To Field to put the cursor in the container field first, then your next step is Insert Picture. You can then control whether or not "by reference" is the default setting, but I don't see any way to make sure that the user doesn't select this option anyway...
Like • Show 0 Likes0
Actions
Mingrl88 Oct 13, 2011 11:01 AM
Mark Correct
Correct Answer
Hi Phil,

Thanks for the advice! I was able to get an "insert image" button to show the browse screen when it opens but I am still having trouble limiting the size of the picture. I typed: Length (image1)<204800 into the validation calculation box for the field "image1" and tried to insert the image without the "store by reference" box checked and it still let me insert a 7mb image.I would like it to be limited to 500kb at least.

Any thoughts!?! Thanks!
Like • Show 0 Likes0
Actions
philmodjunk Oct 13, 2011 11:14 AM
Unmark Correct
Correct Answer
Hmmm, it worked for me.

Here's what I did:

I opened a DB test file with a container field.

I defined cLength as the calculation: Length ( ContainerField ) and placed it on my layout.

I used Insert Picture to insert an image without the "by reference" option selected

I copied the value of cLength to the clipboard. (2503647)

I then added this validation calculation to containerField:

Length ( self ) < 2500000

I then created a new record and inserted the same image with the same options.

When I committed the record by clicking the layout background, the validation error message popped up. If I has specified a custom validation message, this message could have told me that my image file was too large.
Like • Show 0 Likes0
Actions
raybaudi Oct 13, 2011 1:25 PM
Mark Correct
Correct Answer
Hi

you could try to use an auto-enter calculation, instead of the validation option. Something like:

Case(
Length ( Self ) ≤ 204800 ; Self ;
Self & " ( " & Round ( Length ( Self ) / 1024 ; 0 ) & " kB ) is too large"
)
Like • Show 0 Likes0
Actions

Is there a way to limit the size of an image in a container field? Can this be a button?

Title

Post

Outcomes

Related Content

Recommended Content