Calculation Engine (Define Fields)

Hi all, I hoping someone can guide me in the right direction. I have a two field "IP Address", and "IP Location". The first contains a public IP (65.43.56.65), the other field I would like to create a formula or calculation that would retrieve the locationowner or ISP of the IP address. is this possible. Thanks Rudy

I have a Transaction table. It has the fields "TransactionType" and "TransactionAmount". The field TransactionType contains a Value List. JM FM AM Is it possible to get the SUM of just the amounts with the AM type? Thanks, jim

How to write this calc.... if = 3, result should display upcoming 2 weeks of Saturday's, Friday's, Thursday's in date format. Example for the upcoming 2 weeks. Should return 11/25/2010 11/26/2010 11/27/2010 12/02/2010 12/03/2010 12/04/2010 Thank you! maui

Hi, I have a strange problem I wonder if the answer is obvious to you. I have my 3 tables. The main layout is the Master table with a portal to the other 2. I have imported the existing data into all 3 tables. When I take any existing record and do a calculation GetNthRecord ( Members t_ID::t_FirstName ; 1 ) & " " & GetNthRecord ( Members t_ID::t_LastName ; 1 ) it returns the full name of the member. ==(Problem) Now if I create a New Record and fill in all the data in the Master table as well as the Members table this calculation returns no data. I scratched (or banged) my head for quite a while. Eventually I found that if I turned off…

Is this a bug, or am I doing something wrong? I have a layout to view invoices for whichever customer you select so that payments can be applied to their outstanding invoices. I have 2 payment fields, one for normal payments and another for possible write-offs on an invoice. I have a summary field for each of these so that the total amount applied to invoices can be shown, as well as the total amount being written off. I am using a summary field so that the total works with filtered portals. Here's the problem. If you enter a value into PayField 1, then click out of the field, the summary updates correctly. Same with PayField 2. However, if you enter a val…

I would like to perform a standard dev summary on a count summary without having to “bake” the summary into a separate field. Is this possible?

Given a set of numbers that must equal 100 - e.g. SET A = 25, 25, 25, 25 SET B = 20, 20, 20, 20, 20 SET C = 20, 15, 40, 25 I would like to add or remove a number from the set and have the set automatically calculate its value. I am able to do this for SET A and SET B. However, I'm perplexed on how to do this for a set where the values are not equal to the average. So, my question is, how can I add or remove a number from SET C and have the set readjust itself? SET C = 20, 15, 40, 25, n where n = the lowest value in the set after the values have readjusted (in this case readjusted to Total = 100/5 instead of Total = 100/4). Context: …

Is there a simple way to create a basic family tree with FileMaker. :(

I'm thinking of a how to create a time line for events in FileMaker. Are there any ideas or if this has already been done.

I have my patients database, with one of the fields is "age", of course. For young patients, I would like to enter the age in this format: "5m"; "10d"; "2y 3m", and yet, theses entries need to be calculated, internally as decimal numbers when I do my statistics. Currently i calculate the number manually and enter it as a decimal number i.e. 5 months = 5/12 = 0.42, which is cumbersome for the secretaries and it does not look harmonious when printing the record of the patient. Please help.

Hi, I'm building my first database for a friend's company and have a question. The company uses their own system for numbering weeks, so for example this week (Nov 21-27) is week no. 366, the following week will be week no 367 and so on. I've built a Weeks table where the week number and the particular date range for that week is inputed (along with other things they need to define for every week). What my friend wants is to have a permanent box on top of every layout that shows today's date (solved that by using get currentdate) but also the number of the current week. How do I define the field that it works? I tried just linking that field to the weekNum…

I'm ridiculously new at FM and I have a question that I think would be a fairly simple solution (but maye not). I'll try and explain my problem. I have the fields; Product 1 Product 2 Product 3 Each of these fields has a pop-up choice where a user can choose from a list of values (all three fields draw from the same value list). I have another field called; Effort Level The list of values looks something like this: Poster Pamphlet Kit Folder Based on what the user picks, I want the Effort Level field to change to a numeric value. For example, a poster has a effort value of 1, a pamphlet has a effort value of 2 and a kit…

Is there a way to add a field to a table, and have the value of that field be a default value, without changing modification date of the records?

Hello, J new in FM. Want make calculation how many litters are per dam or sire. AnimalID (litter) 3 2 1 Dam 2 4 6 Sire 1 5 7 How?

so, here's what i've got. i need to count any field that contains the number 50 in it. for example, in this column of fields, i would have: 50 100 150 200 250 the result should be 3 in this example. what is the best way of doing this? i have tried to create a calculation field like this: If ( Recommended Load Bill Count = "*50" ; 1 ; 0 ) then had a summary field count them up for the report...but that's not working. so, how do i get it to find any field CONTAINING 50, not necessarily equal to fifty.

I have a donations portal. The portal shows event, amount, date, and donation id. When i click on a new row in the portal on the event field a drop down list appears. Right now the only option that appears is one that i created in the list menu "Annual Fund". If a user types something else in that drop down list when clicking on it besides Annual Fund how can i get that typed value to start showing up in the drop down list options automatically? Thanks! Erik

Hi Forum! Yes, I could find and program my own solution here, but, I decided, before my brain goes up in smoke on such a "banale" issue, I thought Id ask the forum as I think only 2 billion of us surely must have solved this one before. This is a problem as annoying as it is simple. I have a totally simple calculation field that has a text as a result. I do this: "Billtotal: $" & Round(bill_total;2) Goes without saying; bill_total is of course, a number field. I want it to print: Billtotal: $20.45 Problem: if the number bill_total is 20, this expression above gives Billtotal: $20 and not as desired: Billtotal: $20.00 Same …

For me, this probably applies more to custom functions and using calculations to set fields or variables in scripts (rather than calculation fields). I'm not sure if this was the right place to post this. Anyway, I was wondering if there's anyway to have an infinite series in a calculation. I seem to have this issue all the time. Here's an example: I wanted a calculation that would remove all text between hyphens, including the hyphens, when the text in between the hyphens is less than 50 words, and to separate the remaining text with line breaks. Using my custom function btwn, I have a script write this out, all the way until 250, because I don't foresee ever …

I've come up with a kludge to handle this by converting to text and fiddling, but there must be a more elegant way to handle it. I sell books, and depending on what nation they are sold in, the amount may come with two digits to the right of the decimal (like US$), or not (like Japanese yen). It would be convenient to be able to automatically change the format of the prices on invoices and such based on a simple switch for "yen or dollars." Each book has a specific yen price and a specific dollar price set individually. Any ideas for a simple way to implement it?

Hi everybody! I'm a novice in file maker. I've tried to find info about records calculation but no success. The problem: I have field1 with the following records - FFA, FFA, TTA,TTA,TTA. And I want to create a field which in every record will show how many such a kind of records I already have. (Sorry for my English) I try to show: Field1 Field2(will show a result) FFA 1 FFA 2 TTA 1 TTA 2 TTA 3 Thanks a lot to everybody!

I wish to duplicate the functionality of merge fields within a calculation field so that database users can insert "merge fields" within a larger field, to be substituted by a separate calculation field. I'm thinking the calculation should scan (somehow) for all spans of text beginning with << and ending with >> (or some other delimiter) then use "Evaluate()" to replace the enclosed text with the field value. Is this possible?

I have a calc Emp Form Tickets::zfound / Emp Form Leads::zfound All I am looking to do is limit the result to 4 decimal places. Doesn't really matter if it's rounded or just cut off. How would I go about this? Thanks

Hello I have two repetition fields. 1. Name: Attachments[5] Type: Container Option: Auto Enter Function: GetAsText(BestellungenET::Attachments[Get ( CalculationRepetitionNumber )]) 2. Name: AttachmentsDescription[5] Type: Text(unstored calculaton) Function: Attachments[Get ( CalculationRepetitionNumber )] Now, if I change anything in the attachments field, no mater which repetion, all fields in attachmentsDescription recalculate and show the name of the file in the corresponding repetion in the field attachments. Everything works nicely. Problem: Now. I want attachmentsDescription to be of type Text with th…

Hello, I am building a database for registration of our local soccer leage using FM 11, 1. we have 7 divisions by age/date U06 = 8/1/2004 U08 = 8/1/2002 U10 = 8/1/2000 Etc.... 2. I created an entry field for DOB I would like for the division to be calculated when DOB dae is entered. Thank you for your help....

Does any genius out there have any idea how to solve this? I have a database in which all names (people) have been entered with Caps Lock on. The result is far from satisfactory. I have tried just about everything to get rid of the capitals. I have succeeded in apparently getting the base fields back to title case. However, if I use them in a List, the original caps appear. In some case, the data has been entered in bold; this does not show up in the List but it does show up when the field is used in a related table. Furthermore, in the latter case, I have a report in which the surname field is formatted as bold. The only ones that show as bold are the ones that …

Hi all I wasnt too sure which category to post this question in. Hope this is relevant. I am required to log any change to a field's content, stamping the date and time. I am currently using a logging system similar to Superlog and Scriptlog that basically registers any field change in a table into one log field. Some time ago I was made aware of the shortcomings of this type of logging system, i.e the eventuality would be that this log field would become extremely large. I am now looking for suggestions on an alternative logging system. Anyone got any ideas? Thanks in advance

I have been using Get(ActiveModifierKeys) to take me to an alternate layout at login, exit loops, etc. But it recently stopped working, I didn't notice when. Perhaps a software update from Apple broke it, or perhaps a preference got changed somewhere, but I can't figure it out. Whereas I believe the following test script would have told me which keys are pressed, now it always displays n = 0. Set Variable [$count; Value:0] Loop Set Variable [$count; Value: $count + 1] Set Field [ table::global_text_field; $count & " = " & Get(ActiveModifierKeys) )] Pause/Resume Script [ Duratin (seconds) 1] Refresh Window [] End Loop Also,…

I'm a complete newbie to FM and I apologize in advance if this is a stupid question, but I hope somebody can help me... I have separate tables for Companies (8 companies in total), Retail Locations (each company has 2-10 retail locations) and Employees (each retail location has 2-5 employees. All the tables are related. The number of Companies, Retail Locations and Employees changes frequently. In a new table I'm trying to define two fields that would automatically calculate unstored count of 1) all retail locations of all companies and 2) all retail locations of a company based on a pop out menu with retail locations names (so if the user selects as…

I'm building a ordering system on filemaker and have the following two fields.. Date From Date To Date To obviously should never be smaller than Date From What I would want to do is put a script into Date To so that it checks if Date To is smaller than Date From and if it is, set it to the same value as Date From. I have tried using the standard if smaller than calculation but obviously the date is in the wrong format (25/10/2011) for that to work. Anyone any ideas on if there is a way to get that date into the format 20111025 so that the calculation would work? Or if there is a better way to do this. Thanks in advance, Cheers, …

I'm relatively new to filemaker and am slowly designing and implementing piece by piece a database solution for a small business i work for. Right now I'm trying to figure out how to calculate a value for a field in one table object that is based upon the sum of the values of a field across a range of records in another TO. Specifically i would like to input the range based upon the date the record was created so that if i input a start date and an end date it will auto enter a summation of each of a specific field value from each record falling within those dates. Does that make sense? (seems a little convoluted when i write it down)

I've run into a solution where the previous developer has chosen to use an auto-enter calculated value of get (RecordID) as the primary key field instead of the (to me) more traditional auto-enter serial number option. After looking at the solution in more detail, to me it appears as if this option has a more dynamic solution (With obvious caveats, ie - not able to define "human friendly" pk fields and ODBC limitations are two examples that come to mind) especially when it comes to performing data syncing imports. Are there any huge, show stopping limitations when it comes to using get (RecordID) as a primary key value that I don't know of? Is it slow/faster th…

Hi Everyone, I'm working on inventory solution, my question is how can I calculate Items Cost Fluctuation Report in amount and percentage: FM 11 Ad I have 3 tables: StockItem Line Stockitem Supplier Thanks in Advanced

Hi, I am having trouble creating a simple script step that changes a folder name. The code below does not seem to work: "cmd /k ren " & Quote("F:x") & " " & Quote("F:y") Any suggestions will be appreciated.

I have two date fields: one called Date Assigned, and one called Tickler. I need to populate the Ticker field with the Date Assigned plus 14 days. I thought the calculation "Date Assigned + 14" would work, but I get no results at all. Any ideas? Thank you, Kevin

Hello. This is my first. I hope I have chosen the right forum. I have to related bds. On one, a field called "books", with a title for every register and a "yes/no" in the library field, and a field called "author". On the other bd, I would like to be able to retrieve the list of all the books by the same author for which "yes" is selected. The two bds' relationship is "author id". What I can manage is to retrieve the list of books by the same author, but there seems to be no "yes/no" discrimination. I hope this is not too basic for this forum. Thanks a lot.

To all the gurus, how do I round up a field that contains a number? Basically like this, Field A = Calculation which result as a number Field B = Round up of Field A's result. So, let's say Field A is 345.670 and I want Field B to be 345.700 TIA

I have recently begun converting the primary keys in our solution to Ray Cologon's base36 UUIDs. I've played around with some of the file options to determine the best behavior for these fields, but I'm not quite settled on what is optimum. For example, if I check don't replace existing values, duplicating a record carries the Id to the duplicate. Obviously bad. However, it looks like without checking this, importing records into the database and selecting perform auto enter options would change the key values. Not a problem if you don't perform the auto enter options, but if you have other fields that need these auto options performed produces a conflict. Just cur…

I have a text field that looks kinda like this: 112 144 233 235 344 355 433 419 I need a calc which will insert titles above each subset grouped by hundreds...not sure if i described it properly but here's what it would end up looking like using the above text field: Parts 112 144 Surplus 233 235 Inventory 344 355 Assets 433 419 Calc must locate the first occurrence of the 'hundred' digit change and insert title above it. Thanks folks! What a great group you are for beginners like me. Maui

Good Day, I have a telephone database which I import a text file into, this contains all the calls made in our company month to month. I require a calculation that allows me to list the numbers dialled, then next to each number it must tell me how many times that number has been dialled by different extensions. Ie: Number dialled / Times dialled by different ext 0215485896 / 1 0218963569 / 40 This would make it easier for me to tell whether the call was work related or private. Thanks in advance Shaun

Hi, I've got myself into a knot trying to solve a problem of adding XML tag pairs into a text string: Intial text: The plant is 30cm (12in) tall with dark green leaves 12-16cm (5-6in) long. Required result: The plant is 30cm (12in) tall with dark green leaves 12-16cm (5-6in) long I think I need to find the position of "cm" and work back until I find the first preceeding space then inset after that space. I can change the "in)" with a substitution for "in) but was wondering how I might do this with a caluculation for future reference i.e. find the position of "in)" and work forward until I find a space then inset before the space. - the second …

Hello everyone; I'm working on a project where there are a number of text fields on a particular layout. The end-user will click a button on the screen which is supposed to grab all of the text from the various boxes, concatenate them all together into a single field, and have them formatted according to specifications they've laid out for me. Some of the formatting involves varying types of alignment. For instance, some text will be left-aligned, and others will be right-aligned. Is there a way to accomplish this via script or calculation within FileMaker Pro? Thanks in Advance Matt

Hi, I could use some help with figuring out a calculation and not sure if this should be done through a script or calculation. I have one field (A) that has text and I want to have a calculation result into another field (: that if field A contains X it will return a number in field B. Appreciate the help. Yes I am a novice :P

Hi all! I've been working on a report and I've got most of it down, but I'm having trouble with one of my summary fields. I have a field that can have either "Yes" or "No" as its answer and I would like to count the total number of times a user chooses "Yes." I created a "Summary" field called "Problems", but the options for "Summary" fields seem limited. For example, I can count the total number of times people answered, by choosing "Count of" but I would like it to count specifically the number of "Yes" answers. Does this make sense? Please do let me know if I haven't been clear. Any tips would be appreciated! Thanks in advance!

Hi Everyone, Simple one here that is throwing my brain! I have a time entry field (recording the time a job started). So a user might enter "09:00" which is stored internally in FMP as "09:00:00" as shown by the data debug viewer. I then want to extract this time into a description field I use for an invoice line item. As I'm not interested in seconds, I use the following calc: Left ( Time_Start ; 5 ) And add this into the formation of the text description field with the usual concatenations. The result, however for the above example time is to produce: 9:00: ie the leading zero isn't being counted in the "5" characters extracted. …

I have a set of records - say 5 (see example below) Field xxxx xxxx yyyy yyyy zzz Id like to get the number of same fields. In the example above the answer is 3. (xxxx, yyyy and zzz) I'd like the answer in a calculation but can't work it out. All help appreciated!!

Hello Folks. Need help with this calc.... if (x=y, Show all 'Day 4(Wednesdays)' between current date and 30 days out) Result would be something like if calc ran during first week of November after november 4 11/10/2010 11/17/2010 11/24/2010 Thanks! Maui

I am completely new to both FileMaker and Help Forums so please excuse me if this is a terrible question. I have been put to the task of making a complicated tracking system for the animation company I just started working for. I might not have set it up the proper way to begin with, but where I am stuck now, is creating a list in a sub-summery field. Basically, every entry in this table is a item that needs to be designed for an episode (a prop, a background, a character etc). Each item is assigned to an artist to design. I have a sub-summery by episode within which I want a field to be a list of all the artists assigned to an item within that episode. S…

I have a field called "Ct Atty" with user's initials. I have an additional field that I would like to automatically populate with their full names based on their initials. I thought I was on the right track with with If ( Ct Atty = "JS" ; John Smith ). This must be a very basic problem, but I'm stuck. Thanks, Kevin

Hi, New on the forum, I am a friendly user of FileMakerPro 7, using it for historical purposes. To make it short, this is my problem and my question I have serial numbers series composed by numbers like 42-107237 to 42-107248. I have made a calculated field giving automatically the number without prefix - for example 107237 I am looking to make a calculated field to automatically give all intermediary serials - 107238, 107239, 107240, 107241, 107242, up to 107247. the field will be used to research any serial and find the corresponding series - find 107240 will give the series 42-107237 to 42-107248 as result Any help in this matter will be …

I'm using title case for a name field. The only problem is some names don't format properly. For example: Baldwin-jones, Mcdonald, O'neal. Is there any way to "adjust" the field to force uppercase after a hyphen, an apostrophe, or an Mc? Thanks, Kevin

I have a timestamp field which i am trying to change the format. ie... 10/30/2010 4:07:13 PM to Sat,Oct.30, 2010 4:07:13 PM I right clicked and went to Format as and changed it to display Sat,Oct.30, 2010 but it still reads diplays 10/30/2010 4:07:13 PM Since it is a timestamp, I also created a new record and no changes Seems pretty simple don't know what the hang up is. Anyone run into the same problem. Jay.

Is there a way to add the current time to a drop-down calendar? Or, is there a way to populate a field with the current time when a date from the drop-down calendar is selected? Thanks, Kevin

Hi everybodies, i'm new here and i going to ask for an help from you. I would like to personalize a software for my newspaper stand but i'm still at the beginning of the work and i have just a problem. I have a table where i'm going to insert all the details of a magazine and it is composed by these fields: ID BARCODE TITLE DISTRIBUTOR ETC. I would like to scan each magazine with a barcode scanner in the field BARCODE. As you can know the barcode character lenght is 18 but only the first 13 chars are proper of the magazine. If i scan it with the scanner i will have 18 characters in the barcode field but i want to restrict them to only the first 13. …

I am working on a database that has a selection of over 250 variables. Once a user selects one, i need a script to format parts of the selection this is what it is entered like: Aspergillus flavus group what it needs to look like: Aspergillus flavus group is there a way to do this based on the over 250 variables? Thanks

When I typed in "address correction" in the forum search, I didn't find anything in the Forums that related to what I was looking for. It did, however, return four Google adds for services or databases that will do this. But they're external from FM. Anybody heard of a solution written inside FM? thanks Christopher

If I have a field that shows a students current grade and want to have another field show thier expected graduating year how do I set this field up and what should my calculation look like. For example if the student is is PK and it is 2010 how do I make a field show that his graduation year will be in 2023. Or if I change his grade to 5th grade for example I want the field to auto update to show that he will graduate in 7 years making his graduation year 2017. Please Help! Thanks Again, Erik

Hello, I'm wondering if there is some kind of calculation or summary that will allow me to view a count of how many times each word or phrase shows up in a field. To put things simply, when I hit Ctrl-I to index a field as shown in the image, I'd also like to see how many times each indexed word appears in that field: What is the best way to accomplish this? It doesn't matter where the number shows up, I just want to get a quick count of everything in the index. Thanks

I have the following calculation that will add a number field hours to a date field, but i cannot work out the solution to modify it to add minutes to the time field instead of hours. MonJ1Start - Date Field MonJ1Site - Number Field Time(Mod(Hour(MonJ1Start) + MonJ1Site;24); Minute(MonJ1Start); Seconds(MonJ1Start)) How can i do this?

I'd like to stop a summary field calculating when the record is accessed (performance reason) and only summarise when required. Presumably I need a calculation? Basically I need a field which gives a total of a number field in a found set.

Hiya Guys, This is my first post so please bear with me. Here goes i have 2 database's, 1 - Database A (FileMaker database) & 2 - Database 2 (an external MySQL Database) I have imported 1 field from a table DB2 called ID into a table DB1 called EXTID this is performed regually to keep the ID's up to date Both databases have fields for Name, Address, etc... DB2 is Read only I have a field in a layout called Field 1. I need to do following: When a record loads: If table from DB1 has a value in EXTID then display the data from table in DB2 If table from DB1 doesn't have a value in EXTID the display the data from tabl…

Hi everyone, I have a database that records the amount of winches a crewmember may do on a helicopter on a given flight. Within a separate table/layout for staff members, a calculation creates the sum of all the winches that each staff member does from the flight details they are listed as a winch operator for. Is this an inefficient way of recording this? Would I be better off inserting the information straight from the flight details into the staff table? Cheers Andrew

Okay, I admit it, I have no idea what I'm doing. I have a field called "30 Days." The field is pre-populated with the words 30 Days, with the text matching the background so as to be invisible. In Layout mode, I've conditionally formatted the field to be white letters on a red background if certain conditions are met, i.e., the difference between the current date and the "date assigned" field is greater than 29 but less than 60, and the "Final" field is empty. Here is my calculation: Get (CurrentDate) - MJONES::Date Assigned > 29 and Get (CurrentDate) - MJONES::Date Assigned < 60 and MJONES::Final < 0 I know there's got to be a better w…

hi, having got to the point where all I can see is a persistent quirk through 20 or so variations... the input is a file name in format: 1-some-file-name.html the desire is to calculate a link output with the scrubbed anchor text in Title Case: Some File Name.html the problem is every variation returns a lower case first word of the anchor text: some File Name the current calc variation: Let([ FN = file_name ; Aopen = "" ; // remove the leading number, remove the dash separators, remove the .html suffix ATXT = Trim( Substitute( FN ;[Left(FN; 1); ""] ; ["-" ; " "] ; [".html"; "" ] )) ; ANCH = TextStyleAdd ( ATXT ; Titleca…

I am looking to created a field that holds information from two other fields, or standard text and information from one field. I have a document number field that is created and I want that number to be added to "Project Material Request", whether it is just standard text, or an auto-entered field. The combined field would be, for example, Project Material Request 0001. What would be the code that would combine these two fields, or the text and field into its own field?

Hi, I have what should be a easy question to answer. What does "Evaluate this calculation from the context of: TableName" mean? I would understand this to mean perform this calculation using this TableName and related tables. The only problem is if the TableName is not related to the TableName used by the current layout, the "context" is unavailable. As a result, I fail to see the point, and do not understand how to accomplish these "isolated" calculations. Thanks to anyone who might have some insight into this problem. Bill

I know I have done this before, but cannot seem to get this to work. I have a table with related values. I need to be able to summarize the related values into a total in a Sub-summary. The sub-summary is sorting properly, but the summary of the values only gives me the total of the first value. I have tried calling the summary from a related table. I have tried doing a calculation that calls a "getsummary" I have even tried just summing the related values. Always gives me the same result. Can anyone advise a good way to summarize numbers that are in a related table? Like I said, I am using it in a sub-summary so it would be sub-total of what I am sorting…

am i missing something here? this function always displays the total records in a given table, and not the actual "found count". how would i display to the user how many records were actually found in a search like it is listed in the status bar? thanks.

Whats the best way to calculate each reapeat panel? Does the same line have to be entered each time for each repeating panel? If so how would you distinguish one repeating panel line from the next? Example For (Amount) Field (repeating panel 1) Qty*cost (reaeating panel 2) Qty*cost Thanks, Jay.

Blank once again.... Calc. to replace the entire text in a field if it contains a certain predefined word. Example: Table::Text Field ...contains "My Dog is ugly" If (Table::Text Field ?? "ugly" ; "Removed" ; Table::Text Field )

Hey guys, I am really really new to File Maker. I have been asked to build a date base and I need to track the number of projects according to their status. So each time a file is created it is assigned a status and long the bottom in the footer we need a line that says "53 Files Initiated, 16 Scheduled ....." I have no idea how to do this, can someone please help me? Thanks - Matt

Im an old foxpro programmer and am using fm pro in order to program for the ipad. I have a field with a drop down box. I have one item that is 'Abnormal". When that is selected I want the next field to be shown otherwise I want to move on to the field after that. Thanks for your help.

Hi there a little stuck on this one. I have another software package that I need to reguarly change data inside the text file from FMP 10. The data from FMP is (field name) StartX = 240 I want to substitute calculation (or Other) of the text file StartX ="40" to The data from FMP is (field name - StartX) = 240. I need FMP to search the full StartX ="40" to the substitute The data in the text file has a lot of ("") around the data that I want to change. The ("") is required in the text file for the software package to work. When I create the substitute, anything with ("") FMP seams to think it is a field and won't substitute

I really have to apologize, been away from Filemaker for sometime and appear to have forgotten the basics... I have a few records, 9 now-list layout. I have 2 calculation fields, average and count and they are in the footer below the fields I want to calculate. Record field name is Width. Average( Column1 ) is showing 840 Count ( Width ) is showing 1 840 is the last number in the list (record 9). If I erase the last number the Average( Column1 ) shows 815, the second to the last number and the Count ( Width ) shows 0. Why are these fields not calculating all the fields instead of the last field with a value? I know I am overlooking something. Th…

I want to track my gold account. I need some calculations that will do the following. I am not an accountant. I want to track my debit/credit and leverage. The fields I am working with are, Debit, Credit, Deposit, Leverage amount, Purchased, and Quantity, Credit balance due, Total Market Value. Excess Equity, Total Account Value, Annual Percentage Rate. I am able to do the math on paper but not able to create the calculation in filemaker.

I have a layout with a required field for a job time. However some users enter the time as 1600, or 400pm, or others as 4:00pm all variations for the same 4:00pm time. Is there a Auto Calculation i can use to always modify the enter value to a standard format such as 4:00 PM? Would the field have to be set to Text, Number or Time to do so also?

I am working on a database where the client requested the ability to see and change the next serial value of ID fields. However when I tried to use the GetNextSerialValue function only to find it wasn't returning anything. At about the point I was ready to throw my computer I discovered that it worked on another database I had on my server. So I put the client's file on my server and it worked no problem. Does anyone know why that might be? Is there any way to make it work either way? The database won't be on a server at all of the client's locations.

I have a contact management system that tracks students and their information. I have a field that is a drop down list and the students current grade can be chosen. I want to have another field that auto updates and will show their expected graduation year or "class of" year. So for example if I chose that one student was in 1st grade the class of field would auto populate to show that their class of year was 12 years from the current date. How do I do this? Thanks Again For all the help! Erik

I'm building a db of sports statistics (at least I'm trying to). I have a layout which shows the players' performances together for each match. I have fields which summarize the data by match or by individual player. How do I set up one field which summarizes, say, all of the Serving performances for one player without pulling all the records for that one player? Eventually I want to make a layout that shows an entire team's accumulated player performance. So instead of showing performance of players 1-12 for each game I want to show the sum performance for players 1-12 for all the games. How do I set that up? VolleyballStats_-_2_Copy_Copy.zip

Hi, I would like to have a calculated field (count field) in a table which increments automatically if a user (user field) enters a record. So some sample data might look like the following: User, count, other stuff ------------------------ JOE, 1, otherStuff JOE, 2, otherstuff JOE, 3, otherstuff SALLY, 1, otherstuff The next time JOE creates a new record I would like the count to be automatically set to 4. If a new user, FRANK, enters a new record, I would like it to automatically default to 1. Regards, Zenon

Hi everyone It's been a while since I visited here - and a while since I've used FM... i can't remember... is there a quick way to create lots of fields in a table? I have multiple spreadsheets, each with ~15-20 fields that I want to convert to a singe db with multiple tables. Is there a way to do this without creating each field manually? Thanks Dave

I have a field called "Date Last Reviewed" that only a supervisor can populate. I also have a field called "Last Modified On" that has a timestamp so that the last modification to a record is automatically recorded and is not modifiable. I am trying to add a field that automatically populates with the word UPDATED whenever the "Last Modified On" field is greater than the "Date Last Reviewed" field. That way, a supervisor will immediately see that an employee has made a modification to the record since it was last checked by a supervisor. I was able to make it a calculation field and when the condition is met I see the number "1" displayed in the field. How do…

I have a Project Number which is currently set as a serial number. I have a Task Number which needs to increase by one until the Project Number changes. Example: Project Number - Task Number 7100 - 1 7100 - 2 7101 - 1 7101 - 2 7101 - 3 7102 - 1 thanks, Jim

Not sure how to really do a lookup -- I normally just relate two tables and make a relationship field to show the data on the page I need. A problem with this that I see (Please correct me if I am wrong) 1) If the data changes over time your records change too (IE: If I say an Sample Illness is 24 months and I use this in a equation on today) but what happens if in 6 months from today I update the illness from 24 months to 30 months --- it changes all my records to that new illness months) How do I do a lookup field --- Never done one: I need to look up a illness (By Description) and return a value in another field How.. Thank you for your help

Hello All I have a set variable that is equal to: If(Get ( CurrentTime ) If I have a calc field set to this it works, if I use a variable it does not. The overall program is for a time clock I am developing. The above equation is for people working overnight, and there last punch is actually on a new day, but needs to be on the previous day. I have double checked the "Yesterday Problem" field, and that is working perfectly, and so are the other fields mentioned. Do variables get calculated differently? The calc field had to be "unstored." The variable is not stored either, it is not a global variable, and it is cleared at the end of the scr…

Please could someone help? I have spent a couple of hours trying to figure this out but to no avail... I have a collected data using a questionnaire, and would like to enter it onto a database. Each question has four options, with each scoring a number of points, e.g.: Q1 (How happy are you?) A: (choosing one of the following four options) i am always happy = 1 i am usually happy = 2 i am usually unhapppy = 3 i have lost the will to live = 4 I have formatted the field, so that the four options appear as "radio buttons". My question, please: How do I create an automated field, so that if the first option is chosen ("i am always ha…

Seems like a simple and often-used function, but I need a calculation to restrict field entries to the most basic roman alphabetical characters. Maybe I got a bit rusty on my functions, but I can't think of any function that this could be done with. Nor can I find anything here and elsewhere. Any tips much appreciated!

I am working in a hospital where patients are in rooms and rooms are on named floors. i would like to be able to enter a room number for a patient and have the database lookup or calculate the floor name. it seems easy but im stumped. i have a table for floor names with beg and end room numbers related to the patient information via room number which is related as beg = room number = end. please help ken

I'm a newbie and I think I need another table for dates, and a script for this, but I don't know where to begin. My database has related tables for employees and sections. I've created a columular "schedule" report that lists the employee name, report to work time, and days of the week across the page. I need to have the date for each day of the week show under the day of the week. Our week begins on Saturday. The report also needs to show Fiscal Year, Pay Period (1 - 26), and Week number (whether week 01 or 02 of pay period); this would be in the heading of the report. How do I set up a table that determines the dates based on our pay period and week nu…

Hey guys, I am new here i have created a database for membership. I have field for people who paid or not paid. Now what i want to do is that the field will set the field into "No" every begin september of a new school year. I have tried to find more information but i could not find any positive answers. Can some one help me please ???

I'm new to FileMaker, and this is probably a simple issue -- but I just can't figure it out. I have a date field called Date Assigned, which uses a drop-down calendar. I also have a calculated field called Age, which uses a "birthday" calculation so the result is years, months, days. The calculation works fine when a record is entered. My problem is the calculation does not update automatically. However, if I open an existing record and select the drop-down calendar and re-select the original date, the Age calculation field updates. I need the Age calculation to run whenever the database is opened so that all Age fields are updated automatically. I'd ap…

I'm attempting a technique for an email template solution whereby I'll take text with placement holders and output text for use in an email body. However, I am losing my text formatting. Attached is a simple demo of the problem. Note that any formatting in the Input text field is lost. Suggestions? DemoEval.zip

Can an input field store in a defined variable, or must a field always store in a table? Rather than add a new record and have to delete that record if the transaction is abandoned by the user, I'd like to have the user input a value to a variable then add a new record and transfer the variable to a field only if the user commits to the transaction.

How do you make filemaker show the current date at all times. I can make a date show when I make a new record.

I have a Number Field with a number entered. I then have a Summary field that displays the sum of all the records where this field has a value. For some records I want the Summary to ignore (skip over) the value. Is there a simple way to 'comment out' the value by adding a character of some sort? In crude terms it would be like putting the code lines // in front of the value and as a result, it gets ignored (I know that doesn't work!). This is only for my internal usage so it doesn't need to be to clever. Just quick and easy to change a value so it gets ignored and change it back later so it gets added in the Summary? Many thanks Mark

I have a layout to input travel expenses. The layout has a portal where each individual expense is entered. Expense type | Date | Amt USD $ | Billing Type Billing type is a drop down – either Reimbursable or Company Paid I would like to have a total on the main layout of the reimbursable expenses and another for company paid expenses. I have only managed to create a total for both combined with a calculation field - unstored, =Sum ( Receipt_portal::USD ) Is there a way to filter out one of the billing types within the calculation or should I be looking elsewhere for a solution?

I have a database that defines math for my cabinetshop. Some of our cabinets are pretty tall. We have to pay attention to this value to make sure they can be tipped up into the room without hitting the ceiling. This is probably the only time in my whole life I ever needed to make use of the pythagorean theorem. I know that the diagonal measurement of these cabinets is equal to the square of width + square of height but I don't know how to express this in a calculation field. If I have three fields: Width Height Diagonal How do I express the diagonal measurement starting with width & height?

Hello! I need to find out how many times someone attended in a month and year. something like: IF(Month(ADate="4");Count(Adate) It counts Adate, but all of them. How do I get only the month of april? Thanks in advanced!

Here is my formula: If ( Serial_Ship_Date = Get(CurrentDate) ; Serial_Qty ; "" ) It's returning values for all dates since I wrote the formula. So I'm getting results from yesterday and today. Am I supposed to update the fields somehow?

Hey guys I need help in creating a mailing label layout... If a record has a suite number attached to it, I need the layout to automatically attach "Suite" In front of the suite number for the mailing label only IF the record has a suite number. Any ideas? Thanks.

I'm having a bit of trouble getting my head around when to use this. FM Help gives an example (2+2 in the field; Evaulate returns 4), but the real-world examples puzzle me. It seems to be used quite a bit when calling Get (ScriptParameter), as in the following example: GetAsText ( Get ( CurrentTimeStamp ) ) & “ - Changed by: “ & Get ( AccountName ) & “ - Field: “ & Get ( ScriptParameter ) & “ Changed to: “ & Evaluate ( Get ( ScriptParameter ) ) & ¶ & Evaluate ( ( LeftWords ( Get ( ScriptParameter ) ; 1 ) & “::z_ AuditTrail” ) ) How is Evaluate ( Get ( ScriptParameter ) different than just Get ( ScriptParamete…