Jump to content

FM Calculation for Containers

Recommended Posts

  • Newbies

I have the attached letter that I am trying to display a digital signature on.  As you can see there is 2 versions of the same letter and they are different length based on the client it's for, meaning my signature has to either A.) move based on the letter length or B.) have 2 signature graphic containers and only display the correct one based on calculations (shop ID and package price).

Is there are particular calculation I should use for controlling if and when a container graphic is to be displayed?


Link to post
Share on other sites

Well then the question is what determines which signature to use. There should be a field (or a combination of fields) in the letter record that dictates this decision. Based on that you can either lookup the correct signature from a table where each signature is in a separate record or auto-enter it from a global repeating field in a single-record Preferences table.

Note that I am assuming you want to store the selected signature in a container field of the table where each sent letter is a record. This way the signature will be kept as it was at the time of sending even if the signing person modifies their signature later on. However, if you are keeping a printout or a PDF of the sent letter, then this is not necessary and you can display the signature directly from its original record or through an unstored calculation field.


Edited by comment
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Similar Content

    • By Ralph Schwegler
      A customer of mine runs a mainly Windows environment.
      They have troubles with Java to log in the admin console. The Windows (Server and clients) supporter has not the time to update the server and the clients at the moment (the licences are available). He thinks, updating the server in a first time and run the solution with FileMaker Pro 11 clients could do the trick for the moment.
      Will that work? Should I ask him to give updating to 11v5 Server one more chance?
      Thank you for your feedback
    • By Christina.Luis
      I am using FMP 11. I have several scripts, I am building a database to track tech issues. The core of the database functions great. However I would like the database to send formated email when certain things are done. IE: If a date is put in a field, a name, or clicking a button. I tried to set this up, using the email client, and I can somewhat do it successfully with my information. But when I try to pull the information from another database (one I created with the persons first name, last name, and email address - plain and simple) it will not pull in the persons email address. I am guessing that I have them related correctly, and or that I am just plain way off base. I am having it pull from a reported by field for the email address - which is connected to the email address database. (Geesh this sounds so complicated).

      SO I guess what I am asking is how do I have the database send an email - use a pre- created email (one with information pulled from the database - does not have to be fancy) then use the correct email address, when a button is pushed, a name is put in a field, and a date is inputed.

      Also Is there a way I can create a form for the email? pulling info liek name, dates, times, notes etc?
      I am creating the database based off of a template from Web Help Desk (which I love Love Love, but my boss more than likely will not allow it due to costs.). Help?

      Thank you
      Christina Luis
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.