Calculation Engine (Define Fields)

I need to have a calculation performed after a delay. About 5-10sec once the new record is created. I can't use "pause" in the Scripts because it must work over IWP. Is there a way to incorporate a delay into the calculation? It doesn't have to be a precise delay. It just have to give the web viewer enough time to load a page before the calculation is performed. Thanks

I have a repeating field defined where the user can enter the number of hours worked. I need to take than entry and multiply it by a separate field that contains a standard hourly rate (non-repeating) to arrive at a total dollar figure. The first repeating field entry works, but none of the others do.

Hi: I have imported some data and the field look like: 847*30000*891*15000*848*2500* What functions would I use so it looks like: 847: $300.00 | 891: $150.00 | 848: $25.00

I need to record "machine readings" taken on a periodic basis: eg: Date 10/7/2008 ; Reading 202 Date 13/7/2008 ; Reading 199 Sate 14/7/2008 ; Reading 170 etc The dates are not necessarily taken every day, but the rate of change in the usage readings is affected by the amount of time that has passed So on entering the second reading I also want to store the number of days since the previous reading ie 3 If reading 2 were deleted then I would want the "days" for reading 3 to change from 1 to 4. Is it possible to have a calculation field do this or does it need to be some sort of script? Any pointers please many thanks Si…

Holy moly... Having a hard time with even explaining this one... I need to come up with a calculation based on the following: Table Has Username; TimestampIn; TimestampOut; Date There are maximum of 4 records per user per date, for example: jsmith; 1/1/08 8:00:00 AM; 1/1/08 9:15:00 AM; 1/1/2008 jsmith; 1/1/08 9:30:00 AM; 1/1/08 11:30:00 AM; 1/1/2008 jsmith; 1/1/08 12:00:00 PM; 1/1/08 1:15:00 PM; 1/1/2008 jsmith; 1/1/08 1:30:00 PM; 1/1/08 3:30:00 PM; 1/1/2008 I have added 40 fields in the following format: TimeMonIn1; TimeMonOut1; TimeMonIn2; TimeMonOut2 etc up to in/out 4 for each week day I want to auto-calc in the time fields, such as timeMon…

How can I do exports of container fields in Filemaker Pro 8? If you can't do an export, any recommendations of how to get images over?

Does anyone know how to sum a group of numbers that are in a text field and separated by a carrirage return? Example: TextField1: 1 2 3 Calculation should result in 6.

I am new to file maker pro, but so far think it will be very helpful and am already looking here for help because the FMP phone tech was not very helpful. I am hoping someone here can be... I am running FMP 9.0 on XP, and have a database of highschool students. One of my desired fields is to have the birthdate of the student and their current age based on todays date. I set the field up to "calculation" and assumed I could put the following calculation: age = // - Birthdate When I did this I would get a number like 4783. In this first case, the student's b-day wassomething like 4/17/1995 Can anyone offer me assistance on how to properly write the ca…

Hi Group, I'm trying to figure out a calculation to remove ones credentials from their name. My database contains mostly physicians names in a single field called Referral. The names have been entered using various formats, including: FirstName LastName, MD; FirstName MiddleInitial LastName, MD; or CompanyName. Some have different credentials: Psy.D., DO, Ph.D., or NP. Some of them have periods in their credentials and others don't. How can I extract just the name from this data? The reason that I need to do this is because some insurance companies will reject a claim if it has credentials listed in the name of the referral source (sound frivolous? I tota…

Hi, is there a way to get a field modification date rather than a record modification date. Thanks in advance

What does the expression Not(Get(foundcount)) mean?

Hi I am steve. I have a text field which is an id field. I want it to have serial number which is made up of the data from a global field thne i want it to have a number. Then in the next record to increment by one. I guess it is a calculation but i don't know how to do it. Can anyone help

Hello. I want to know if its possible with filemaker to make html reports to send them via email. I have to send a report daily to many people through email, right now im doing it in filemaker but exporting it as pdf, i know how to code in html, but is there a way make this reports in html with filemaker? Thanks

I was experimenting (in TEST, thankfully) with a TEXT field that had a new requirement to change color of certain values to RED. I changed the field type to CALCULATION and set up a CASE statement to do the color change: CASE(LeftWords(myfieldname;1)="myfieldvalue"; TextColor ("myfieldvalue"; RGB (255; 0; 0))) FileMaker warned me that this would cause it to re-evaluate all existing values. WHAT I EXPECTED: All the target values to be changed to RED, and all other values to be evaluated and then left alone. WHAT HAPPENED: The target values were all changed to RED. All other values were DELETED. I only had the CASE set to act on the one v…

When importing images from a folder - reference only: If you have a folder with an image called "image1.ai" (or whatever) in it and a sub folder with a different image called image1.ai, Filemaker only finds the image that is higher up the path even though the imported file path is correct. Is there a way of overcoming that so the image that filemaker displays is the image that is further down the directory?

What calculation would I need to convert inches into feet & Inches in a field? Like 24 to 2” 0”

I have attached the fp7 file in hopes someone can tell me why my calc field is not working correctly. Instead of it showing: Record X of Y (Z records total) its showing X of X and X total I am using: "Record " & Get (RecordNumber) & " of " & Get (FoundCount) &¶& "(" & Get (TotalRecordCount) & " records in total)" magicvault.zip

I came across and old topic that Genx posted that used the following script but i would like to have it so once it is saved it will continue and email the custom named .pdf file to a certain email address without having to do it manually. the below script is what i have so far and it works great for saving a pdf file of the playlist i have with the title of the playlist as the name of the pdf file. Go to Related Record [ From table: “Playlist_Manager”; Using layout: “Print_Playlist” (Playlist_Manager) ] [ Show only related records ] Set Variable [ $Path; Value:"filewin:/C:/Documents and Settings/Mark Johnson/Desktop/Life Church/" ] Set Variable [ $Filename; …

What are the size limitations for a FileMaker record? How large can a single field be? I am looking for ways to create a text field for 'notes' where the field can have additional data appended after existing data instead of creating individual notes records for each update in a related table. Thank you.

Hi, I am trying to setup a DB with many date and calculation fields in a array structure and would like to use repeating fields for this. Can somebody tell me if it is possible to auto enter and calculate values in all repetitions of a repeating field? Thank you very much. Detlef

Hi. Im having a problem getting my head around something. I have a table with two (relevant) fields - one a date, and the other a duration. The table is sorted descending by the date field, and the duration is supposed to contain the difference in days from the date of that record, and the date of the previous record. eg. 15/3/08 6 9/3/08 4 5/3/08 2 3/3/08 0 Note that as the first record (sorted) cannot compare to a pevious date so it's value is zero - no problem there. Whats actually happening is that I have used a loop to start from the first record and move through to the last inserting into the field the date subtract p…

Hi: I have a cost field on an Invoice Table which is a look-up from a Pricing Table. How should i handle the cost increase of 4% that is effective on September 1 while still maintaining the present price structure.

Hi, I'd like to create a serial number using today's date and a record number (this is client preference, regardless of whether it's the best way to to do it). I need to create this serial number only if the word "fax" appears in a reference field ("fax" would always be the last three characters in that reference field.) The serial number cannot contain any slashes or dashes. So ultimately....if "fax" is in reference field, I need 082708001, then 082708002, etc. in the serial number field; else it should remain blank. Please help...I can't figure out how to do this without getting slashes in the serial number. The serial number field must remain a text field. Thanks so mu…

I have a Create New Record script that when it runs the first step it takes is it uses the 'Set Next Serial Value' script step using the Max Calculation: Max (MATERIALREQUESTFORMS::MatlReq_Form# ) + 1 Then in a subsequent step it then uses the 'New Record/Request' script step to create the new record. The problem I have is while I originally defined the field to use leading zeros in the serial number (by setting next value to 0006 for example) when the script runs it strips away the zeros and the next value I get is 7. I there a way to add leading zeros via a calculation or is there some other way to do this?

Hi I have a similar question to Garyaj posted earlier on this site. I have looked for an answer to my question but this is the nearest i can find and is not quite it. I have an order databse in which there is a portal. I have created a relationship with this portal using an order id number. The portal features a date field then a pulldown menu, that show four stages - order taken, goods picked, goods despatched, payment processed. It's objective is to record the date at which each of these stages is reached. I would like to be able to have a field that measures the number of days, possibly even working days, between the events for each order. i.e. if …

Hi, I have an amount which needs to be compounded yearly, but only reporting each 5 year term (for 20 years). I can obviously create a field for each year and only report back those 6th, 11th and 16th year, but am wondering if there's a cleaner way of doing it. AS an example: The base is [color:blue]$10,000, the percent increase is [color:blue]5% annually [color:blue](< [color:red]Rent01 = $10,000 Rent02 = Rent01 + 5% Rent03 = Rent02 + 5% Rent04 = Rent03 + 5% Rent05 = Rent04 + 5% [color:red]Rent06 = Rent05 + 5% Rent07 = Rent06 + 5% Rent08 = Rent07 + 5% Rent09 = Rent08 + 5% Rent10 = Rent09 + 5% [color:red]Rent11 = Rent10 + 5% R…

I know this is probably a simple question, but I'm new to actually messing with the guts of filemaker. I work for a university, and we have a drop down field with a finite number of Majors we can choose. These major are listed like "JOUR Journalism". Now I've created another field called "College" that I want to automatically be filled in with the appropriate college that the particular major falls into (So, selecting JOUR Journalism from the drop-down menu for major would then automatically fill out "College of Communication and Education" in the College field. My question is basically how I go about doing this. There isn't anything else in the database that wo…

I don't know how to explain this other than comment on the following code: Case( Assay="F"; Case(F < Low; "Low"; F > High; "High";"Excellent"); Assay="A"; Case(A < Low; "Low"; A > High; "High"; "Excellent"); Assay="C"; Case(C < Low; "Low";C > High; "High"; "Excellent"); Assay="All"; "F:" & Case(F < Low; "Low"; F > High; "High";"Excellent"); & " A:" & Case(A < Low; "Low"; A > High; "High"; "Excellent"); & " C:" & Case(C < Low; "Low";C > High; "High"; "Excellent") ) IF I run the above with Assay = F or A or C, I get results like "low" and "…

I started having a situation today where field content in two of my fields would only show up if i clicked in the field. sometimes i can get the second field (which is based off of the first field) to show itself like normal, which demonstrates that the first field has the values there but simply are not visible, until clicked on. I've never seen this before. Is this a bug? Or from something else?

I'm not sure whether this is under 'calculations' or 'finding' but I think this is right. I've got a table of SoilSamples, with fields like 'Season', 'Climate', 'BacteriaLevel' and 'FungiLevel'. I've got another table 'Ranges' that also has 'Season', 'Climate', as well as 'Test', 'low' and 'high'. The idea is that for each soil sample record, I identify whether the bacteria level and the fungi level is low, normal, or high. So, I've related the two tables thru Season and Climate, and I've set up Case calculations that compare the low and high values with the recorded value to spit out a text answer into BacteriaLevel and FungiLevel. The problem is th…

I use my client's first names in a web address that makes their homepage. When creating the URL I convert their name that starts in a capital letter with the "TextStyleAdd ( text ; Lowercase )" function. The resulting URL in the field resulting from the calculation is without any capital letters. However, when viewing in the web browser the resulting field brings back the capital letter at the beginning of the name making the browser unable to show the page. In fact, if I copy and paste the URL with all lowercase letters and paste it into any word processing document it paste with the original capital letter. Is there a workaround? Is this just the way it is? Thank…

Is there a direct way to, outside of field validation, test if a string is a member of a value list? I started looking at using ValueListItems in a calculation, but I didn't figure out a way to pull it off. Thanks, Ken

Hi.. apologies in advance if this is really basic. I have a basic calculation that uses simple math based on two fields to show a ratio. However, the two fields are not always populated. Problem is, there are times when one of the fields is populated and the other is not. I want the result (calculated field) to be blank unless BOTH fields are populated. The "do not evaluate..." option only give me the result I want if both are blank, but if one is blank I get question marks in the result, which are annoying. Can someone point me to the SIMPLEST way to get blanks to come up unless both fields are populated? Would appreciate any advice...

Hi there, Here is a calc field that is not very efficient. Is there a way to simplify it? I mean one case for Black, Red and Yellow. Case ( Color < 6 ; "Blue" ; Color = 6 ; "Black" ; Color = 7 ; "Black" ; Color = 8 ; "Black" ; Color = 9 ; "Red" ; Color = 10 ; "Red" ; Color = 11 ; "Red" ; Color = 12 ; "Red" ; Color = 13 ; "Red" ; Color = 14 ; "Yellow" ; Color = 15 ; "Yellow" ; Color = 16 ; "Yellow") The calc result must be Text as you can see.

I'm terrible at Filemaker's calculations. I'm needing to auto-enter a serial number, but it needs to be the lowest available unique number. So, say for example, a record gets deleted, I would like the next new record to get it's number. What would this calculation look like? Say we have a library with call numbers 1-10 and the record with call number 5 has been removed. The next new record needs to get call number 5 instead of 11. Thanks for any help you guys can give!

Once again I bow to FM gurus to tell me why my simple IF statements always return zero. See attached files. Thanks PayrollDeduc.ZIP

I'm working on a project here at work - Have a table with ~520 fields (not my work or design.) One problem is probably ~250 fields are indexed. Is there an easy way or a way to make a script to unindex fields? Using FM Pro 9 Advanced.

I have a layout which displays accumulated/cumulative absences for students in list view. On each row it shows the absence date, studentname, classname, teachername, absent checkbox (with VL value of 1), absence reason. Example: If a student is absent from 3 classes on one day, he will have three records/rows for that date – same date, same studentname, different classname, different teachername, checkbox checked, same or different absence reason. Without creating a sub summary report, I’d like to have a field that shows the total absences for each student on another layout in the same table in browse mode. I’ve tried Summary field, Sum, Total, Count, but can’t se…

Hi - Altho I've used various databases for many years, I'm new to Filemaker (and the mac). I spent last week learning and loving it, but I have a basic question. In prior applications, I had an option for text or memo fields. If I remember correctly, text fields were limited to 256 characters in length (or somethign like that) If I had a field that would usually have no contents, but might have some or a lot, I'd create a memo field - so that the size of my database would not get 'bloated' with a field that was set to 250, and was usually empty - because my understanding was that the file 'grew' to be able to hold the data - regardless of whether or not the f…

Hi - we are a b to b company, my salesmen need to select ( with check box) records and then fax off a list of the selected records. My problem is that when one user selects records, it is selected for all users. So if I select 10 records to fax my customer, meanwhile another user selects 5 other records, if i go to print/fax i will end up with my 10, and his 5. We have 10 users and using filemaker 9. Thanks

Hi, in a report we have the result of avg in percentages, showing as decimals, one digit. e.g : 95,5 One of the requirements for a specific report is that those numbers have to show as 'base' 10, with decimals: e.g. 9,5 but.... if the result is 100, it has to show up without decimals. e.g. 10. I tried the format number 'Do not display number if zero', but that doesn't do the trick. I probably need a sort of 'advanced' calculation... TIA

Hello - I have set up a script to insert text into a field which was working fine and all of sudden has stopped working. I deleted the script in case something was corrupted and re-created, but function is still not working. Anyone have similar problem? Thanks

I have a Database with a container field called "chart_container". I also have one called "Chart_Page_Number". Both fields are on a layout called Chart View. I have a button called Insert file on the song manager layout. I want to be able to add multiple charts to the same song im currently on and add the next page number for me with out me having to do it all. the ones you see in the database now were all done directly from the chart view not in the song manager layout. I hope i didnt confuse anyone.In a nutshell, i want to click "Insert file" find page 1 pdf file and insert it with page number 1 if no files are attached currently, if it already has …

I cannot seem to find my notes relating to an age calculation formula. I have layout containing a (Date of Birth) "date field" and an (Age) "calculation field." Can anyone tell me how to make the Age field display an individual's current age?

Hi, I have a database where equipment checkouts are linked to student information based on their ID#. I am trying to set up a trigger so that if a new student is entered and their ID# is not in the studetn info database the client running the equipment checkout will be asked to create a new student record. The 2 dbases are linked via the Student ID#, simple 2 table design with a portal in tab views. Thanks!

I need a formula that will find the next higher date on a list from today and return it to a field in a separate table. Table 1=Publication dates, table 2=Subscribers with start issue date. this will let me calculate when reminder letters go out and when to stop mailing. I've generated a today field the P table and can find current issue through a very clunky lookup process, but I think there's something a lot better out there. Any help appreciated.

Hi there a really basic question regarding boolean and text fields. What is the simplest way to set text into a field depending on the value of one or more boolean fields in the table? I am trying to create a text field of true when two fields = 1. Needs to be in text format so it can be exported clearly to Excel as words rather than numbers. Copy of database attached. Test_Tag_Mod3working.fp7.zip

FM7 database. Has a global storage number field to hold the tax rate. I created a record with two line items (both quantity of 1) $23,595 and $4,990. (Note that this table uses repeating fields; I'm going to be changing that.) Then I realized the tax rate was wrong (it needs to be .09 (9%)). I took the database offline, changed the rate it in FMPro, reserved it, however the calculated tax will not change: it should be $2,572.65. If I create a new record with those same figures, the updated tax amount is correct. If I modify the original record so that both line items are $5.00, the tax is $.90 -- which is correct. The latter seems very odd; unless I'm overlooking somethin…

Hi I would like to be able to calculate the number of days that have passed between a new record and the previous one only and have that figure displayed in the latest record. any advice as to the neatest way to do this? Thanks as always.

I have a window that opens and shows filtered records using a Find step to tweek out only records that have a certain date. I would like to put the number of records found on the window name but I only get back the whole number of records in my table. I have added a field called RecordCount and have used Get(Foundcount) as the calc.

I am wondering if there is a way to alphabetically sort repeating fields. I have a table called 'products' and a field called "specification" which has 12 repetitions listing various spec on a product. Via a checkbox field the user can tick the features that the particular product has. To keep the records tidy (and for reasons below) , I would like the ticked options sorted as I can't trust the user to click on the options in the right order every time. Also I would like to use a global field with the same repetitions in conjunction with conditional formatting as I have a layout with all the products listed. At the footer I would like a global field tha…

This Calc is driving me insane. Look forward to some pointers. I need to calculate the hours between two dates but only the working hours. Also the weekends and holidays would have to be deducted. I've got StartWorkTime and EndWorkTime per resouce also got a List of all theyre holidays. Now I need to combine both and get all this to give me the hours in return. So say a Job starts 18.8.08 at 13:00 (timestamp) and ends at 26.8.08 17:00 and the the Start time is 7:00 and end is 15:00 = 10:00 h / day. Now the guy has 19.8.08 and 20.8.08 vacation. This should result with: 18.8.08 = 4h, 19.8.08 = 0h, 20.8.08 = 0h, 21.8.08 = 10h, 22.8.08 = 10h, 23.8.08 = 0h, 24.8.…

Hi This may be an obvious question but what I am trying to do is up a level from my current skills and is driving me mad! I have a database called PRODUCTS. This contains fields for a description etc. Within this is a portal window built with a relationship, using PRODUCTID, that shows records detailing volume breaks for a product and the relevant pricing. For example, up to 10 units cost £5 each, between 11 and 20 cost £4. each and so on. I have another database called CUSTOMER that features a portal with a relationship to another file using customer ID. In the portal there is a drop-down value list from which a PRODUCTID is selected. This then autofills…

Hi, I am using EventScript in Validation for many fields at my DB. So each time i create new record - many scripts are triggered. Does anybody know, what kind of order does filemaker have for these calculations? (I want to create a field, which will trigger another script, but it will be the last script triggered). Anybody knows? Thanks a lot!

Hi I need to know how to put a badge number. every badge have 30 record. example serial no badge no 1 - 30 1 31 - 60 2 61 - 90 3 and so on pls show me the calculation. thanks hasru

I have been reading about the random function in filemaker and am trying to determine how to use it to generate random phone numbers. The phone numbers will all be in the same area code, but in different prefixes. There are 21 different prefixes for the area. So I need a way to randomly choose one of the 21 prefixes, and then generate a random 4 digit number as the end of it. It seems the random function returns a random number between 0 and 1. I then found this step by step process: http://sixfriedrice.com/wp/creating-random-numbers-in-filemaker-pro/ The only problems is there are 1111 numbers that are between 0000 and 0999. So this being the c…

Hi once more.. I'm trying to display session times that are available for each day on a calendar in month view. I have an "events" table with the field "available sessions" which is displayed in each day of the calendars month view. "available sessions" is a calc field with the following. Case ( IsEmpty ( Title ) and Time = Time ( 9 ; 0 ; 0 );"9 am" ) ;IsEmpty ( Title ) and Time = Time ( 10 ; 0 ; 0 );"¶""10 am" ;IsEmpty ( Title ) and Time = Time ( 11 ; 0 ; 0 );"¶""11 am" ;IsEmpty ( Title ) and Time = Time ( 13 ; 0 ; 0 );"¶""1 pm" ;IsEmpty ( Title ) and Time = Time ( 14 ; 0 ; 0 );"¶""2 pm" ;IsEmpty ( Title ) and Time = Time ( 15 ; 0 ; 0 );"¶""3 pm") …

Please see above layout to get an idea of what I'm trying to accomplish. I'm on the final piece of my first paid for gig and I'm completely stumped on how to develop a statistical report. This is for a Condominium Resort that has a minimum 2 week rental policy. I need to have a report or group of reports that will: 1. Tell me the number of units that rent vs the total number of units. 2. The % of Units that rent vs total units. 3. The number of times a unit is rented during any date range. 4. % of rentals to total rentals by unit 5. Sort by units with most rentals 6. Sort by units rented by period (Season) 7. Show %…

I am trying to make an invoice on my file maker program. I have a parts Table and and Invoice table when i am using my invoice maker i have drop down menus that pull part names from the parts table, but i have a feild right next to it for the part price. How do i get it to automaticly put the price in? The data is stored in the Parts table along with the part name and ect. Even if you dont want to explain this to me if you know the name of the process i need to use to do this i can look it up myself. I just dont know where to start. Thanks in advance Matty

I have a little calory counter application and I'm trying to write a report that can give me an daily totals and weekly averages of the daily totals. The daily totals are working fine with subsummary reports, but I can't seem to get the weekly averages per day to work. I keep getting the average of all the foods entries, not the average of all the daily totals. My mind seems to be in a fog about this... Any suggestions? Thanks, Michael

If the contents of a certain text field are: SALLY WENT TO THE STORE ... is it possible for me to get a calculation field to yield the following result? Sally_Went_To_The_Store Notice ... UPPERCASE to Titlecase Also notice ... underscore between each word I've tried Substitute to add the underscore ... works good, and I've tried TextStyleAdd to change to Titlecase ... also works good. However, bringing Substitute and TextStyleAdd together doesn't seem to work. Thanks so much!

This is what I'm trying to say with a couple summaries; "I have X number of Samples that have come from Y different families (Y can be the same number as X but never more)" Details... using 2 tables; Contacts and Samples relationship is based on Contact ID. Contacts are also part of a Family and have a Family ID (Family ID is part of the same Contacts Table, it is not its own table). I'm trying to generate a report of all samples (easy enough) Sorted by Family ID (still easy). The report layout has a Sub-Summary when sorted by Family_ID, (still pretty basic) and this is working perfectly. I now need two Summaries. The first is straight forward and working fine…

I am designing a few reports and I am not sure how to to proceed, im not sure if a calculation or a summary function would be appropriate? The report searches through multiple records (via a search) and pulls the ones that meet certain criteria based on a master table. I have used the summary function to count how many actuall records where found in the search and it prints the number on the report. I am curious as to how I can count how many records of the search are present that also contain a specific value in a seperate field of the primary table. I would like to print that number on the report as well. How could I go about this. Understanding that there a…

Hey, A lot of people recommend to make key fields numeric fields to avoid problems when it comes to searching. (As searching 123 in a text field returns 123, but also 1230, 1231,...) Both my primary and my foreign keys are numeric fields and look like PER00001 or LOC00035. When I take the value from such a primary key and put it into a foreign key field somewhere else using a variable, Filemaker cuts LOC00035 down to 35. Changing the settings on a layout for a numeric field doesn’t help. When the foreign key is a text field, this doesn’t happen. Also, when I use copy and paste script steps, LOC00035 stays LOC00035. So, I’m about to change my key fields…

Dear (name field) Thanks for buying "(item field)" on (date field) from our web site. Problem? Email us

I was wondering if there was a practical way "stamp" CurrentDate/UserName when people add to a field, within the same field. For example, I'm building a solution to track Marketing leads and have a few fields for notes like Initial Contact Subject, Contact Results, Follow up, ect. What I would like to do is have Get ( CurrentDate ) & " " & Get ( UserName ) stamp after an entry to the notes. I don't think its possible without multiple fields, but what I would have liked to see is...say Joe starts up an initial contact and details his correspondence, then lets say Steve had a conversation with the contact the following day and adds to the initial co…

Hi, How to import a sound (MP3 or AAC) into a container field AND let FM play it? Thanks Ben

So, I can't figure out why this field is changing its own value. I have a number field that acts as a button. When you click it, here is the entire script that it calls: Set Selection [header::BILLTO] Pause/Resume Script [indefinitly] Set Field [header::discount; Case ((header::BILLTO = 2350 and header::SHIPTO ≠ 3166) or header::BILLTO = 373; .02; header::BILLTO = 1285 or header::BILLTO = 2122 or header::BILLTO = 830; .01; 0)] Set Selection [header::SHIPTO] The BILLTO field is the one that acts as a button to call this script. It then selects itself and pauses so the user can enter a customer number. Then it checks that number to see if it …

im trying to create a log of modifications to a record, not what was done but just by who (user) and when (timestamp). my initial thought was just to have a repeating field that went to the next repetition at each auto enter of the user modification and the timestamp. problem is, the data overwrites instead of going to the next repetion and therefor creating a log. can this be done or is my approach floored? is there a simple answer ? thanks Ben

Hi, How can I put the index of a field into an other field? I'm looking for another solution than using a loop. The index exist, so it should be possible to get it easily. Thanks Ben

Hello, I have/capture the following data and it can look like this: 12345 12345-xx 123456-xx 1234567-xx I want to make a new calcuation field that strips away the "-" AND anything to the right of it. So the above data would look like this in the new field: 12345 12345 123456 1234567 Any tips/help would be awesome! Thanks, Ryan

Sorry if this has been covered, but "mode" isn't the easiest thing to search for. Has anyone figured out a clever way to find the mode of related values, or a value list, in the context of a calculation? And by mode I mean Mode, like Mode, Median, Mean, etc. Most common value. I smell a custom function, but I'm somewhat baffled that FM doesn't include this function. Or am I blind?

Dealing with some contract-related fields. One field is for the date of contract signing. Another field is for the duration of the contract, expressed in months. Months could range from 6 to 36 or possibly even more. Would like to have a field that auto-fills the contract expiration date, which would be calculated from the signing date and the duration of months. Any ideas? Thanks a lot.

I am using Fmdiff to compare 9.0 versions of the database for SOXA change control. Several fields have shown up with a change from nothing to Index Maximal. I'm trying to figure out what would have triggered the change and what it is? Pardon me, but I am fairly new to FM. Any ideas? Thanks in advance.

I have a layout that creates an invoice. I wish to save a copy of the invoice as a pdf into a repeating container field. Although Filemaker provides the "Last(field)", this returns the last non-blank repetition, whereas I require the first blank repetition. At my wits end over this one. Any guidance would be most appreciated. Eric

I am very new to filemaker so if this a no brainer then I apologise in advance. I have a database which I import data from an employee time recording system. I import employee number and a timestamp. The data doesnt contain any detail as to if they are entering or leaving the building. I sort the data by employee number and date. I assume that the first record is when they started work. I have a getnthrecord function to get the time from the previous record. I will then subtract the second record from the first to calulate the time in work. All this works OK untill i import some more records and perform a sort. My question is how do i recalculate after I …

I'm new to FileMaker, having just bought a developer edition of 7 on eBay. I'm working on a FileMaker version of a database I'd originally developed in ClarisWorks (MacOS 8). In ClarisWorks, entering a single unpunctuated number into a date field would implicitly enter the current month and year, and entering month and day into the field would implicitly enter the current year. Is there a way to make this happen in FileMaker 7? It does speed up data entry just a bit.

hi, I am very new to filemaker, and I am so glad that I found this community for help. Anyways, we recently switched over from filemaker 6 to filemaker 9, and right now some of us are trying to convert the old .lasso files over to PHP. Repeating field became a challenge for us because there is such a limited information out there regarding such matter. I am wondering if anyone can help me implement repeating fields. I am not sure if it has ANYTHING to do with the repetition part of the setField function, since the file I am working on right now creates a new record in the database. Thank you in advance.

Hi Folks! I am a brand new FM7 user! And I am a quick learner... but... I need some fast help with this issue (I know I could figure it out by myself in a week's time, but I need to do it faster). I need to define a field (in a record) that stores a number in 8ths (fractions) -- like I can easily do in Excel. For example that field in 5 different records might look like this RECORD 1: 1 1/8 RECORD 2: 3 5/8 RECORD 3: 4 4/8 (notice that's not 1/2!) RECORD 4: 2 7/8 RECORD 5: 5 3/8 Later... I will have a new layout that will have a field that will total those records (17 4/8)... but that is not as critical to my question today. And... I …

Question for those who paid more attention in math class than I did. I have a list of cities (80), and need to determine mileages between each possible pair. My "Combination" function gives me the number I'll be dealing with, but no list of the combination coefficients. Any help would be much appreciated. Thanks in advance. Randy

Hi, If I select a field, it will highlight in black. How would I go about by changing it to white?

I need extract certain characters from a text field. As an example I want just the second letter "e" from a text field containing the word "text". I believe I should use the position and left functions. I can't quite figure out how these work.

Hello everyone, I'm new to both filemaker and to this forum . I apologize if this was posted to the wrong forum area. Here's my problem. I created a primary field which is titled (release date) which contains the date the project is to be released. Another field (due date) is to specify when the project should arrive. On the creation of a new record the due date defaults to 10 days. Release date defaults to the date the record was created. I have 2 additional fields (weeks) and (shipping method). The first determines the number of weeks before release and the other is the shipping method. These 2 are both pull down menus. When the user modifies or alters the release date,…

hi! im new in filemaker and i have a problem with my project. here in the philippines we have a area code with 3 digits and 2 digits, something like this: (046)123-4567 & (02)123-4567 my calculations for my 3 digits area code is like this: "(" & left (text; 3) & ")" & middle (text; 4; 3) & "-" & Right (text;4) the problem is when I enter a 2 digits area code. can anyone help me with my problem? I want both 2 digits & 3 digits area code enter with no problem. Thanks in advance! i hope you got what im trying to say. :

Hi, I have a portal which tracks client sessions by date. The portal is within a client details layout. One of the field on this layout is "health plan date" (a date field). What I would like to do is have a calc field which displays the number of sessions a client has had since the health plan date. Another words how many portal rows display sessions dated at or later than the date displayed in the "health plan date" field Can this be done with the count function? Thanks

So I have a list of fields for a score sheet I am using as part of a datasheet in my internship. Each field has 5 boxes which are checked according to never, infrequently, sometimes, fairly often and always. I was wondering how I could assign numbers to these checkboxes (0-4 respectively) and have filemaker add up all the values for a final score.

I'm trying to use the Filter in a custom function to only allow alpha numeric characters along with the space character. It works fine for all of the alpha numeric characters but it is still filtering out the spaces (which I want to keep). This is what I am using: Filter ( fp_input ; "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwzyz0123456789., -" ) Is there something that I am missing?

I'm new at Filemaker and can't find a way to do something that I would think is a common practice. Any help is welcome. I'd like to generate a key field value 'automatically' for an Instant Web Publishing application. The key field, once set must not change because records are referenced from other tables using the key's value. On the Auto-Enter dialog, the key field's calculated value is defined as 'Left(Last Name;3) & Serial'. (e.g. for Ted Smith, the key value is set to 'SMInnn' where nnn is the current serial value) This works fine when adding a new record to the database. However, the key is also changed when a record is modified and 1 or more of t…

I need data from aonther table that if the course number is 2903 then, I need the word "Completed" to be filled into a field. I tried this: Case( HCOURSE1::CRSNUM = "2903"; "Completed"; "") It worked but I tried to use the calculation for other fields and nothing happens. I tried If instead of case but nothing happens. Thank you for your time.

: I'm trying to extract certain bits of information stored on a membership card (control number) using a card reader so I can then do a lookup of name, address, etc. Currently, the info I see when I swipe the card is: %cardholder's name ? ;0416463 ? What I need is to be able to extract only the -046463 - and put it in a field. Does anyone know how to write the calculation ?

Greetings, I have Lookup Calculation where the 1st condition of the If statement works perfectly but the fail) condition/result is ignored. I have tried this as a case statement where there is not/= operator in the second statement but it does not work either. If someone has a moment to take a look will you let me know where my logic/syntax is wrong? If(CurrencyExchangeRate::Abbreviation=CurrencyExchangeRate::Abbreviation; "The" & " " & GetAsText ( CurrencyExchangeRate::Region ) & " " & "currency rate was last updated" & " " & Lookup(CurrencyExchangeRate::Updated); "Please navigate to the Currency Exchange table and e…

I'm having in issue, where I need to be able to enter a value into a field (JobIdent); eg: "20080426", and I need to lookup via the Job table the actual ID (primary key) (JobID) and set that value in the field. I'm having the same issue with the Employee and Code input, but once the correct method is found they can be fixed aswell. All the tables use a sequence for a primary key, and that's how they are all related, but each table also has a 2nd (more human friendly) identifier that the user understands, and I need to convert from that to the database id in order to store records. I've attached a screenshot that I hope helps. You can see there are 8 jobs i…

Hi all, I have the following age calculation that outputs such as year “12” Is there a way to make the output year and months such as “12.3” Let ( [ Date1 = id::id_birthdate; Date2 = abc_date ] ; Case ( not IsEmpty ( Date1 ) ; Year ( Date2 ) - Year ( Date1 ) - ( Date2 < Date ( Month ( Date1 ) ; Day ( Date1 ) ; Year ( Date2 ))) ) )//result number Thanks for any help. : A

Hi, I'm trying to the last payment date from a line item file. I can get the Last(PaymentAmount) but not the date of the last payment. GetAsNumber ( Last (PaymentAmount ) ) works...

Hello, I am creating an Estimating worksheet for Marketing personnel. They would like for the final cost to be rounded up or down according to the price. I know how to round up, but is there a way to round down? So if the cost is $653.00 it will round down to $650.00. Thanks

Hi Folks, I am a FM Rookie and am trying to learn fast.. I am trying to track 18 daily truck routes. I have a field for 'miles' and a summary.. however the summary totals everything from day one. I need to track a "Daily, Weekly and Monthly" in a number of fields..ie; miles, stops, etc; But I am not sure of the proper calculation for each.. PLease help a self-learner :

I can't find an explanation of this prompt so cannot fix the problem. The prompt shows after typing a calculation into a calc field: "A number, text constant, field name or "(" is expected here." I can see that "here" refers to the very beginning of the calculation because the first 2 characters get highlighted. The calculation purpose is to create an html web page and begins: When I click "Storage Options" or "OK" to define the field, the above prompt shows. The frustrating thing is that I can't find how to fix the problem, or even how to search for an answer. If I simply add one of the prompt suggestions, such as: one of the field names or the…

I've converting several flat files into an inventory database that contains about 7,000 items. Each item will have between 0 and 5 photos associated with it. Currently I have a folder with about 1,500 photos. I'm considering two options for managing this: 1)Keep the jpgs in their folder and reference them in a separate table with a multi join to the items table. 2) Store the jpgs in a separate file and relate the main file and the photo file to each other. I'm leaning towards #2 because that prevents someone from accidentally deleting the referenced photos. Any opinions on that? Secondly, I don't know how to get the images (or their referen…

I have 4 fields: Date, Number, Name, and AlertField: Alert is an autoenter calc. I want it to return "Alert" in 2 cases only: 1- Date has been modified or Name has been modified -> Alert field to return "Alert" 2- Number is modified and exceeds 19 to return "Alert" (if modified and value is below 19 it's not an Alert) I was able to figure each condition separately but don't know how to combine them. For 1 - I have : Let ([X=Date; Y=Name]; "Alert") For 2 - I have : Case (Number > 19; "Alert") I have been trying to combine these 2 conditions in one expression but stuck. AlertField is as an auto enter calc because once the person in charge …

If create an unstored calc and set it to = Get(WindowName) will that calc always show the correct name for that window, even with multiple windows open (but different names) and displaying the same record?