Calculation Engine (Define Fields)

Hello there, I wonder if anyone could help me. I have 2 fields with repeating values for 4 years of studies divided in 8 semesters (2 semesters by year). One represent the semester with 8 repeating values (semester[1], … semester[8]) and the other one represents the year with 4 repeating values (year[1], … year[4]) What I want is that in the first repeating value of the year to have year[1] = Average (semester[1] ; semester[2]) in the second repeating value of the year to have year[2] = Average (semester[3] ; semester[4]); in the third repeating value of the year to have year[3] = Average (semester[5] ; semester[6]); and in the four…

Pretty new guy here trying to update a Filemaker application that my developer has had to drop. I have a date field with a pop-up of the calendar but I'm trying to get that date to fill in a "day of the week" i.e. Monday, Tuesday, Wednesday in another "text" field. Anyone have any ideas? The only thing I know is the date format function in Excel but there doesn't seem to be any similar function in Filemaker. Could it be a "lookup" based on a value list of the days of the week?

Hi All, I am trying to create a basic calculation to return a Word IF a number in a field begins with a specific number. This is for auto text for credit cards. So if the number begins with 3 then its an America Express. How would I write that? Thanks for your help!

Hi guys, was not sure where to post this, but this seemed to be the most appropriate... I was trying to create the 'perfect' report layout but then realised that the requirements of the reports would vary per person. Now the main requirement of the report is that it fits in an A4 portrait layout for printing.. So what I was hoping to do was have a default report layout... The layout currently has 4 fields along the top Serial|Project|Version|Status followed by the details of each record - it's probably more of a table... So what I am wanting to do is to be able to make it so that the user can select each of the 4 fields and change i…

Hi everyone- This is my first post, hopefully someone can help! I'll try to be clear about my problem, as I'm not sure if I am making this harder than in should be, or if it really is complicated. I'm developing a new FM solution for my company to help us track contacts. We have a contact database that consists of a Company table and an Individuals table. Although one Company may have several employees, our office assigns one "account rep" per company. Therefore, I have a field called "Account Rep" in the Company table. This field is filled in based on a value list of our sales persons names (Rep A, Rep B, Rep C). In the Individuals table I have a f…

Is it possible to have a tab in a calculated field similar to the way you can include a return? I have a calculated field that will basically create an .iif file that Quickbooks can import. Currently I'm using asterisks in place of tabs, but that means I have to pick up the file in a word processing program, change the asterisks to tabs then pick up the file with Excel, I'd like to cut out that step.

I'm trying to create an invoice where different equipment ID's have different prices. I'm trying to put them all in one field, if it is possible. If someone can get me started on the equation, I hopefully can input all of my data. My fields: Equipment ID CM Expenditure Equipment ID A8117 = .01 Equipment ID A8115 = .01 Equipment ID A7213 = .20 Equipment ID A7374 = .20 Equipment ID A7924 = .034 Equipment ID A6967 = .034 Most of my Equipment ID's = .034 The calcluation I am trying to do is: expenditure = CM x .01 or .20 or .034 Is this even possible? thanks for any help you can give!

Hello Everyone, This is a simple time calculation question: I have a calculation field to total hours from a start time and a stop time: (Time_End - Time_Requested) / 3600 It is set to return a number...what I would like to do is to have the resulting number show as below: if the returned number is 200 I would like for it to show as 2:00 how the heck do I do that with this calculation. Thanks, James

Hello! I was wondering if someone could help me. I am working with a database for a print shop. Need help with calulating how many sheets of size x paper I can get out of size y paper. Example: If I have 26x40, how many 8.5x11 sheets can I get? Thanks!

Here is the background Units have models Models have vendors Tables UNIT; Model; Vendor; I want the Total Number of Units by Vendor. Thanks for your help

hello,I am writing an inventory database but I need help with a calculation, I have a field for quantity on hand, and I have field for quantity consumed, what would be the calculation that I need to enter so that qty on hand changes in regards to qty consumed

I have been struggling with subtotals for weeks with no results. Could someone please take a look at the attached file and let me know if this is feasible in FM without using additional TOs and relationships? Very much appreciated. Subtotals.pdf

I've imported a bunch of records that all have a text field to display a date, in the format "April 3, 2005". Is there a way to change these text fields to working date fields?

I'm looking for a way to define a new field with limited options and then set the value for that field on all records or a specific group of records. For example, I have imported a bunch of records into a database that is keeping track of many short documents. I'm going to add a checkbox field to each record indicate whether or not the document has been published. If I define a new "published" boolean, how do I set all of the records, or a select group of records, to that value? I don't want "published" to be the default. In other words, is there a way to do a global setting of the value in a certain field?

I have 2 fields that I want to take part of each and put it in a 3rd field. I was trying make a calculation with Left and Right but it never seems to work. I have searched the forums for similar cases, and I am sure there are, but I don't seem to be using the correct words to search. If any one can help I would really appreciate it. Field 1 is Package and has *DA6C* it will always contain the same number of characters. Field 2 is Team and has *6A* and it will always be the same length. In my other field I need the *DA6C from the Package field and the 6A* from the Team Field. The final result would be *DA6C6A* Is there a simple way to do thi…

Fairly inexperienced FileMaker user, looking for a little help. I have a database of information about paintings and I'd like to add a button that when clicked will open the Photoshop file of that painting -- located elsewhere on my computer. Any suggestions?

I have a text field that I need to standardize. In some records The data is separated by blank lines whilst in others it is not. I need the field to finish up like this Name Address Postcode Phone etc. At the moment some records have blank lines between postcode and the phone and between the name and address. Is there a quick way of automatically removing these blank lines? Thanks

In a database I am currently developing, I have a value list that is: 1-presentation of a paper or a creative activity 2-organize a conference or other official duties at a conference 3-service as a panel chair, referee or other activity listed in the program 4-conducting research 5-workshop or conference attendance It’s a checkbox set, allowing the user to select more than 1 value. On another layout, I am trying to display only the number(s) that were selected. For example, 1,4 or just 1 I was trying to make a calculated field with the list and trim function, but just can’t seem to get it going… any assistance would greatly be appreciated.

Hello, i am beginner in FileMaker and this is my situation: I have two db's, Bugs and Documents, in Bugs DB i have description of bug and another things about bugs and i can add a link to Documentation about that bug. When i write something in the Documents::Filename field i need to change it from O:test.doc to Servertest.doc. I have written script to perform it - Set Variable [$filename, Value: Get(ScriptParameter)] Set Variable [$filename, Value: Substitute($Filename; "O:";"ServerDocuments")] and this function is called by calculation in field Documents::Filename - Filename & S4HU_EventScript( "Dokuments" ; "Documents Rename"; Filename ), but thing is - when i write…

Hi, Please help with date calculation. I am new to FileMaker and appreciate your input. If visit = Prescreen, then Deadline_Date = Received_Date + 1 week. Please note, the user will enter a received date and the program should calculate the deadline date. If visit = HSCT 35 or HSCT 42 or HSCT 49 then Deadline_Date = 12/1/2008. I have attached the filemaker file and really appreciate your help on how to write a script or calculation to perform these 2 scenarios. thank you. Patients.zip

Hi, I'm not sure if this is the right forum to post this question so if it needs to be re-directed please let me know the right place. I have a database with 20 fields that contain "color" Information. They look like this basically: # Color 1. White 2. Blue 3. white 4. green 5. yellow 6. white 7. green 8. brown 9. white 10. orange 11. and so on, etc..... What I am wondering is if there is a way to evaluate these fields and performa a calculation to determine how many "UNIQUE" colors are represented. In the example above the result I am looking for would be 6 because the White is repeated 4 times and the Green is repeated twice. …

I am making a tool, for our sales manager to track sales, and contacts. I can't find my filemaker reference guide, and have searched the forum, and can't find what I need. Basically, I want a calculation that will add up a total of all records based on the month the record was added. For example, each record tracks the total number of contacts each salesperson has daily. Each record has an auto-stamp of what date the record was input. In the managers' layout, I want a field to show a running total based on the month. So the total contacts for each record of May are added together, but not the total contacts for June, and so on. I can't figure out how to do …

I'm trying to setup a login script that will find all records created by that user on login. Is there a generic calculation rather than setting up a long winded 'case' script for every user? I addition to this it would be great if named system administrators could see all records on login? Thanks for your help.

Hi I am in the process of converting my FM6 databases to FM9. I was used to use date strings to get sale reports for a specific time period. I had to replace Today by Status (CurrentDate). For example, I use this calc string to perform a search for the previous month. DateToText(Date(Month(Status ( CurrentDate )) - 1; 1; Year(Status ( CurrentDate )))) & "..." & DateToText(Date(Month(Status ( CurrentDate )); 1; Year(Status ( CurrentDate ))) - 1) The result is 09/01/2007...09/31/2007 When I use the above string with a Set Field command, the result is not what expected because the Date field is in date format. So, I need to change the string in or…

Hi all, need some help with image path syntax for the Mac. I am running FMSA9, want to create a simple image database, with linked images, that will work from both Macs and Windows using Filemaker. Image files are on a file server, in a shared folder called “images”, with both SMB and AFP enabled. On Win, I can mount “images”, insert image into container field, unmount folder, and I can still see the image. Using Fenton’s “GetAsText (container field)” I can see the path is: imagewin://IPAddress/images/D008/MOMAP0024.JPG On a Mac, I mount the “images” folder using AFP, using Connect to Server>IPAddress/images/, insert image into container field, unmount fo…

I have a standard Invoicing system with a Products, Invoice and Line Items file. In my Invoice file I have a portal into my Line Items file where each line item ordered is shown for each invoice. Each line item has a "Vote" field with YES or NO radio buttons. I need your help with how to set up the calculations. I need a calculation showing the total number of YES votes and the total number of NO votes for each product. Then another calculation field that will show this same information by percentage. What I've tried has not worked and hope you can help. I use FMP 9 Advanced. Thanks, Milo

I am publishing a production tracking database using IWP and want thumbnail images to appear on the detail page. I have a calculation with result container to access the images stored on another webserver. The problem is that the url required to access the images is case-sensitive (ie /Volumes/Raid/ is not the same as /volumes/raid/) but the url that Filemaker uses is all lowercase. I have tried Upper() but it makes no difference. Any ideas?

Howdy, all: I found this gem of a serial number calculation (below) on this site--and I wish I could recall who posted it so I could give him his public due--but when I run it as is, it injects a 7 in the thousands' place, e.g., 200707011, 200707012, 200707013, etc. Being FM-declined, I tried substituting some of its values but couldn't get rid of that 7 to replace it with a zero. What would be the fix for the calc? As always, TIAFYH. Let([ year = Year ( Get ( CurrentDate ) ); lastId = GetNthRecord (id ; Get ( TotalRecordCount ) - 1); lastYear = Left ( lastId; 4 ) ]; year & Case( year ≠ lastYear or Right ( lastId ; 5 ) = 99999; …

Created a database to track and bill professional time, but want to add ability to calculate and show finance charges and interest based on aging of outstanding balances. I'd very much appreciate if any one would lead me to a decent starter solution or template so we don't have to reinvent the wheel in terms of creating something from scratch that many others must already be using. Thanks in advance for your time and consideration.

Hello, folks We would like to allow the user ability to modify field if it is empty but not if it is filled. Assuming "vendor" field is filled and "vendorID" is empty. We would like to not allow the user to modify the "vendor" field since it is already has the data, but allow the user to modify "vendorID" field since it is empty. Isempty(vendor) or Isempty(vendorID) doesn't work as we expected . What function should we looking at? Thank you for your advice,

One of you guru types will know: I need to get a calc field to yield multiple lines, NOT with the &"¶"& trick, but with whatever FM uses for its own line-break stuff. Background, in case that's not clear: I have a label-maker (brother QL-500) that doesn't interface with FM but does have its own (terrible) software, which doesn't wrap text (!) and handles pasted text oddly. (I may yet ditch it for the Dymo I saw recommended by someone here, Vaughn maybe, back in May!) I'm printing labels for articles, whose titles may be long. So I want FM to give me a calc field with line breaks in the right places, so that I can zip out a label on the fly (or on the…

Is there a way that if my field "Invoiced" is checked i will not let anybody else change any fields to that record?? Thanks

I am currently trying to create a currency calculation field that uses data from another number field as the Format>Number menu in layouts is not an option. My question is: If a field named Num contains: 100 How can i create a calculation that will display 100.00 I have tried various number functions including: Truncate ( Num ; 2 ) Round ( Num ; 2) but can not find any calculation functions that can do this.

Looks like a simple question at first -- but read on. I have a main page which has about 5 different related pages that connect to it. I wanted to start an auto calc field that show the person who modified the page last and date --- this works well for the main page but ever time someone modifies one of the other related pages the modified date and user does not change --- QUESTION: Is there a way to make it all link together per main page w/ all related pages. So if someone changes something on any related page to the main page it updated the modified date on the main page. Thank you, Joseph

Greetings. Surely, it is somewhere in the archive, but I cannot find it: How to write a Substitute function: Substitute(text;searchString;replaceString) to change all those characters to an underscore: ,(comma), +, -, *, /, ^, &, =, ≠, >, <, ( ), [ ], { }, ", ; (semicolon), : (colon), : (relational indicator), $ (variable indicator) Or is there a custom function available to do this? Any help would be great. Thanks Greg

Been struggling with this (calc learner). I'm trying to set up a calculation that gives me a running total (against each record, so a summary field won't work, or is far to slow) in a found set of records. I want to then do some testing based on the result, ie. when the total > 32, do not add to the total.... I'm trying to work out annual leave and time in leu that we get in the office. thanks,

I know, I know, Filemaker can't monitor related fields so you can't store a calculation with a related field in it. But when the related field is the result of a Case() statement, it seems to me like that should be storable. The calculation Case( localField = 1; relatedField) can't be stored, but that calc doesn't require monitoring, it's triggered. Anyway, a field with an auto-enter calc seems to work just fine. Just ranting.

how can I add a value to each item ?, it is drop down field that contains 50 items ? lets say I pick item 1 in the field and have another field add for instance a QTY. thanks

Is it possible to add a tab character in the txt field in the same way that you can add a carriage return (Alt0182) Thanks John

Hello, I asked this question many years ago but I can no loner find the answer so I apologize for asking again. I want to write a calculation where StartDate-EndDate=NumberDays Easy enough, but if the StartDate is a Thursday and the Endate is a Monday I only want the calculation to return "1" as the answer..essentially taking the weekend days out of the equation. I am not really concerned about three day weekends or weird anomolies. Does anyone know a calculation that would do this? Thanks in advance for any help. Steve

i'd like to have a calc field in table::A show all the values from a related field in table: it is a one to many relationship when i write a "case" or "if" calc i only get the values from the first related record. what is the trick to getting it to evaluate all the related records? (i asked this before but deleted when i thought i figured it out on my own.)

I want to set up a budget table as part of a databse for our church. There are several main categories: Office Expenses, Building/Utilities, Staff, etc. etc. But the specifics aren't always known (for example, some months I'll buy paper for copying and some months I won't) So is it best to set up a repeating field for each major category? Or are repeating categories too hard to use with calculations and all that? My inclination is to use repeating fields in that way each month and then to use summary reports to show monthly and yearly totals. Any better or other suggestions on how to set up a very large and complicated budget? Thanks!

I'm managing photographs for catalog project and have a lookup problem. My root table is the book table that lists each catalog I'm shooting. Then there is related table for pages in the book. In that table are three fields of interest. The temporary page number that the client provides, the name of the spread as it will apear on the corner of the page (like 1-2 3-4 etc) and a due date for each spread The other related table holds each photograph that needs to be produced. I have a drop box populated with temporary page numbers the are realted to the current project and that works great. Then I have FM lookup the value for Sprea and due date bas…

I need to implement a system that will stamp a users name and modification date and time based on one field changing. Currently, these stamps change when anything in a record changes. TIA, .sly

I'm a mid-range skill-level FM user/designer. I'm using the standard TimeCard file with some modifications. Regarding entering the time, is it possible to just click in the "Time Start" field and have the current time auto-entered in without typing anything? In other words, I want my employees to be able to just click the field and the current time will automatically be entered. I remember an older trick with FM where a calc field with two slashes would enter the date but that was with a new record. I want this function to happen whenver a "Time Start/End" field is clicked. Can this be done? Thanks!

I have a set of records (shown in a portal)each record has a field called "selected" which can be toggled to show "Y" or "N" I want to populate a global text field with just the the selected records so I use a created a another table occurance called selected records and jioned them via the selected field. I can now use the List Function to populate the text field from this selected table occurence. HOWEVER.. I need the text field to show records in the order I click them not in order of the selected records table. Changing the sort order of the selected table does not change the order the list function populates the text field and I do not know how to proceed. S…

I have a line item table and an invoice table. When entering new entries into the line items portal located on the invoice layout performance seems to be slow, 6-7 seconds waiting. Any suggestions? there are about 12,000 line items and 2,000 invices.

What am I missing? I have a field "Inventory" as a check box. I have a calculation field called "inventory flag". The calculation is: Case ( IsEmpty (Inventory) ; ""; " INV. ") I want the user to check the box in the field "Inventory" and have Filemaker put the letters INV into the field "inventory flag". the contents of the field (Inventory flag) only show up when the field is selected?

I created a container containing a file reference to an image with an exact path --> img_ref = "image:/drive/folder/f_"&Right(filepath;10) Where the last 10 characters of the filepath are the image number "xxxxxx" followed by ".jpg". The image does not show or show a "0" if I try a "Replace field contents" with the same value I have in my img_ref. But if I duplicate the existing record, without changing anything the image shows up in the duplicated record !! ... meaning my calculation and filepath are both correct. How can I fix this weird situation so my images appeared when opening or re-opening my db?

I'm trying to figure how to calc this out. Text Field1 contains: John Smith My top 100 greatest ideas ever or contains My favorite sister (who really cares?) Text Field2 contains: I want it to show only the words left of the characters..... like ( , ....or to return the word count for use in another calc. sorry 'bout that! So if...Text Field1 contains - John Smith My top 100 greatest ideas ever Text Field2 contains - John Smith Help is always appreciate. Edited for better explanation....

Hi, I have a candidate review database that allows a reviewer to vote on a job candidate. Each job in the database can have various criteria by which the job applicant can be graded... so, for instance, the Janitor job candidates may be graded on Appearance, Cleanliness, and Punctuality but the Scientist job candidates may be graded on Past Research, Reference Letters, Quality of Publications and Overall Package. When I first built the ability for reviewers to cast votes, I made it so that an average grade was calculated so that even weight was applied to each criteria.. 1-5 for each criteria.. I'd like to though, give the reviewer the ability to…

When ever I create a new script I cannot move it up or down the menu. For example, I have a database with 20 scripts. When I create a new one it is the 21st and I cannot move its position. Is there something locked or is the file corrupts? Gary

i need to show amount of work week time (M-F 8-5) that has elapsed from a certain time. Thanx for help.

:B I have a summary field that totals the number of records in a absence database.... Sum ( current year absences::personaldaynumbertotal) Records displayed in this field are based on a one to many relationship between a teacher file and an absence file. The relationship allows only records for that teacher and school year to display. However, when I change the school year, the summary field doesn't update unless I close the database or open define fields. What's up with this, and how can I ensure the field updates?

I need to build an automatic price calculator for my T-Shirt printing company where the user enters some key info and it spits out an exact price per shirt. Where do I even start with this one? 1. User chooses a shirt from a pull down. Shirts are a set price, this should be simple. 2. User chooses number of colors for the front, back, sleeve, etc... Number of colors effects the run price. (2 colors is less than 5 for example) each color requires one screen. ( 2 color front and 2 color back = 4 Screens X 12.50ea flat fee in attition to the run price) 3. User enters number of shirts to be printed. The more shirts printed the lower the price per print. 2 colors p…

For a government document we need to parse out 4 letters from names. 1.The first letter of the last name. This no problem. 2.If the first letter of the last name is a vowel, we need the first following vowel. (f.i. lastname = Aguilar, 1st letter = A, 2d letter U ) 3. If the first letter is a consonant, we need the first following vowel. (f.i. lastname = Duarte, 1st letter = D, 2d letter U ) 4. First letter of first name. This is no problem. So, 1 and 4 is no problem, but how to tackle 2 and 3. TIA

I have created a Job list with about 250 jobs in it so far. I want to have an entire row become red when a job that has been invoiced is over 30 days old and nothing has been entered into a Date Paid column. The fields I am working with are called: - JobList_InvoiceDate - JobList_DatePaid I know it needs to be something like this, just not sure the proper way to say it: Formula is: If JobList_InvoiceDate - Today's Date > 30 AND JobList_DatePaid = "" THEN APPLY FORMATTING How do I do this in Filemaker? (Filemaker Pro 9 Advanced) Thanks, Todd DeBacker

I'm building a db that has technical drawings that need to be printed to size. Even though I checked "keep original proportions" it seems like the Image wants to fill up box and becomes too large, and doesn't print to size. I need image to print from filemaker at exact same scale. I've looked around for other related postings, but didn't come up with anything. Sorry if this is a repeat.. thanks

Please point me in the right direction. I need to get the highest value from 4 different fields in the same record. I'm not ever sure where to start. In my head I keep thinking its going to have to be done with a Let Function but I'm not very good with Let Functions as of yet maybe I need to get better. Any suggestions are greatly appreciated.

I'm working on creating a subscription management solution for my publication, and need some help pointing me in the right direction. (Maybe this isn't even the right forum...) I've created a table for customers, subscription offers (number of issues for $), and an order table. In the order table I have field for the date of the first issue (dateSubBegin), the number of issues to mail (numIssues), and a date of the last issue (dateSubEnds). This assumes that the subscription is mailed each month, without stopping. I need a calcuation that will keep count of the number of issues remaining on the subscription each month. Each issue will publish on the 15th of…

Hi there, could someone recommend how I should approach: 1. grabbing the email address that comes after the word "Requestors: " out of a field that has the following information: Mon Oct 01 15:51:24 2007: Request 7897 was acted upon. Transaction: Ticket created by [email protected] Queue: cbio-faculty-search Subject: rec letter for Dr. John Smith Owner: Nobody Requestors: [email protected] Status: new blah blah blah blah blah... and 2. Grab the first name and last name out of a From field that contains the following? "John Smith via RT" many thanks in advance

I have a simple question that is not so simple to describe. I have a database that tracks production for my cabinetshop. This database has a calculation field (TOTAL MINUTES) that subtracts one timestamp from another to tell me how long things take to build. I have recently added a QUANTITY field and would like to to divide total minutes by quantity in order to produce MINUTES PER ITEM. TOTAL MINUTES is a timefield. Whenever I divide this timefield by a numeral the result shows up as a (?) question mark. Can anybody advise me how format one of these fields to get to a decimal result? Thanks for any insight, Jarvis

Not sure what I'm doing wrong but as in the past these seems very easy for others. Below is my calc. I need to find males between the age of 18 and 24 and females between the ages of 16 and 24. My "c_Curent_Age" field just stores their age in number of years. so 12, 13, 14... its not a FM date. "Unstored, from Contact, = Case ( Contact::Gender ="male" and c_Current_Age ≥ 18 and not c_Current_Age < 25; "male" ; Contact::Gender ="female" or "Female" and Contact::c_Current_Age ≥ 16 and not Contact::c_Current_Age < 25; "female" ; "" ) " As always your suggestions are greatly appreciated.

My solution needs to discover the WAN IP address of connected clients, so it can act based on whether the user is in our LA or Chicago office. Get(HostIPAddress) or Get(SystemIPAddress) don't help, because obviously they return the address of the server and the private (LAN) address of the client, respectively. Is there any way to accomplish what I'm trying to do just by using FileMaker functions, or will I have to use AppleScript to retrieve the client WAN IPs? Many thanks, all--

I have a database which we use for quotes (at least once I finish it). It has repeating fields of item, description, price and extended. I need to make it so if discount is entered as a item, that the price calculates the qty and the last extended (line item discount... percentage of the last extended line). I've tried everything and am about ready to give up... HELP! Thanks

Hello, I am wondering, how to "calculate" the following: main table with following fields: id article number article attributes calculated text Subtable with following fields id relation to main id article attributes number a main record can have 0 to 5 subrecords "article attributes number" contains numbers that should be calculated in "article attributes calculated text". The formula of "article attributes calculated text" should do the following: - Get all "article attributes number" (probably with the list command) - Sort them in ascending order - Write the sorted numbers with "-" between each Value i.e. 3 Subrec…

Hi Guys, Im using the list function to obtain values from related records. The data is as follows, Hm A Bw B Hm Bw St A Hm Is it possible to obtain a list of unique values, i.e. just as I dont need repeats. The following is the kind of output I am looking for from the data above. Hm A Bw B St Many Thanks

Howdy, howdy: I'm having a problem trying to nail down a calculation, so here goes: 1) Say I have three fields, "A", "B", "C", and a Date field. Fields A, B, and C must be filled in before FM will allow me to enter a date in the Date Field. Once a date is entered in the Date field, I want FM to prevent changing of the data in fields A, B, and C. (The problem I'm having coding it as a calculation is that FM prevents me from changing a calculated value.) Could I set up a "lock" calculation to prevent changing of the data in fields A, B, and C _and_ the Date field? When the record is "unlocked", the Date field will be editable and when the date is remove…

Hi again, I'm sure this has been answered on here but the only thing I'm pretty sure of is that I need to change my summary fields to GetSummary fields...just not sure how to do it. I'm making a gradebook sort of thing with a points field and a points possible field. (If I get 8 out of 10 on an assignment, 8 goes in the points field and 10 in the possible field.) I made a report layout that categorizes the grades listing by class and so each class heading has a summary field that totals up the points and points possible from each class. Now I need a field that figures out the percentage of the subtotals. (If there are a total of 100 points in Math class, and I g…

I have a table defining a logical tree. Lets define a simple analogy table here, based upon windows directory structure. A folder may either have a parent folder, OR be a root folder and thus "hang onto" a drive (C:, D: etc). The result (calculation) I want is the column "Magic": Folder ParentFolder Drive Magic a1 null C: C: a2 a1 null C: a3 a2 null C: b1 null D: D: b2 b1 null D: You get the drift - very recursive.. The "Magic" formula is obviously something like this: if (ParentFolder != null; getSelectedRecord("Magic", "Folder" = ParentFolder); Drive) .. t…

I'm not sure where to post this, so this seemed as good a spot as any. We've constructed a few platforms that have a point of sale front end. Each sale record has an auto assigned serial number. Sometimes sale records will be deleted, as example if a sale is canceled or for some other reason. One of our clients recently became concerned that if they were ever audited that the IRS would be worried about the gaps in the serial numbers created by deleted transactions. There are very few gaps, but does anyone have any thoughts about this? In an audit situation would the IRS be interested in a system's internal serial numbers?

Greetings I need to keep an eye on our sales team's weekly numbers. How can I generate a script that finds all invoices for last week (which would theoretically be every Monday to Sunday). Thanks!

Hi, I'm a complete beginner in FMP. (Sorry if this is the wrong forum) I am using a web database (baseportal) simply because it has a simple interface for mobile access and I will be regularly importing the records from this into FMP. The date field, though, is ugly. Baseportal exports the date as: "YYYY.MM.DD,00:00.00#n#-06:00" with n being a number 1-9 (I'm not sure what it is yet, I think it might be dependent on the hour of the day I create the record.) Everything after the DD is constant; it is always 00:00.00... Anyway, I would like the date to be in the form MM/DD/YYYY or at the very least, YYYY.MM.DD as it appears in the original. In other words, I'd l…

If I copy and paste into a container field, it shows a picture. Can I some how get this functionality that if I insert a file such as a pdf, the field displays a custom picture but double clicking will either open the containing file OR show the export dialog.

Table 1 is an item inventory Table 2 is a record of transfers to another department I have a calculation field that totals the amount of product transfered. I'm in the process of doing a summary view (of table 1 items) that I would like to have display the product transfered in a particular date range. I've got a script that will search table 2 based on the date range, but it does not restrict the records displayed in the summary view. I'm thinking that the solution may be in the calculation field, but I can't find a function that would just sum the found fields. Thanks, Matt

Hi how do you include a zero in calculation fields? eg. 0.4 displays as .4 TIA

Hey guys! I've been racking by brain about this... The idea is to be able to break-down lines of a theater play into separate records (to take line-specific notes, change the order, etc.). The starting point is a text field with the source text, as follows: RECORD 1 (global field) Kelly. Hi George, how is it going? George. I had a long day Debby. Aww, George! Kelly. Shut it. George. Ok now, that’s enough. The end result needs to look like this: RECORD 1 field1: Kelly field2: Hi George, how is it going? RECORD 2 field1: George field2: I had a long day. RECORD 3 field1: Debby field2: Aww, George! ... You …

Hello! So I have a calc that creates a calc. For example, the results can be: "Hello, " & FirstName and I need to somewhere actually get the "rendered" results of this result, as in: Hello, John Thanks!

I'm have a problem with getting a repeating calulation field to display all values from another repeating field. Field1 Repeat Field (red,blue,green) Repeat field calc: if (Field1 = "test"; Repeat Field; "") It returns only the first value (red)

It feels like a Monday. For the sake of simplicity, I have 12 fields in a record. Each field has a value of 0 through 5. I have a calculation field in the same table in which I want to average the values in the other 12 fields EXCLUDING any "0" values. Is there a 'simple' solution?

The subject heading may be obscure... I have a table with a text field -- let's call it Table::t_Words. I want to define a field that will take all values of Table::t_Words for the current found set and concatenate them (in their current sort order). Sort of a summary field, but instead of adding or averaging numbers, it concatenates text. Can such a thing be defined? Some clever calculation, perhaps, involving value lists? Does anybody have any ideas?

Hi all friends can someone confirm that on Mac platform ( some configuration expecially the last ) it's impossible to drag and drop an image from one container to another one ? This isn't true on Windows.

I have a jobs database and it's set up to increment job numbers using serial number. My wish is to have added option of duplicating job number and adding a part # when job is related. Example- 07-0076 Fall Open House This single job is an event that will generate numerous 'sub jobs' as in posters, programs, etc. Instead of creating a new job #, I would like to change the current record to 07-0076 01 and open up a new job, 07-0076 02. I'm assuming I should use two fields, Job # (07-0076) and Part # (01) and have a calc field for lists that will display 07-0076 02, 03, 04, etc. However, I'm not sure how to handle with scripts. It would seem bes…

I just finished Employee and Time Cards db for the company where I work. Everything is working nicely and no problems throughout, thanks to people that helped here. However the db calculates times correctly by the minute. I was told to remake it so that it rounds up the times - cannot figure that one out. Please help - it should round up like this: I will use 1:00 as a full hour example, the rounding depends on the minutes Between 1:00 & 1:07 - IN time will be 1:00 Between 1:08 & 1:15 - IN time will be 1:15 Between 1:16 & 1:22 - IN time will be 1:15 Between 1:23 & 1:30 - IN time will be 1:30 Between 1:31 & 1:37 - IN time will be 1:30 …

I have an Order file with a portal called “Line_Items” and in this line items file I have a field called “Vote”. This is where a customer votes Yes or No on a given line item. After a customer votes I need some calculations. • The total number of customers who voted on this product. • The total number who voted “Yes”. • The total number who voted “No”. • The total number of people who voted “Yes” by percent. • The total number of people who voted “No” by percent. Like 77% voted Yes and 23% voted No. Something else that is important, if it's even possible, is to only show the voting results after the customer voted Yes or No. If I need to take…

I have a calculation field (GreenOverloadLight) that changes its container results based on the value of another calculation field (deviation). It works fine when "deviation" contains a number but sometimes it contains a question mark and I don't know how to reference that condition in a calculation. I have tried "= "?"" and "> "0"" but no luck. Thanks

I have been working on a couple of old mailing lists which I have combined into one. Now I need to create a new field that has an incremental ID number, but I cannot see how to get this field populated with new numbers throughout the table. In MS Access, I just created an auto-number field and it would create new ID numbers for the whole table.

hi im trying to make a extra calculationfield for the hours worked between 6:00 PM and 6:00 AM (im working in a bakery and i work al sorts of time of day )ill start sometimes at 2:00 PM till 10:00 AM and then and i start sometimes at 4:00 am etc. and now i want to use this standard example time card solution so i can keep track of my worked houres (between 6 pm and 6 am i do get 34% more payed and saturday is 24 hour 34% more payed) i did make a screenshot so it has to look like (did calculate the outcomes by hand) and make my wish more understandable thanks already!! shuold i use count? mabe someone can help me in the right direction filemaker must count the ti…

In FM9: I would like to provide FM a path to display an image during Browse and Preview on a layout for a record. This image is like a "product image" and part of the record NOT a decoration for the layout. The scenario would include about a million records and a preexisting local or web based folder of images. The path info string could either be preexisting in a field or calculated. file://localhost/Pictures/MadeOn_tang.gif OR maybe a url path http://domain/graphics/MadeOn_tang.gif

I would like to have a field automatically insert the current date based upon the condition of another field. I have a container field that has a script attached that inserts a persons signature when they click on "yes" from a question that pops up asking "Do you approve?" Yes, No, Cancel. What I would like to do is have a field called "Approved On" and have the date they approve it automatically inserted. Is there a simple way to do this? Any help would be greatly appreciated.

Hopefully this isn't too hard, here is what I am trying to do: I am creating a payroll section in my database. For each day of the week you enter the hours worked that day. Then on the side of this table I want to have fields that display the following data: - Regular Hours Worked - Overtime Hours Worked (Any hours over 40) - Total Hours - Total Pay I can figure out Total Hours (simply sum all hours), but beyond that I am lost on how to do the functions. Regular Hours should be the sum of everything, but limited to displaying a max of 40 hours. Overtime hours should show anything over 40 hours Total Pay (I think I have this one) is…

A Filemaker instructor to whom I was listening to said that field names should not begin with caps, should not have spaces (but may have underscores) if you plan to put your database on the web? Why is this so? If this is so, Is using "CamelCase" (as in "DateOfBirth") inadvisable to do in Filemaker? [color:gray]The database engine ate my previous post ???

I am trying to work out how I can insert week and year in a field. So I have a button and when I click it will insert "43 '07" or similar. Or if you have a better idea, as I work with week's in my database, and every year have the same week's I have to separate them for each year. Thanks, Mats

I am trying to make a calculation to extract specific data from a field to which I copy and paste a list of data items from another source. For example the copied data would be something like this all pasted into one field Name: Joe Age: 45 Sex: M From this field I would like a calculation "Name" field to extract the appropriate data from the pasted data field and then a separate calculation field to extract "Age" etc. Hopefully this makes sense. Let me know if I should clarify. Thanks

In my department each member has their own time card for the fiscal year staring in July and ending in June. This time card shows how many hours they worked on a specific date, in the end it calculates the hours for the month and then year. Please see attached PDF for a better idea of what I mean. I have to come up with a solution that will place the appropriate number of hours worked on a specific date for each officer. This seems awfully difficult to do, I am not even sure if it can be done. Any help would be greatly appreciated. Thanks APS___11.pdf

Hi, I want to find the Maximum Record ID in my found set so that I can alert my user that there have been new records added to the database by showing the records through a self-join that have a larger Record ID. Max( ) seems to work on the entire database, and not just the found set. Can someone make a recommendation?

is there a way to capture metadata for an image file? e.g., image resolution, image size, etc.?

Hi this is probably a daft question but i've come to the point in my life where i have to know for sure! : If you can avoid using calculations should you do so? I'm asking this because surely it uses up more processing resources? or is stuff only calculated when it is needed as opposed to being calculated in the background all the time. thanks

Hello I have several columns in a table view that I have a summary (running count) at the bottom in the footer...the summary works, but it is very slow is there a different way of doing this to speed things up?: Thanks, Tom

Hi, working on a simple time card system. Is there a way to make it to be able to enter 1800 into a time field and have the field format it as 18:00 automatically? I checked the time display options and if I for example set the separator to . and enter 10.00 is returns 00:00, if I enter 10:00 it returns 10.00 - what I want to achieve is to not have to type : when entering time so it will be easier for my boss to type in the times not having to type : every time, it will be faster to. So in summation I want to enter 1800 into time field and have it automatically formated as 18:00 or enter 513 and have it formated as 05:13 automatically if such a thing is possible…