Calculation Engine (Define Fields)

Here's a weird question, the customer had fm7.... We have a time log for truck fuel fillings. All I want to do is look at the time, and if it's before 6am or after 6pm, flag a warning. I've written all kinds of permutations like: Case (if (time) < 06:00;"Time Warning";if (time) > 18:00;"Time Warning";"" and it doesn't work right, i can't figure out a rhyme or reason why some come up with warnings and some don't the times seem all over the place, oh and (time) is a valid time field.... what obvious stupid thing am i doing wrong? I even tried it with just one comparison, and it is still all over the place.... help -John

I have two related files A & B related by field "ref no" in file A and "reference" in file B I have an unstored calculation field in file B that uses GetSummary to give me a total amount paid per "reference". I have a field in file A that uses lookup to get the unstored calculation from file B. when I run the lookup I am returned a "null" value. There is a value in the field in file B and when I change the focus of the lookup in file A to another field from file B the lookup works correctly. We have just converted the files from v5.0 for Mac OS 9 to 8.0v3 on Win XP. The above situation worked fine on the Mac but does not work on WinXP. Any body ha…

I have a main table (Service Order) in it a portal table (service detail) each time when I add new row in the portal table the portal row's screen starts to scrolls from the first row to the last row. How can fix this problem?

I need to generate a random number between 1 and 28. How do I do this and if it is over 28, how do I make it go back and try again? thanks

I am fairly new to FM. I have a field with a formula containing over 120 IF statements. FM has prompted me that this formula is too long and that I must use two formulae instead. How do I put two formulae into one field? Thanks for your help :)

I have a headache of this. FM can not do this simple calculation because of the construction of the list. See example below. How can we do this simple calculation? TEST.zip

Hi - I need to have a field based on a calculation which is updated but the calculation is multi-step and requires a script. It's pretty simple - just need to do a find and figure out the relative position of the current record in the found set. But as records are added/deleted this will change, so I need this to be updated appropriately. I'm sure this is a common thing - but I can't figure out how to do it. The script is trivial, but how do you tie it to a field or calculation that will update automatically rather than when a script is activated by the user? Thanks! Michael

I have an autogenerated serial number field in a Quote table that I would like to automatically populate in an Invoice table (create a new record and then populate field in Invoice) when the Quote has been accepted (I have a status field I was planning to use as the trigger). I can't figure out how to populate the value without creating a relationship/join - I would like the Quote number to act as the join (and therefore link all of the quote details to the Invoice), but I don't want to manaully enter the quote number. Any ideas on automatically populating the value? (I tried the copy/paste feature from the script but to no avail) Any/all advice would be greatl…

Dumb question. How can i show a comma in a "Show Custom Dialog" option. The calculated field that includes a number, but the result is text. Here is the example. "You have chosen" & QUOTE_amount & " as your final quantity, is this correct?" (Calculation result must be Text) This is what I get: You have chosen 20000 as your final quantity, is this correct? I need to make the 20000 look like 20,000

In version 8, how do we create a new file that collects the totals of certain specified fields? Thanks!!!!

I was wondering if there was a way to write a caculation that was dependent on two fields. Such as If (field one = 2) and If (field 2 =2 then ; "3") thanks

This just has to be simple. Look at the attachment: I need to add up all of the numbers in the 'Price' column. These numbers are the extended price and they are derived by multiplying the 'unit' by the 'qty'. Pretty simple. I have a trailing grand summary. In the TGS, I have a calculation 'Grand Total', which is a summary field and equals the total of the extended price. It is incorrect so I am doing something wrong, oh so wrong. But what? Michael budget_opinion.pdf

I'm using Cases functions to do a few caculations for me and for the most part they work quite well. What happens sometimes is that they decide to not work sometimes. What i'm doing is using them to pull information from another table/field if a field is defined in a certain way any reason that these would not work. Anyhelp here would be great. Thanks, Jonny

Dear FileMaker Gurus: I was required to merge "User Last Name" and "City Name," into a 10-gigit "User ID." I will take the first 5 letters of each. If any one is less than 5, "-" will be filled in, instead. Please help on the Field Definition and Calculation! Appreciate it! Max NY

I would like to have a field in a table called "LastModifiedBy" which stores the account name who last changed the data in any of the fields for a row in the table. That is, if any data in a given row is updated, record who did it. Any ideas?

I have a user who does TONS of data entry for dates in the prior 2 months. Typically in January she would set her system clock back a year so that FileMaker autocompletes the correct year after she enters just the month and day in the date field. This worked great with FM Server 5.5 and Client 6. However, since the 8.5 upgrade, she will lose her connection to the server and be unable to reconnect after she backdates her client marchine (this usually happens not during data entry, but when she tries to make a new record, so she loses 20 entries every time it happens. It was a huge pain to figure out the cause). 1. Is this a known issue? 2. It is unwise t…

Hello! i have a "member" table, there i have "full name" and "picture" field. How can a pictured be added automatically? i will name the picture as the "full name", how can i do that?

hello! i have two tables. one "members" and the other "team". in "members" i have the info about hte member and an "id" in the "team" i only have the "id" and the "team name". I want in the layout of the members, to show the "team name" of that member and all the members that are part of that team. How can i do that?! thanks! and sorry for being such a newbie!

I'm really new at this, so please bear with me as I try to explain in unofficial terms what I am attempting to do. I work in the library which keeps stats of every question the librarians get asked. They would like to know what time of the day is busiest, ergo a count of how many people ask questions between 12:00 and 1:00 pm, etc. I have a field which auto enters the time. Is there any way to extract numerical statistics on this? Thanks!

hello! i have a field called "Subjects" that has a value list called "subjects" too. I want under that field a counter that will show how many "subjects" are clicked, active, or however you want to call it. Can somebody give me the calculation for that?! thanks!

My coworkers and I are having a hard time working this out. Anyway, here is the story: On our invoices we sell items (which you select under the "product id" field)that are taxable or nontaxable. I have found a way to set it up so we only charge sales tax on the taxable items. Well now there is a curveball, because we also will discount certain items (basically anything but memberships)to our high-paying members. There are two problems I am having with this - 1 is that when the discount is applied, it is applied only to the subtotal before tax, so the tax is still being calculated based on the price of the items pre-discount. I would fix this easily, except f…

We have a contacts table with several thousand contacts. Inevitably there are going to be instances where two people have the same name but work for different companies. I would like to know if there is a way to have a window pop up that says, for example..."There is more than one John Smith in our system. Please select which person you would like to use." Somehow I would like to have a way for the person to select from a list of those people and have the individuals contact info fill into the correct fields.

I'm trying to create a summary of invoice totals per week buy can't get it to work. Can anyone help me with the correct formula? All help is greatly appreciated. Thanks, Rick

Please help if you can. I need to format some numbers with a calculation. I want numbers greater than 100 to show as whole numbers, which I can do with the Int or Round function, but I also need numbers less that 100 to display to the hundredths place. It needs to show two and only two places to the right of the decimal regardless of how precisely the number is entered (i.e. 1.006% should be 1.01%; $7 should be $7.00; and $105.67 should be $105.)

I'm unsure of how to make this work. I was using the operator of "" to make the specified field (such as "RECORDS DEPARTMENT" match exactly, however I decided to go to 'global' fields so we don't have to change the code manually (thus the code below where "Configuration:LVMPGRP00_1" is a global field). Now, because I can't use "" with the global fields, I can't make it do an 'exact' match on the contents of that global field and it looks for *anything* in that global (so if I only wanted it to hit on "RECORDS DEPARTMENT" it won't work with the global because any other entry that has "RECORDS" or "DEPARTMENT" will hit. Wow, hope that made sense! Just trying to …

New to the whole FM thing. Finally graduated from Entourage Address book! Still reading the manual but if anyone knows a quick way to do this as I need to send out emails now! I have an email not written in FM but Entourage Mail. I need t send to about 300 plus people. Is there a way I can do this without having to drag each email into the address field on my email? All our emails are done in Entourage. Any help would be appreciated! Thanx......Tina

Hello, i was wondering someone can help me with this. basically i have date calc that count how many days has pass since the student have being withdrawn and when a refund need to mail. i am able to count the days but i am trying to figure out how to stop counting the day after certain date. this is how my calc look for the outstanding days Today- StudentWithDrawDate Since i know date the refund is mail, i was wondering if i can use that to stop the counting. i basically want to know how many days took for the student to get the refund. i am using filemaker pro 6. thank you vic

Hi Guys, I have hit a wall with this calculation. I need to create a text field with 2005-2006, 2006-2007 etc, based on any given date. The changeover date is April 1. Has anyone else done this or can point me in the right direction. If this is not clear I'll try and explain it more clearly. Many thanks. Seasons Greetings Gordon

Is it possible to use a wildcard character to replace all of this: Survery::q2_result = "" or Survery::q2_result_text1="" or Survery::q2_result_text2="" or Survery::q2_result_text3="" or Survery::q2_result_text4="" or Survery::q2_result_text5="" or Survery::q2_result_text6="" or Survery::q2_result_text7="" or Survery::q2_result_text8="" with something like this: Survery::q"*"="" I only want to evaluate those fields included on the layout that I am running the script from. Thanks.

Background: We keep a running history (via a portal to another table) with all the work assignments an employee has and does work at. A big organizational change just happened an I only need to replace the departments of some employees CURRENT assignment (but not replace their old prior assignments in the same table which may have the same department I'm trying to replace). Question: Is there an easy way to change their top level (first record) current assignment? Or because this is in a portal is it too difficult?

When I create a new company in my database I want Filemaker to automatically add the word LIMITED to the end of the field. e.g. I type in Wallwen then Filemaker adds in LIMITED.So the full field shows WALLWEN LIMITED.

Hello Forum I have attached a file that hopefully explains what I am trying to achieve. I want to save PDF, WORD files, etc into my database that show name of file and file type and description. Then when I click on this file it opens to allow me to view the file. In any one database I will have at most 20 different documents or files. Hope someone can give me a little help on this. Thanks in advance. Martin INSERT_FILE.bmp

Hi, I am trying to create a automated email and in the calculation script where I am setting up a template for each email. In the template I want it to print only the current month and year according to today's date. I am having trouble getting that as when I choose Month(Date), it needs to be linked to a field, but I want the current date. Can anyone help? Many Thanks Dean

Hi, I want to print about 200 fields within one data record on a label-layout, which has 78 labels on a letter-papersize. Only fields containing data shall be printed. How can I avoid empty fields to occur on my printout-sheet? thanks a lot Axel, Germany

I have a container field that displays the contents of an image file located on a specific PC directory. The path and filename never change, but the image in the file can be edited/replaced by the user. I haven't found any standard feature to cause FileMaker to refresh the container displayed on a layout when the image changes. Is it possible to run a looping script (with delay) as a "background operation" to handle this? Thanks for any suggestions.