Calculation Engine (Define Fields)

Hello I am trying to manage seeding my Unique ID with a concatenation of CreatedBy (Account Logged in) and a number from a separate seeding table rather than using the Filemaker Auto Enter functionality. Background: I have worked in many RBMS over the years but admittedly this is my 2nd Filemaker project. Here is my scenario: - Multiple Individuals performing Data entry from Biz Reply Cards into single FileMaker Database (let's say tblCustomer is our main data entry table). - Each individual must have their own sequential seeding process for Unique IDs due to the way we store our library of Biz reply Cards after they have been entered. I would like to inhe…

I'm new to FMP, I got the Lynda.com tutorial files, but I feel i'm missing something, or can't get my head around basic logic. Here is my basic thing I want to do. I have one table with contacts and one table with invoices. I do not have products, just services that are different every time, in every invoice. In the invoice table, I have made the amount field, tax field, etc. There is also a contactIDfk in there wich is linked to contactID in the contact table. All I want to do is to create a button (in contacts) when I have a certain contact, I want to press the button, that make me go to the invoice layout, where that selected adres is shown (from contacts). …

Greetings: I am having a hard time with fractions, that are lookups and then calculations User inputs in a field in contract table, then a decimal field and fraction field are lookup (based upon a related table named WTU conversion). I would like the Total_fraction to calculate... but it's not seeing the lookup fraction fields as fractions (I am guessing) Also there is a salary formula.... that also pulls in the fraction that is not working properly. Summer_salary = job:salary_base * contract:tb_fraction_summer* 4 I have attached a sample file of what I am trying to accomplish with text boxes of notes (on the contract layout). Your assistance i…

when I create a field and select auto enter and tick data it dosen't do it. e.g. I create a field called is printed I go to auto-enter and type No, but it dosen;t do it... fields that are already created with auto-enters work but if I duplicate them the duplicate dosen't work it's the same when I try to enter date etc etc.

I'm having trouble doing an alpha sort on a last name, first name field that I created as follows: 1. the original field was first name last name (no comma) (field #1) 2. using left and right functions to break down field #1, I've been able to create a new field: last name, first name. (field #2) My problem is that I cannot do an alpha sort on the new field (#2). Is this because it's a calculation field instead of straight text field? Nor can I go back to the "last name" only field for the sort as this is also a calculation field. I've tried to change field #2 into a text field by creating a new field (#3)using the getastext and getas SVG funct…

Please help a newbie! I have a database of our membership - both current and past members. On my splash screen I have successfully included the number of active members (Status(CurrentFoundCount) from the total (Status(CurrentTotalCount). I would like to include on this same layout fields that calculated the number of active males and active females. I have scripts that find these records, I just can't figure out how to get these record totals into separate fields called Males-Active and Females-Active. Your help is appreciated.

I was hoping to get some help on a quoting system I am working on. This is a quoting system for a granite company. In the granite industry the customer is charged based off the height and on certain granite pieces and sometimes it is based off the width and in either case the Sq Foot rate. For example a piece of granite that is: L W H 30” x 6” x 20” So how we figure it is Length x Height / 144 which gives you the Sq Foot of that piece. So using the above size the Sq Foot would be 5 Sq Foot. Now I have to add a one time setup rate and Sq Foot Rate based off the height. Here is my range. Height Setup Rate Per Sq. Ft Rate 1–10” $160.…

I have files in a container, reference (shortcut). I want to be able to find a file in this container and have it open automatically. Is this possible to do and if yes, how? I have a script that already finds the job but I want when I find it for the file to open automatically.

Many thanks in advanced for your help, & here is my problems: I have 3 Calculate fields A,B and C: Field A in table (1) Fields B,C in table (2) Both table have common relationship field -------- How do I create function or formular to perform the following task: Calculate Value of field A (table1) = Sum of field B(table2) (with condition that when the field C in (table2) equal to blank value) (the calculation only records that have no value in field C)

I'm looking for help in how to import a folder full of pdf files. I have a database with a container field, but can't seem to find a way to quickly add a bunch of files. It would take FOREVER to do it individually.

Each record of my database represents a department of our company. Fields within each record (department) list employee names and titles. For each department, I need a field that calculates the number of managers, another field that calculates the number of salespersons, and another that calculates the number of administrators. I need the results to appear within each record, not in a summary field in a report. I can create numeric 'if' fields for each employee field, then a calculation field that adds the results. For example: if(Employee 01 = "Manager", 1,0) if(Employee 02 = "Manager", 1,0) Another field would add all of these fields to give me …

Microsoft Excel has a function called "Goal Seek". In this function you use a variable to affect a constant to produce a desired result. For example: 15% X 200 = 30 In Goal Seek, each of these values is interchangeable. You can select the desired end result or the desired variable and Goal Seek will produce the third value. Goal Seek also allows the mathematical operators to be interchangeable. Is there any way to do something like this inside Filemaker? Thanks, Jarvis

Lets say I have a dropdown field, Trucks Cars Vans I need to add a value to each, Trucks = 30% Cars = 20% Vans = 10% So, if I were to choose VANS which had a value of 10%, and entered $100.00 into the 'price' field, then 'total' would come to $10.00 Hope you can help! Kind regards, Ryan

Just wondering if anyone knows why when I import a folder off of a server and store the pics as a ref. that when I use the "Open URL" nothing happens.

Hello--- In a employee/contract database..... I would like to build in some validation rules. I have the theory but really don't know how to implement it in Filemaker and would love your input or advice If the person is Staff, Allow entry in another field- But if not staff, then no entry can be allowed in field If people::emp_type="Staff";job::jb_timebase can be entered What is the syntax to allow entry or not? Am I going about this correctly? Thanks in advance.

Is it possible to set up a formulas to recognizie a word if it matches a certain percent of another word in a seperate field? For example: Field 1 Richmond, VA/Field 2 Rchmd VA If you put a parameter that said if Field 2 > 80% of Field 1 then use Field 1. Is this possible or have I been watching way too much Sci-Fi?

Hello I have a folder with a lot of jpg's. Each one have the exact name as the name is inserted in one field. It's posible in FM6 to show them in one container field? Or i have to import all of them? Thank you for your help!!!

My existing small biz file calculates GST @ 7%, but as of July 1, 2006 GST is now 6%. Right now the calculation is simply Total Sale GST=Total Sale * .07. How do have Total Sale GST check the Date Sold field before applying the tax?

I am puttin together a database for the university's public affairs office that I work in. We are trying to catalog all of the images that we have from various shoots. Currently I am up to 2500 images which cause the database to run realy slow. These images were inserted into the container field to allow the other users on the network to see the actual picture and not just the file path refrence that you get when you use the import function. Is there a way that I can get the picture to show up in the container without having to insert the entire picture (someone told me that i should link it with relational keys but that is total greek to me).

I want to input data into a field in layout A, and it appear in layout B. Each entry from A should then make a list in B. I don't know how to dynamically create repeating fields. I have one table only. What is the basic concept?

I'm trying to create this calculation with little results. What I need to do is have a field calculation ('CALC PHASE') that bases different results based on the contents/value from another field (titled 'PHASE'). So if the field PHASE had the following value/text: 1 it would return "something1" in field "CALC PHASE" 2 it would return "something2" in field "CALC PHASE" 3 it would return "something3" in field "CALC PHASE" 4 if would return "something4" in field "CALC PHASE" Hope that makes sense...thanks in advance!

In my FM file in Date you can see in field 7/31/2006--if you click direct on the filed, but if you click outside the field it says, july2313200 -- which , of course, is bizarre. Unfortunately, it's this second version which prints out. any ideas appreciated. thanks.

I need to change dollars to text. Example 100.00 One Hundred Dollars and 00/100*********** Like you would print on a check. I have the calc in FM 5.5 But it does not work in 7.0 Thanks in advance.

I have a database of Driver Ed students. I need a formula for a calculation field that will calculate the student's age in years on the last day of class for their session. The database already has a field for "birthdate" (ex 11/06/1991.) It has a field for "session" (ex Session 1, Session 2, etc). It has a calculation field for "date of last class" (ex if the session = Session 1 then the last day of class is 9/30/2006. If the session = Session 2 then the last day of class is 11/28/2006, and so on) For example, if the student with the 11/06/1991 birthdate takes the Session 1 class he will be 14 on the last day of class. If he takes the Session 2 class he will …

I have a table with one field in called Set Fiscal Yr. This holds the current fiscal yr code. I have a field in my receipt file called fiscal year. I want this field to auto-enter the fiscal year listed in the set fiscal year table. I tried to use a calculated field by having the receipt fiscal year field equal the set fiscal year field but that does not work. Any suggestions?

Not really sure where to post this one.... I noticed today while in layout mode in one of the DBs at work that the majority of fields are titled with generic slogans (see attachment...replaces field names with things such as "Accessible power", "graphic reporting", "Powerful scripts", "Customizable buttons", etc.). Container fields show the filemaker logo, etc. This is in FM Dev 7 However when the fields are double clicked they show the correct name (and the database works just fine). I made a clone and took it home to view in FM 8.5 and the same occurs in layout mode. Any ideas what this is about or how it might have happened? (Or better yet how to fix)…

I need to be able to convert a Windows bitmap image (.bmp) stored in a container field to a .png format as part of a transfer script that moves it to a different container (in a different table). Is anyone aware of method that can be performed from within a script? Thanks for any help.

Operating system is Windows XP Filemaker product is Filemaker 8.5 Advanced I want to calculate the Retail Price from the Wholesale Price using Markups based on ranges from a set of global number fields. Let’s say the Wholesale price is $0.25. It is contained in a repeating number field that is calculated from Quantity x Unit Price. The retail price field is also a repeating field with the same number of repetitions. The Markup percentage for this price would be based on the Global Field “From” and the Global Field “To” both of which are number fields. The field that holds the markup percentage will be called “Markup” it to is Global. Let’s say t…

I have a program that asks for the date when something occurs. Typically the date is the same for all records. I want the user to be able to enter the date for the first record and have it copied to all the other records. However, it needs to be editable since sometimes the date will be different- therefore a global field will not work. I have tried defining the field - as auto entry-last visited field - but it doesn't work - or works only some times??? Any suggestions

I am in a problem, just need to know one thing. I am making invoices and in each invoice there is a field of Amount. I just need to know that if I view my records as table and I also in the table I want to have the total of all amounts, means a field with the total amount of all invoices at the bottom. How i can do that

Hello there! I've searched the forums but couldn't find any solution. I have a text-field that contains a list of values. Like this for example: 1 2 2 3 3 4 Now I want to remove all duplicate values so that I get a list like this: 1 2 3 4 But I'm kind of lost right now, so any help -- even a little push into the right direction -- would be greatly appreciated. Thanks, Ralph

when you specify that you want the calaner icon. is there any way to specify what side of the field you want it on?

I've been using the middlewords function to extract some data from a space delimited source. it worked fine, especially given that the number of spaces is completely variable, except that some of the data uses underscores, i.e. JIM_B and the middlewords function sees this as another space (the same is also true of slashes). Is there any workaround to stop it doing this?

I have a .tif text file, I drag it into FM and it's too big. So I want to reduce it's size with handles. What do I do to keep correct proportions? (I'm on a Mac) Also, I occasionally see a sign pop up asking about my desire to constrain -- but-- how do I call up this dialogue box at will? thanks!

So my Primary Key is made up of a project_id and a project_sub_id. In my case I intend to use this to track books using the project_id and various editions, translations, ect. using a project_sub_id. To rephrase, there will be multiple records for the same project_id but each project_id can have muliple sub_ids which are simply incrementing numbers. Now, getting the project_id to increment is no problem. However, how am I going to get the sub_id to increment properly? Mentally I'm thinking of relating the table to itself using the project_id, finding the current max sub_id and simply incrementing it in the new record by one. My only problem is that I do…