Helo

Hi Anyone know if it's possible to format text based on what's in a field? For example: In my layout I have a field called "status." At the top of the layout I'm using <> to display "Complete," "Pending" or "Working," depending on which is in the "status" field. I want the text in <> to be red when the field for that record is populated with "Working," yellow when populated with "Pending," etc. By the way, does anyone know what that function of displaying text from a field using << >> is called?

Yeah I read that. When I import the files as "picture" the numbers are way off. I've tried converting them in various ways to see if I could figure out if they're just in some other units but they aren't in any units I've been able to work out. Again, when I import the file as "file" the units are deadly accurate. It doesn't make sense to me.

Yep, I know length(container field) is supposed to give the size of the file in bytes. I loaded a .png file into the container field and the file size was calculated to be 2,369,955 byes. However, my Mac says the the file is only 338,903 bytes. Another .png file is calculated in FileMaker to be 837,012 bytes, but my Mac says the file is 114,572 bytes. And so it is with all the other files, which are mostly .png, .jpg, and .pdf. I had set up a button using the "insert picture" script instead of the "insert file" function to populate my container field. I did this because all of my files are maps and I need to have a preview available for each record. The "insert file" script previews only the icon, while the "insert picture" script previews the actual document. I have another button to "export file" and it seems to export the original file, regardless of whether it was inserted using the "file" or "picture" method. I just discovered, however, that if the file is inserted as a "picture" rather than as a "file" it gives me the hugely inflated byte count. When I insert the map as "file" it accurately calculates the byte count. Of course in that case I then don't get a preview of the actual file, just its icon. This makes no sense to me. Why in the world can you have one or the other, but not both? Why does a "file" have no real preview, while a "picture" has no correct file size? Why does FileMaker even distinguish between a "file" and a "picture?" Why can't it accurately calculate a file size using two virtually identical methods of loading? -- Helo

Hey, thanks! That's exactly what I was looking for. Except now I have another problem. The number inserted into the field is HUGE. The number of bytes is vastly larger than the actual file size. I thought maybe it was tacking on some extra size from the whole record or from the database, but the amount of extra bytes added to the apparent file size isn't consistent from one file to another. Any ideas? Helo

Is it possible to get the filesize for a file stored in a container field so it can be inserted into another field? From what I can tell FileMaker's "get(filesize)" function only gets the size of the entire database and there's no way to tell it you just want the size of a file stored in a particular record. Thanks! Helo