Calculation Engine (Define Fields)

Hi, little problem and can't seem to find a solution, can some point me in the right direction? Made a report (list view) to have a quick overview over the information per client or project. The problem is that I don't want anyone to be able to accidentally change any information in the list view. Can I lock the list view information and let people only make changes in the form view? Dutchy

I've got invoices being stored in temporary tables prior to actually being created in our real invoices table. I have fields called InvoiceCreated, InvoiceDeclined, InvoiceOnHold. Each has a value of 1 or 0 effectively marking the status. No record would have a 1 for more than 1 of these fields. All of that is working great. What I'd like to do now, though, is be able to figure a total amount for the declined orders. So I just need a total of all GrandTotal fields where InvoiceDeclined = 1. I could do it in a heart beat with SQL in a web app but I can't figure it out within FileMaker. I'd like to display "We've declined worth of orders." on my layout. An…

How would you implement the following specification in FM 8.5 (Win)? On a typical Quote screen, a user can select a product to quote on. When a product is selected, the price of the product is automatically inserted into the quote. Then the user selects one or more options for that particular product, each having their own price. As each product option is selected, the option price is added to the product price on the quote. Then the user may override the final price with whatever (for example they may decide to bump up the price or knock it down for whatever reason depending on who the customer is). That's the spec given to me - and I tried to solve with a …

WARNING WARNING! DANGER NEW FM USER ALERT! So I have taken just an Intro and Intermediate FM class, and quickly get stuck on functions and how to set up appropriate tables. Here is the type of data I have for selling golf clubs, all set up in one table (UnitTable): Type Club Qtr Yr UnitsSold Iron Wedge 1 2006 80 Iron 5-iron 1 2006 20 Wood Driver 1 2006 60 … I have this data for 12 quarters starting in Q1 of 2005. I would like the user to do a Find based on Type and then the layout would split back: Iro…

I am trying to set a range of numbers to validate an entry into a field. When I set the range for example 009001000001 to 009001999999 it will allow 009001123. How can I set the range only to accept numbers with 11 digits. Sorry I am a part time user and totally lost

Designed a database for 8.5, now I find out it's going to be used in 8. I have a calculation field that determines an overall status of these related records by using List() function (depressingly native to only 8.5). Any ideas how to revamp this field definition? Field Definition: Let( [ $BinStatusList = List( OrBin_OrderNumber::Status_Bin ) ]; Case( IsEmpty( $BinStatusList ) or PatternCount( $BinStatusList; "Needs Duplication" ) = PatternCount( $BinStatusList; "¶" ) + 1; .........blablablablabla....restofcasefunction.......... ) ) There's not a way to have a Get( RelatedRecordCount ) or something, is there? With that I suppose I coul…

I inherited a database that, in addition to other fields, contains a numeric field identifying a meeting and fields describing services generated from that meeting. The problem is one meeting might generate one service or five and each service is denoted in a separate record - with the same meeting number. is there a manageable way to deal with this data so I can see in a layout one meeting (number) and all the services associated with it? Thanks, Rick

First off, forgive me for my ignorance! I have created a Real Estate database which includes a contact layout, as well as a new purchase property layout. I need to create a script that after a certain date (closing date) copies the address details from the new purchase layout to the contact details (as the client will now have moved to the new house) I can create a "copy and paste" script, but how do I add the trigger mechanism associated with the closing date? I'm guessing its something like: If [buying Info::Closing Date > Get ( CurrentDate )] Perform Script (Closing Day Script) End If Am I close??

OK, I'm doing a simple check compared the the current date so my data set can expand as time passes. I'm doing them in quarterly increments. When I'm doing my arguments, it works fine for April and July, but when I get to October it reports as true. Get ( CurrentDate ) > "4/1/2007" result 0 Get ( CurrentDate ) > "7/1/2007" result 0 Get ( CurrentDate ) > "10/1/2007" result 1 ?? Can someone else try these and see what you get? I've tried it on two clients and both do the same thing.

Is there a way to manually add entries into a calculation field? I have a list of vehicles and when I select from a drop down menu, another calc field opens with the specific details of that vehicle parameters. If I use a vehicle not in the drop down list, I select "Other" and enter the ID manually, but when I try to enter that vehicle parameters in the calc field, it will not let me. How can I override that? The parameters themselves are used to make a summary so I need the information on the "other" vehicle to be included.

Hi there, We have a drop down list of letters for a template. i am trying to find a way to make a container field that holds a signture graphic to positio itself at the end of a letter without leaving any space if the letter is short or eclipsing the letter if it is long. The Sliding/Printing function doesnt help - how can I make the signature move up or down the page so it fits with the length of the letter? All advice gratefully received. Cheers, Steven

I'm sure this has already been covered numerous times, but I just can't seem to figure out what I'm doing wrong. When defining a client database, one of the fields I have is phone numbers. I defined the field as a "Number" type. When I type in a 10-digit phone number in this format "8883334444" it automatically changes into "8.8833e+09". I don't want it to display in this form. What am I doing wrong? Thank you and I apologize if this has been covered already. I did a search but I couldn't find anything related to my problem.

I have a field where people have already entered lots of comments with a date next to the comment in the date format x/xx/xxxx. I made a new layout where i want to display the data from this field but I want to have any dates show up in red. I Know the calculation for styling text red, and I know how to filter to find the date but I don't see how to make them work together. Any leads to a solution is much appreciated! Thanks!

i've gone to define database. i'm trying to get the tax acknowledgement field to produce an "X" if the item value is greater than $250.00 of the sold for price. i don't know how to do this. i don't know what type of option to give each field name or what formula to use so that i can get this result. so basically, i need the field to read: If "item value" > $250.00 of "sold for" then insert "x" in "tax acknowledgement"

I have 3 fields in a layout where you can type text as long as you wish.Also i made a same layout for printing with only these 3 fields.What i want is that the fields in printout layout be able to autosize so that the text in that fields to be visible when i print.

Hi, I have a business selling lottery tickets by mail order. Usually, when a customer contact me, he will define which draw he'd like to be part of, the package he wants (amount of games in package). From these 2 information, I will invoice my customer and allocate him a set of numbers already generated (I have 100's of sets). I have created a database with 4 tables: 1/Customers - 2/Draws - 3/Packages - 4/Set of numbers. When my invoice is done, it will get the required info from each of tables. First, do you think I have done the right thing? I have really tried to simplify the system by creating 4 tables since all elements are independants. …

Morning All, I've automated just about everything in FM8...but dynamically sorting (on the fly in a nice elegant "parameter-passing script") doesent seem available yet, unless maybe if I set up a detailed alphabetical Value List, to wit...(a...aa...aaa...aaaa...b...bb...bbb...bbbb...c, etc.). Am I missing something, maybe really obvious, that will do this? Or is there a custom function that someone has done? Thanks for the time and for indulging my lack of knowledge. Cheers, Royce (Somebody please pass the coffee....)

I am creating a db that will take an order import file and translate it from one system to another mail order system. I was able to get all the data into the correct layout but I need to figure out how to make the fields only display the order total on the first set of records... Here is an example... The way it works now: Line# Order# ProductID Price ShipAmt Total 11 12345 CE121 14.95 7.5 52.35 12 12345 CE122 14.95 7.5 52.35 13 12345 CE123 14.95 7.5 52.35 14 12357 CE121 14.95 7.5 52.35 15 12357 CE122 14.95 7.5 52.35 16 12357 CE123 14.95 7.5 52.35 What I need the system to do: Line# Order# ProductID Price ShipAmt Total 11 12345 CE121 14…

Since I can't control installation of a client-side plugin, free or not, is there a more graceful way to force affected fields to recalculate (on a field exit, or perhaps when a related field is changed on another window), other than sticking a "refresh" button on the layouts? Whatever I do has to be cross-platform and work from any generic FM85 client.

I know what I want to do... I think. I just don't know where to put it! I have a field called Dimensions. It contains either 2 dimensions or 3, of varying size, e.g. 11 x 10.5625 x 0 or 0 x 0 x 0 or 17.125 x 12 or 1 x 3 etc. I'm sure there are many ways to parse this string. I have figured out I want to remove spaces (to get, for example: 11x10.5625x0), then substitute spaces for the X's (to get 11 10.5625 0), then use WordCount to get the number of "words", and then use Leftwords, Rightwords, and perhaps Middlewords to get the first, last and (if there is one) middle value, and place these 3 values, into three existing (currently empty) fields:…

It seams this is very simple so I know I'm just missing something. I want to check a global date field to check that it is valid. I'm entering it in a message box. Is there a function for this? For example if I enter the date 2/29/2009 it should not allow it instead it just deletes it automatically. Any invalid date like 13/13/2007. I have error capture off.

Hello! I want to make a search box, i dont know if it is possible in filemaker but here is my case. Lets say i have a table, with lets say 5 fields. first_name, last_name, age, sex and id. I will have a layout with a search box, the can write a first name, a last name, and age, or any data that can be found in any field and select in a check box what they want to see about it, if it is the first name, the last name, or the first name and the last name, or whatever they want to see about what they wrote in the search box. I dont know if i explained it well, if i didnt let me know. Thanks!

This has to be easy, but I'm going in circles: how do I calculate a client's age? I have a DOB field; I want another one ("Age") so I can see at a glance how old applicants are. Thanks.

I am trying to re-create a record that I was previously erased. Before attempting to recreate the record I searched for the "catalog number", but did not find the number in that database or any of the other related databases. After re-entering the data into "catalog number", I receive an error message: "Catalog Number:" is defined to contain unique values only. Allow this duplicate value? If I say yes, I can enter the rest of the information in, but I cannot complete the record. To complete the record, I run a script related to "catalog number": Go to field [Catalog Number] Relookup Field Contents [no dialogue; Catalog Number] Whenever I run th…

I got a fairly simple database, 10 fields, two scripts, working great. It moves very fast, importing new records, and processing the records using the script. This was on a test file of about 1200 records. However, I then tried running it on the full set, 61,000 records. It ran, but seemed very slow, which seemed reasonable considering the much larger set. However, I discovered an error in one of the scripts, so deleted all the records, and went back to testing with the test file. Now suddenly, the whole thing is moving like molasses, even though the big set is gone. I then tried saving the file as a clone, figuring maybe there was corruption in the file. No go…

Hi, I'm sure this has been asked before but I can't find the relevant post... In writing school reports teachers are given a fixed size of field to make comments in. The field is set to font size 12 but some teachers exceed their given number of lines. Although the field expands to fill all their comments, when it comes to printing, some of this text is lost. Is there a way of making the font size change (to a smaller size) AS THEY ARE TYPING which would alert them to their excessive use of words?? Thanks for your patience.

Hello, I am trying to find a way to add a checkmark next to a field if that field is not empty, any suggestions on how??? Thank you, Tom

I am try to write a script that creates a new record in my tasks table. task table: taskname tasktype contact I want my contact to be populated with my current record from my contact table current. contact table: name phonenumber i have tried... goto layout ["task"(task)] new record/request set field [task::contact ;contact::name] this doesnt work. I am missing something, just not sure what.

I need to autopopulate a username Field based on 3 different fields, but I want the username to be the first letter of the first name, the last name and the last 4 digits of their social. First Name = John Last Name = Doe Social Security = 111-222-1234 Username = jdoe1234 Stumped!

Has anyone experienced the following.... Start FM8 Advanced, open files, run FM8 help (okay the first time...) do other tasks in FM8 Advanced, go back and use FM8 Help again and FM8Advanced and FM8 help locks up... this is becoming a regular routine... it's consistent....I've reloaded FM8 Advanced twice... Any thoughts are appreciated... Royce

I want to create a database for my contacts. I would like to ad a button to it where the computer would dial the telephone number (tone) over the computer speaker. If I hold my phone in front of it it will dial out. Is this possible in version 6? Alternatively does anybody know of a free template address book (v6) that I could use? Thanks

I have a calculation field that I created that results in a number, let's say "194". I am using this calculated number as the cost for an estimate to send in an email. However, obviously in the email the field data shows exactly as it's calcuated: "194". Since this is actually a dollar amount, I need it to show up as "194.00" in the email. It looks odd because sometimes the number is something like "245.6" and again, I would like it to be "245.60", etc. Since this data will be used in email, I can't use Filemaker's layout mode to tag the field as a number and then set it as currency. When I do that, it looks great in the layout mode within FileMaker, but …

I have a text field that I want to be able to enter data only when I create a new record. After the new record is completed & data is entered I dont want anyone to be able to change the text.Is there a way to do this?

i have a timestamp field....i want it to display as a timestamp...can i take off the seconds with out having to do a bunch of background work and extra calc fields to extract and then put back together??

On a course advising layout each course the student has taken is laid out with some characteristics about each course. One of which is whether or a transferring course is a 4 year institution (SR) or Community College (CC). There are roughly 35 unique fields that capture this info. The user decides for each course whether that course was offered at either a SR or CC by way of a drop-down. I want to be able to count all of the SRs and CCs but am not sure how to go about that since they span a bunch of fields. Ex: SRCCElectives1, SRCCElectives2, SRCCElectives3, etc. (there are 35 of these) Ideally, this calculation would display in Browse Mode but I k…