Calculation Engine (Define Fields)

Does anyone know a good way to schedule an event on a Google calendar from inside FM. Im kind of stumped other then calling up the plain old url and then having the user manually enter the information. Id really like to be able to schedule an event with data from a field. Any takers?

I don't know what else to call it. This didn't happen in FileMaker 6 and I'm at a loss: If you string together text and a field from a related table, either in a concatenated field or as a merge field, FileMaker insists on making a new line of everything beyond the field content, including the initial space after the ". It doesn't do it if the field is in the same table, however. The workaround is obvious, but I hate to create unnecessary fields just for the purpose. Is there another way?

Simple question I cannot get right: A=10 B=50 A+B = 60 (60 is a 100%) What is A in % A / 60 = 0.166... 0.166 * 100 = 16.66% How would I put that in one calculation without using an extra field? IE. I can get it like this: field_A + field_B = field_C (A + B = C) (field_A / field_C) * 100 to get % The question is how to set up the calculation without the use of field_C?

I need to import data. The company I'm importing data from uses leading zeros in their corresponding number field. ie: my field: 758426 their field: 00758426 I need a calculation field that will ignore the leading zeros. Any help would be greatly appreciated. Thanks.

Hello there, I'm getting the following result: ?,?,Job opened. from the below function: Case (not IsEmpty ( Comments ); GetNthRecord (Comments;3) & "," & GetNthRecord (Comments;2) & "," & GetNthRecord (Comments;1);"1") Since I'm trying to extract text from multiple related records, it is resulting in a ? mark when there is no second or third related record created. Otherwise, I get the notes I'm looking to compile. Any help how to amend the function to make no ? mark appear there is nothing in the related record field? thanks jana

Hello all- I'm trying to come up with a calculation that will calculate overtime hours worked in a scheduling database. We pay a staff person overtime if tthey work more than 8 hours in a 24 hour day and we pay overtime after a staff has worked more than 80 hours in a 2 week pay period. The calculation I came up with to calculate overtime hours worked for a Friday of week 1 (Staff1Wk1FriOt) of the pay period is: Case (Staff1Wk1FriSum ≥ 80; Staff1Wk1FriOt = Staff1Wk1FriHrs; Staff1Wk1FriHrs≤ 8 ; "0"; Staff1Wk1FriHrs > 8;Staff1Wk1FriHrs-8) Where Staff1Wk1FriSum = the total hours worked for days Monday through Friday. Staff1Wk1FriHrs is a calculation …

Ok, I think this has a fairly simple solution, but I am stumped. I have created a script which ends up in a layout that lists all the results of a search. I have been trying to create a calculation field to appear at the top of this layout that specifies the search criteria used. I hope this makes sense. For example, the user chooses "Ontario" from a checkbox set as the search criteria. A list of species from Ontario is then created in another layout. At the top of this layout I would like to have "Species from _______". Where the _______ represents a field that would ideally retrieve the last search criteria. So for the "Ontario" search I would like …

I am having an issue with the DayOfWeekName function. I have a field set to show the day of the week name with the following formula - DayOfWeekName(gdTempDate), gdTempDate is the 01/09/2007 which is a Saturday and the field is returing Sunday?

I'm running FileMaker Server 8 and I have a global field that I need to make a permanent change to. Currently when I change the value on a client it stays set untile I close the client. When I open the data again the global variable is reset to the value before the database was shared with FileMaker Server. If I want to change the default value of the global variable I have to stop serving the database, open the database directly in FileMaker Pro, change the global variable, close FileMaker Pro, and server the database again. How do you make a permanent change in a global variable from a shared database? Thanks.

Hi, Im sure that this is easy to some, but my head is all scrambled trying to get my brain around it. To keep the actual scenario as simple as I can, I have the following setup. 700-odd records, with a number of fields storing information about timesheets. For example a structure of this Location: Office1 (could be one of several items) JobDate: 1/7/07 (could be any date) Duration: 1.5 (cold be any duration) Im looking to setup a summary field that will total up all the duraction hours if certain conditions are met with the Location and JobDate fields. Now I understand the actual calculation required, but so far I have the following method which is…

I have a plain text field that I use to store HTML code in. I usually paste it from Dreamweaver and or sometimes Frontpage. The thing is that when I paste it into the field it adds couple of characters at the end; couple of rows of what looks like small squares. I thought it was some add-on from the DM or FP but it is not, I tried it on couple of different computers and with different HTML and it always happens. Any idea why it is happening or what I could do to fix it?

Hello, I have database of students listing their scores on various tests. I would like to create a field to supply me with the average score for males on a specific test. I am using a summary field but I am getting the average of all students for a specific test. Your help is appreciated DH

Hello all I been searching and read many articles on dates and calculations. My database is designed as follows invoices <- invoice payments -> payments. When a client pays insert information in invoice payments via portal on invoices layout. Invoice Payments is a portal on invoices. Actual information is inserted into payments table. Now heres my problem!!! I want to know when invoices are due after terms either 14 or 30 days. I think my calculation should look at Payment table payment date. If this is blank then refer back to invoices due date if this is more than terms then invoice overdue! Does the above make sense? Or is ther…

My DB is similar to a shop DB, and i'm changing from "selling" items with a unique product code to one which doesn't require a product code. Instead there will be a set quantity of the products. How would i make this change?

Hi, Is there a way to get a 'live' update on the fly so to speak for a field instead of waiting to exit it? For example, as you type text in field_A, field_B calculates Length(Field_A) Many thanks your your advise. P

How can I do add hard returns before each of numbers in these sentances? Sometimes they are letters. Assume that the text has been placed in a temptext field. 1. sample text 2. sample text 3. sample text or a. sample text b. sample text c. sample text

Is it possible and if it is how would you do: Field_A Field_B Let's say that Field_A is empty. If anything is entered in Field_B it should display in Field_A without it being deleted when the information is deleted in Field_B. That is done easily through lookup however if I entered new information into Field_B I would like it to be appended to the information that is already in Field_A. So basically if I entered 1 into Field_B, Field_A would display 1. If I then deleted 1 from Field_B and entered 2, Field_A would display 12. If then I deleted 2 from Field_B and entered Hello, Field_A would display 12Hello. Thank you.,

I have a formulas that conc. 3 different fields and outputs as text. One field is text which is easy, the other is a percent and the other is a number. The problem is the number fields report as a raw number - like the percent will read .345233571535371531. I can round it but it still lacks the % and doesn't read right. I want the percent to read as a percent and the number to read to one decimal and have a comma when appropriate. Any thoughts? Thanks

Ok, here's one that has been throwing me for a loop for over a week. I am building an event system, and have the dates as calculation fields (works fastest that way). But the Events themselves are from a relationship based on month and year. I would like to be able to make each day field into a button which gets contents from "self", that day so as to compare it to the date and pull up either previously entered events, or have a request to enter a new event. I'm hoping to do this from one script as opposed to having a script written for each of these fields.

Hello all- I am working on a database that will help supervisors schedule staff for hours. I have a field for start time (StartTime) and End time (EndTime) and want to calculate to hours worked each shift and hours of overtime worked each shift. I had the calculation for total hours worked as (EndTime-StartTime) with the result set as a number. When I enter in a start time of 5:30 and an end time of 15:00, I get 3420. Can anyone tell me what I need to do to fix this calculation? Thanks.

hi, i'm pretty sure it's really basic to do but how do i make something that will automatically enter the city from the postcode. As in...I enter 98800 and the city will be NOUMEA...I also want the list to be evolutive so if i enter a new postcode for a new city, next time, it will automatically do it. regards

What would be the best way to show discrepancy with Filemaker? If I'm over or under budget what would be the best way to format my calculations to show this? i.e. if my calculation returns an over budget number

Hi, I am new here so please bear with me. Ok, I have a Province table which contains two fields - region and provinces. Each province belongs to one of two regions (Oriental or Palearctic). There 9 different provinces. In a related table I have the related province field presented as a check box set based on a value list from the Province table. I then have the related Region field which I would like to set up as a calculation field. I am trying to get a text value (Oriental or Palearctic) to auto-enter based on the Province values selected in the check-box set of the Province field. I hope this makes sense... So I set up the Region field as a calculat…

Can anyone advise on the best method for changing colors of a field based on a calculation? Essentially we have amount1 divided by amount2 and if the amount is over 70% we want the field text to be red. If it is under then it stays black. Thank you a ton!

I have a field that has 2-3 characters followed by a hypen that I need to remove. The result needs to be the remaining text. The problem for me is because of the varying number of characters. For ex: V1-John Smith I want returned as: John Smith and V25-Bill Jones returned as: Bill Jones Thanks in advance for any help.

I know there is something totally obvious that I'm missing, but I just can't seem to figure this one out. I've got data that I've imported that shows a year as a 4 digit number (1983, 2004, etc). I need to get FileMaker to view that as a date. How can I use a calculation to say that DateField = January 1 (YearField) I've tried GetAsDate(YearField), but since FileMaker doesn't think it's a real date, that doesn't work.

Okay, now only one of my databases requires that I log onto it with an account name and password. I tried to get rid of that and got this message, [color:red]"There are no active FileMaker accounts that use the Full Access privilege set. There musst be one account like this. Create a new account or modify an existing account to use the Full Access privilege set." What the heck does THAT mean??? I don't want any of them to require a password. Elaine

Has anyone else had this problem. Running Filemaker Server 8.0 and making changes to a global field. If I close the file and reopen the changes are saved. If I quit the client 8.5 and reopen the data has reverted back to what it was originally. This never happened when the file was being shared from fmkr client 8.5 to the rest of the network. This happened as soon as I migrated this office to Server 8.0.

I am creating a simple "Training" database for my company. We would like to track employees and departments that need training. We are planning the following fields, Employee name, Department, Training Type, Date training planned, Date training completed, We would also like to run reports on employees that have training scheduled but not completed. I'm not sure how to set it up, whether or not I should be using repeating fields, etc; we have about 20 different training types, and about 5 different departments. We only need a report to display the training not completed per employee, and I can't figure out how to display the training not completed in the date …

Does anyone know how to identify when a record has been changed? I am looking for a way to populate the account name of a user in a field when he/she has modifed a record. Paul

Ok, I'm working on a simple job tracking/ticketing system. When someone creates a job, it's given a "due time". I've got another field which is "days of job. I've got a "Due time" field which is a timestamp, calculated on creation. The calculation is: =CreatedOn+(DaysOfJob*24*3600) Thus, if DaysOfJob is 1, the due date will be 24 hours after the creation date. This works fine, but I'm trying to extend it a little, which is where the problem occurs. The Problem This is for a business that is only open 9 to 5, 5 days a week. Thus, if someone creates a job of with a length of 1 on a Friday, I want it to the due date to be Monday. (Ie, skip saturda…

Hi there, I new at FileMaker, but some how managed to build a database temporarily and now have refined it so that i can use relationships, but i have a couple of issues i can't seem to solve. We are a magazine and we are using the database for ad traffic and insertion orders. I have 2 tables, one is the "client" info table and i have a portal that has the insertion #, publication, etc which then links to the "insertion order" table. Unfortunately, i can't get the client page to show the insertion info from the "insertion order" table. I've check my relationship and everything that should be the same is linked. the other question is, we've assigned ad num…

I have a list of companies and there are many duplicates. I didn't know it until I made a calc field called companyphone and in it I combines the phone and the company. Then in list view I can find where there are 2 or more and delete the duplicates automatically, I just wondered if anyone has scripted this to do this automatically. My duplicates are found in a field called "companyphone" . I have searched on here but can't find how to do this automatically for an entire file Thanks Helen

This field does *not* use repeating fields. What I need to do is show the 'prior' record, not the current one. I.e. the following are records for this related field (based on date): 1/1/2006 Content A 1/3/2006 Content B 1/5/2006 Content A So this field will show "Content B" because it is the second most current data. Hope that makes sense and thanks for the help!

Hi, I'm having a field which has file path's seperated by "return characters". I'd like to extract the actual filenames, so everything in between a "/" and a return character. Is there a function that can do this? Thanks Robin

Hi all Can't figure out how to calculate the number of days left in the current year.

This is my first post and so far I'm finding your information very usefu. I am working on a database in which show times for a presentation will be selected via a value list. In a layout I want to be able to display the number of records with 6:30 selected in that field. I have looked at doing it with Count but don't see a way to specify a specific value I want for count. And Sum didn't seem to be able to do it either. Does anyone have any clue how I might do this? Thanks.

Hi all, I'm brand spanking new (here and largely to Filemaker). Just loaded FM8.5 and am trying to get my head around GetNthRecord. At least I think that's what I need to use for this. I would like to compare the previous record in a field to the current record. If the two don't match, I want to put ### in another field. For example. Say I have a db of 500 records, and a field called Endorse has 100 records with data of 56001 in it and then 150 records with 43255, then 200 records with 68324, and the final 50 records with 93872. I'm trying to figure out how to insert ### in another field called Break, but only for the first occurrence of each of the a…

I have a table called EvaluationTranches in which I store summary data about the valuation of groups ("tranches") of patents. The patents receive a rating on one of five levels: Excellent, Good, Fair, Poor, or No Value. I hold these five rating levels in a another table, called RatingLevels. For each record in the EvaluationTranches table, I have a repeating field called ratingLevelsRep[5] in which I would like to store the each of the different rating levels mentioned above (Excellent, Good, etc.) as text values. I want to use a lookup instead of just having a relation to the RatingLevels because this is transactional data that must be kept even if the RatingLe…

Okay, this is crazy ! For the life of me I can't remember how to set a Repeating field and all to Empty ?? Set field ( Repeating_Field [0...1000] ; "" ) ?? What vale is used in the Repetition number ? There is a easy way to do this other than looping ? Xoomaster

In my database I'm looking for a sort-of serial number that will automatically insert on creation of a new record. I want the serial number to contain the date, the creator's initials, and the number record created that day, i.e. something like JM061807-1 for the first record of the day.... is there any way to do this?

These forums are great, thanks to everyone that helped me out with my previous questions and the future ones as well. I have a portal and have a button in the portal row that deletes the current portal row. When I have the data displayed in the portal the button displays at the end - that is what I want and works nicely however the button displays in one portal row below the data - the empty portal row as well. I have read here on the forums that it can be hidden via calculation have not been able to find how though. A tip on how to do it is appreciated, no need for a whole solution otherwise I will never learn. Thank you.

I have a date calculation as follows: Get_Current_Date = Get(CurrentDate) Number_Of_Days = Global field set to 20 Get_Aged_Date = Get_Current_Date - Number_Of_Days Calculation: If (Invoices::Invoice_Date ≥ Get_Aged_Date ; Sum ( LineItems::Item_Quantity_In_Stock ) ; "" ) The calculation works fine when there is only one record in LineItems table. In case of one record only: If I change the date out of range the calculation gets updated as well as when I return it. In case of two records: If I add a second record the calculation behaves correctly however if I change the first record out of range it returns "" as specified in the calculat…

Hi. I aplogise for boring some of you with a simple question, but between the three FmPro books I have here, I cannot work out how to do this. I have several small images (16 x 16 pixels) that are essentially LED indicators. I want to be able to use these in rows of data to indicate various conditions of data - eg overdue dates, inactive job etc etc. There are, lets say, 7 records (images). 1 off/inactive LED, and 6 brightly colored ones. I can create a table with a container field in which I can insert those images into, but cannot quite get my head around how to use them again. As each record may have 4 indicators alongside the text field to display var…

Hi All, I'm back with another of those questions I should know how to do but don't! I have a set of data that I have imported from our Corporate Main frame where the dates (for G-d knows what reason) are stored as such: 20031029 (equals October 29, 2003) Can someone help me with a formula that would convert these cryptic dates into something like in the parentheses or a simple date like Oct. 03. I actually need both results. Thanks, Steve

I am using a filemaker database to hold records of people on a waiting list for their children to attend one of our 3 pre-schools. When customers enquire they select one or more sites they would like their child to attend. When customers call up they want to know what position they are on the waiting list. What I want to do is be able to have 3 fields, one for each site, on the customers record page that gives the position on the waiting list from the result of a 'Find' by that site and sort by date added (customers are put on the list based on a first come first served) The idea is that a person would sign up for Site A, Site B but not Site C and on their…

First, as a new Filemaker user I have been using this forum almost every day and would like you all to know that your help is very much appreciated. Thanks. Now the problem. Probably an easy answer but as I said I am new. Have a database with a field called ACTIVE. I would like to have that be a calculation field that says [color:red]ACTIVE (TEXT) when today’s date falls between the dates in the fields Joindate and Expiration date. I just can’t figure out the calc. How do I calculate for today’s date and where does it go? I am thinking it must be a variable but I have very, very, very little programming experience and no formal or even informal train…

Blank once again..... Field 1: imports a URL but with 6 extra #'s i.e. /images/1234AL.jpg475311 Field 2: calculation to remove them - I'm blank! Thanks

Is there any way to populate a repeating field from some other data source in a FM6 database? If you have any suggestions other than manual input or copying from another repeating field, I'd love to hear about them. Thanks for your time.

Hi, I am helping someone who is using Filemaker version 6 on a PC. She needs to have a field that is a calculation that results in the given year as of November 1st of any particular year. For example, on Until Nov. 1, 2007, the field will have 2006 in it. I thought I could set a calculation field that is: If Nov 1, year, - but then I need it to do nothing if it is not nov. 1. Any ideas?

Good day! I am in the process of setting two fields to auto enter a total (number) for two conditions: A particular drop-down selection is made and based upon a location field. example: I have a field named "Charges" and it has drop-down values of 95805, 95810, 95811. If I select "95810" I want it to populate two fields "Global Fee" with one specific charge and "Partner Fee" with another specific charge and in addition must evaluate a field called "location" to determine charges specific to that location. So I could have the follow senario in my table. (ignore the periods, they are only there to space out the data) Charges | Location | Global Fee | …

I am sorry to ask again but I am up against a deadline and I can't seem to get this right. How would I convert 200303 to Mar03? I Hate that I can't figure this out on my own...maybe it is because I am so crushed for time and am stressing. Either way...Help! Steve

Hi! ¿Does somebody knows if there is any way to auto-enter a value in all repetitions of a repeating field? I've tried the auto-enter option with both "Data" and "Calculated Result" but only the first repetition is affected Thanks.

[color:blue]Greetings I have exhausted myself searching on Google. This topic has been regurgitated many times but I cannot seem to find the solution that I am looking for. Forgive me - I am an FM newbie who is fascinated by stats and before I can get to the calculations that I want to perform, I need to calculate every single possible combination of the 49/6 lotto. I know that there are 13,983,816 combo's... I just want to create a database with every single combo. Please note that I am quite familar with combinations, permutations and the formulae associated with these functions. All sites appear to focus primarily on how many possible combinations of 6 …

Hi all, I'm trying to create a calculated field that could also be displayed in someway to the user, where he/she can make changes to the calculation itself without needing to fiddle around with "Define Fields" option. Is this a possibility ? Any advice appreciated! Andreas

Hi Guys, I am very new to Filemaker and am busy setting up a simple database. I have created 3 fields: 1) Date Time, 2) Date and 3) Time. I have a comma-delimmeted txt file with data that I have imported into this database (the date and time information from this txt file has gone into the "Date Time" field in the database. I need to separate the date information into the "Date" field and the time info into the "Time" field. I know I need to use a script which uses the left field command. Please could you advise me on how to go about this. I am using FM Pro 8. Thanks Shaun

Hi all, I was so impressed with the friendly, knowledgable help here on a previous question that I thought I'd try again. -D I have a Javascript rule that I was using for something else that I'm trying to convert into "Filemaker-speak" for an FM project. Basically I'm doing this modulo calculation: if (CurrentRecordNumber() % 1100 == 0) return 1100 else return CurrentRecordNumber() % 1100; What I'd like is to have Filemaker do the equivalent, but instead of me having to supply a static number like I'm doing in the above, I'd like Filemaker to replace the static 1100 above with a calculation that gets the total number of records in the file…

I have an inventory database that tracks hardware and software for contacts across the company. There is one table "Software" that has key fields relating to each piece of software (i.e: Adobe ID, Quark ID, Office ID, etc). Is there a way to create either a calculation field or that populates based on a query? I currently have a manual field in several of the tables called "Duplicate" but I would like for these fields to populate automatically. I have also figured out how to script this - but I would prefer a calculation field if possible.

I have a weird situation going on with a text field. I have contractors name, address etc., if the remit to is different I have a set of remit to fields. If the remit to is the same as the contactors name, address etc., I have a script that sets the information in the remit to fields. The problem I have is the remit to zip code field changes to a question mark sometimes but not always. Has anyone has a similar thing happen?

Is it possible to trigger an auto-enter field by an unstored calculation field with an aggregate function (list, count) in it. Both fields are in the same table. So far I cannot get it to work. Henk

I'm frustrated I couldn't figure this one out since I have a few Trim functions for counting in from the left, but in this case I want to always Trim the last 4 characters from text in a field. After I import images I have text in the File Name field, such as: 1-3.jpeg 12-1.jpeg 137-5.jpeg I want to end up with the trimmed text (below) in a field called Name. Since counting in from the Left won't always be the same, I just want to Trim off the last 4 characters, leaving: 1-3 12-1 137-5 What is the correct Trim function layout to achieve this. Many thanks. Mark

Im not sure if this is where thsi question should be posted but I am sorta stuck. I have no formal FM training and i am trying to do something here and I havent been able to figure it out. I have a simple inventory database that I made. I have a field called "In Stock" that shows how many items of a certain product I have in stock. I want to always have so many of each item in stock.. I want a minimum number of items and a maximum number. when the items reach the minimum I want to order more of those items. so what I have done is made two new fields "Min" and "Max" Min and Max will be filled it with preset numbers. They will vary from item to item. What I woui…

Hi, I'm new to this and I need to have a (calculation?) field which sums a portal on the layout. The trick is: the Sum field needs to evaluate on record creation without evaluating deletion of portal rows. Basically, it should only reflect increases and not decreases (all entries will be positive values). I've looked at auto-entry and lookup approaches but can't seem to make them work. Thanks Mike

How can I locate words in a field and then automate putting in a hyphen between the words so I can use it in a URL. Like New Hartford becomes New-Hartford New York " New-York but Albany becomes Albany Thank you PS the hyphen should only happen with more than one word like District-of-Columbia not on one word like Washington

Does anyone know how to determine the number of variables in a Filemaker array?

I'm very new, so be gentle. I'm trying to find times during which I have more than 2 tests booked after 4:30 pm. If this is the case than I have to recruit an extra person to work during that extended test period. I tried using a simple logic statement to find and count the time field, but I consistantly encounter errors (e.g. 9 or 9:30 am is counted as well.) I just used this... Case(timefield >= "4:30 pm";1;"") Though the time entered could have been keyed-in as 4:30pm, 4:30 p.m., etc., the time was formatted as 4:30 pm Can I not use Case for a time field? Thanks for your help Amy :o

Where would be the best place to store information used in calculations such as tax rate and certain set prices that need to be same for the whole db and all users. I read here on the forums that they should not be stored in global fields but somewhere else as there might be problems when sharing the db. The values are same for all users and records however they change sometimes for example when the tax rate goes up we need to be able to edit it quickly and put in the new value.

Hey Guys, This is my first time using a forum and I have a quick question.. in which im stuck on. I have 4 fields, called ' Actioning officer , Responsible officer, Service, Depot '. They are all drop down menus, with the required names and so forth. My Q is - If I select a name in the ' Actioning Officer '.. I want it to automatically give me the data for the other three fields. How do I go by doing this?

Hello! Is it possible to define a "Set Field" script by a calculation? I have a button with an array of data. And one of the pieces of information I would like to put in the array is what data to set in which field. But sometimes this button will place this data in a different field. I would like to tell the array which field to put the data in. Is this possible? Thanks for the help in advance!

I have a simple phone book and contact database and I'm always copying text from other sources (email, documents, etc.) and pasting it into my database. The problem is that when I paste the text it pastes in the ame color and style of the original text and not that of the field formatting I set up in FM. How can I keep this consistent do I don't have different colors and styles all over the place?

Lets assume I have a number of users in the Accounts and Privileges section - excluding Guest (is this the only builtin account that cannot be removed), and want to count them. Normally I would do a search on a table that had some of those entries in there and count them tat way, but in this case, one or more of these users may not have entries in the table. How do I count how many users are in the security database, and preferably a list of those users too. Greg

I am importing data that contains names in a reversed order. "Smith, John H" and "Smith, Esq., John H" I have created a calculation field that uses the Trim and Case functions to get "John H" Trim (Case ( PatternCount ( Reg Name 1; ","); Right ( Reg Name 1; Length (Reg Name 1) - Position (Reg Name 1; ","; 1; 1 ) ); Reg Name 1 )) I have a second calculation field that uses the Left function to get "Smith" Left ( Reg Name 1 ; Position ( Reg Name 1; "," ; 1 ; 1 ) - 1 ) I use a third calcuation field that puts these together. (First Name & " " & Last Name) The problem is those records that have an additional title like "Esq." or "IV" - ba…

Hello I have a situation where I cannot understand how to do something in text formatting. I would like to copy all the left words up to a comma and put it in a new field called "before comma" There are always different amount of words but I would like everything copied up to the comma for examples: three blind mice, and so on - yields "Three Blind mice" I pledge alligiance, to the flag - yield "I pledge alliagiance" Can someone help me with this one. Thanks

I was wondering if anyone would know of a calculation that could reduce fractions to whole numbers and fractions after a fraction has been multiplied. As an example... 1/3 x 5 = 1 2/3 Thank you for your help. Mitch

Hi, I am trying to create a Name Formatting function for Dutch names. Dutch names often have single quotes ' in it. example: Maarten 't Hart or Henk-Jan van d'r Vaart Filemaker does not seem to recognize single quotes in calculations. (reserved character) Anyone knows how to substitute a single quote ' in a text. Henk

Hello: This is my first post on a FM Forum. I have buttons that run reports (Scripts) based on two fields. 1) Status 2) Quote Principal. There are 44 buttons total that run specific reports for my business. I would like to look at each button and see a number displayed that tells me how many records currently exist that match the criteria of that button. I have an example of a calculation field that counts records that I have been trying to modify, but, I can't seem to make it count the number of records matching the two values. Currently I have made a new calculation field for one partular button called label 3d ip. This is my calculation so far which is bringing up…

For the last two weeks I've been combing through the posts here, trying to find a solution for my date calculation challenge. There are many great ideas and I have them working, but I'm wondering if there is a better way. I am attempting to create a production schedule for a book. All the dates in the production cycle are based on the last date (catalog date). Ultimately, I want to enter the Catalog Date and have the other date fields fill in based on it. For instance, the Delivery Date is 1 month prior to the Catalog Date. The To Printer Date is 4 weeks prior to the Delivery Date. The To Production Date is 1 week prior to the To Printer Date. And so it goes for a st…

Hi, I am trying to do the following. I have a one to many relationship between Inventory and Invoices tables. They are connected as follows: (Table Name)Field Name (Customers)Customer_ID to (Sales Orders)Customer_ID (Sales Order)Po_Number to (Line Items)Po_Number (Line Items)Inventory_Number to (Inventory)Inventory_Number Table Sales Orders Contains the Date field which is set to automatic date creation upon record creation. I want to set the following calculation/script Current_Date (gets the current system date) Age_Date (Does the calculation Current_Date - Days) Days field is a global field that contains number 20 So if…

Hello, all-- I have an unstored calculation field called c_allOpenWindowNames on LayoutA: WindowNames("myDatabase.fp7") Obviously, it shows the names of all open windows. But if a user navigates to one of those open windows before clicking on one of several buttons in LayoutA, he/she will change the window order and that change will not be reflected in c_allOpenWindowNames, yielding an unexpected result when the button is clicked. So my question is: Is it possible to force the unstored calc to refresh the moment the user switches back to LayoutA --so it accurately reflects the newly changed window stacking order? Hope that makes sense. Many thanks--

I have a field that can take text values from a predefined list. I would like to count the number of times that each value of that list is selected in all the records in the database. Basically, it is like getting a histogram of the values in a certain field. Any suggestions will be appreciated. MD

I have a numeric type field and i want to fill the field with a 4 digit number.if the input of the number is less than 4 digits or bigger than 4 digits i want to allert me that the input is not correct.i have validate the field that the max number of characters is 4.How do i validate the field that the minimum number of characters is also 4?Can anyone help?

How can I set a value in a repeating field based on a calculated index? I.e. I want to . Filemaker only seems to let me specify a target field repetition using a fixed number. I want to calculate a number and use this to set a value in field_Repetition [n]....

Hello From the internet I have an address like this Spring Farm Cares Address: 3364 State Route 12, Clinton, NY 13323 Phone: (315) 737-0829 They are in the yellow pages so they are always this way I want to take out the word "Address:" and "phone" and put Spring Farm Cares into a field "Company" 3364 State Route 12 into a field called "Address" Clinton into a field called "City" NY into a field called "STATE" and (315) 737-0829 into a field called phone They are always in this format. But my problem is that they have different amount of words before the comma in the address field. Thanks Dave

I did search the forums for an answer to this, but I didn't see anything that related specifically to my situation, so I'm hoping someone can help me out. I work with a non-profit membership association. We use Filemaker to maintain all of their records regarding membership, meeting attendance, etc. Each record in the database represents a person. There are about 10,000 records, some are current members, some are past members, and some are just non-member contacts. Each person (record) in the database has a unique ID number that is an auto-enter serial number generated upon creation of a record. Now - the assosication has an upcoming meeting that will be abo…

Hi all- I have what seems to be a straightforward problem, but I can't seem to figure it out. I have a Sales Report layout which shows records from the table LineItem, sorted by Order number. Trailing subsummaries for each Order group show totals of cost and sales, and a Trailing Grand Summary shows totals for all of the Orders displayed. All of these summary fields are defined in the LineItem table and work fine. Now I need to show at the end of the report a total of the Orders displayed. Although this seems easy I can't figure it out. A GetFoundCount returns the total LineItems displayed, as does a Count of the _kf_Order field. What type of field do I need to create…

I need to create a year to date calculation but can not find any resources on how to do this. I have a contact DB with a one to many relationship to a donations DB. I need to get a total by year, and also a YTD total of donations. Any ideas on how to go about this?

Hi We have a job management system. Each new record that's created is given an auto-entered serial number. At the moment if a job is cancelled during entry or delted we lose the job number forever - giving us gaps in our number sequence. If a user creates a new job I want to be able to let them either cancel the entry or delete a record but not delete/lose the job number. Is there anyway of ensuring that when a record is deleted the auto numbering does not move on to the next number when a new record is created? CHeers Rich

I am trying to come up with a way to help my administrators compare test scores from 2 different years. What I have is a database with test scores for students. It has studentid and then then different fields for the scores. Achlevel_read (which can be a number from 1-5) Achlevel_math (which can be a number from 1-5) I need a way to count the number of students at each achlevel. So how many level 1 how many level 2 etc. This will be done for a found set of Teacher. So we want to be able to see how many students a teacher has at each level. So I find teacher Johnson's 5 classes and I want to display how many level 1's 2's 3's etc. are in his …

Greetings, I have been working on a calculation for at least 4 days and still can't seem to make it work? I need to generate statements for work and soon! I would like to throw out the senerio and see if anyone can calculate this. If the (# of units) are 25 or less, the fee is 175.00 but if the (# of units) are between 26 and 49, the fee is now (# of units) times 7.00, if the (# of units) are between 50 and 100, the fee is now 11.80, and if the (# units) are above 101, the fee an additional 4.80 per(# units) above and beyond 101. (ie: 102 x 11.80 + 4.80 + 4.80 = 1189.60) Is there anyone that loves math challenges? (I don't! especially after 4 plus days of this!)Please …

I am trying to get a filed to display the last admission dates and I get nada. What I have for the field calc. is : field= If ( (Count ( Admission date))<2; ""; GetNthRecord ( Admission date; (Count ( Admission date))-1) ) I thought this would go: If there is only one record return nothing if more than one go to the end of the repeating field Admission date and get the second from last. I am desperatly confused, please help.

Hello. I'm rather new at FMpro. I'm using 5.5 and i'm developing a database in which i would like to upload a PDF attachment to my entries. i've read that 5.5 could upload PDF's into a "container" field. i've created a "container" field but how do i upload my PDF? i tried inserting using all of the options, picture, quicktime movie, but no luck... all my PDF's are greyed out. any suggestions? thanks! peace. -

Hi there, I am using filemaker to import a text log file, I need when the data is imported into the form to get the number of time it see one unique word in one of the field. exemple: in the field "Station ID" that field contain 6000 or more of station ID number "201" "203" "207" I need to calculate the number of time in all the records the number of time it see 201 the only way I was able to do that manualy is by going in Find mode put the number 201 and search, I need to that search for each of the station this take time do a search for each station and I need to make it easy to use. Hope somebody could help me

A popular book on FileMaker states: GetAsNumber ( Get ( Current Date) ) returns 731689 when the date is 4/18/2004 And later states that the Month function can accept "an integer that represents a serialized date value". For example: Month ( 718977 ) returns 6 But they don't include any definition of "serialized date value" in order to follow the calculation. What I'm seeking is a reliable way to turn a date into an integer -- and then get the date back again. The exact format doesn't matter, but extracting the usable date does. I suppose I can use a Month + Day + Year method to reconstruct the date, but I'd like to understand the basis for doing so…

A calculated unstored field like: Case(Get(CurrentTime)> Time(05;10;10); "finished") and I want another indexed field get update automatically with the word "finished". But please it could not be done with buttons or entering in any field. I've tried something with eventscript but it's only works when I enter in a field. (sorry with my english)

Greetings Am a real newbie so I apologise if this questions appears daft to many of you! I am interested in using the Button Set-up "Send Mail" function. In our company's system we create orders for products from suppliers. One of the fields within the order is the sales person's name: "creator" which is "Indexed, Creation Name, Can't Modify Auto". The problem we experience is that our stock controllers don't always alert us when items come in which are attached to an order and which can then be allocated to an invoice and delivered to the client (goodness I hope I'm making sense!). I want to have an "email sales person" button which can be clicked when the sto…

Hi all: I need some direction on this: Fields involved are Client_Name, Client_Number, Encounter_Date, and Encounter_Text. Each time a client is seen a new record is created in Layout "B" with the above fields. I want to create a field that will combine all Encounter_Text for all encounter dates for particular Client_Number for print-out.

I'm looking for a way to count records that meet a certain criteria. I have a field (rating) that uses numbers 7 - 10 to identify the motivation of clients. I need a summary type field that will display a found count of all the client records that have a rating = 7, another field that counts rating = 8, etc.. I'd prefer to do this without creating a relationship for each summary field.

Hi, I would appreciate if someone could help me out with the matter below. Thank you in advance. I am making a simple DB for the office. It consists out of two tables. Please see below, field names are in Bold. Table 1 Company ItemCode ItemName ItemCost Table 2 Company OrderDate OrderBy OrderTotal The tables are releated through Company: Table1:Company = Table2:Company I want to do the following: In Table2 I want to insert a portal or a repeating field (whichever would work better). The Portal would have the field ItemCode from Table1 - that field would be formatted as a member of value list (Value list would contain Fiel…

Does anyone know if the Get(AccountName) function works with multiple users logged on a database? In other words, if there are 5 users logged onto the DB and one clicks a button calling the Get(AccountName) function, does the function retrieve the user name of the person clicking the button or any of the 5 logged onto the DB? Also, do you know if the 'Perform Script' upon open/closing the DB property under 'File Options' works just when the first user opens the DB/file or when any user logs onto the DB regardless of whether there are others already logged on? Paul

Hello I have a budget layout in FM where I want to the ability to lock certain users out (view, but no updating) of specific budget records when they press a button. We want them to create a budget in this form but when they press a 'submit/commit' button they cannot change the budget values any longer. However, they will still need to access/update other budget records on the same form. I have not thought of a way to do this yet.