Calculation Engine (Define Fields)

Hi I am not sure that random function applies. But I would like to make a calculation to get a random record and a particular field for that record. random (record) "ThatField" Thanks

I haven't seen this but I am wondering if it is possible to move an object in a layout like you can move a window. Thanks

I have been playing around with the FM solution called “Time Card”….I am trying to understand repeating fields and calcs (yep, I know everyone here says to stay away from repeating fields). But I would like to use something like this in my db, and I only need a couple of fields from the example. In the db There is a repeating field called “Day Type” this field has the type of day worked “Regular”, “Holiday”, “Vacation” etc. There is a repeating field called “Hours Worked” this of course holds the total of hours worked for a specific day. So you would have: 1/14/2008 1:00pm 3:00pm “Holiday” 2.00 1/15/2008 5:00am 7:00am “Holi…

Hi, i need to know how to make in a calculation field when the answer is not true or no paid tq

I know this question has been asked and answered a million times before but I can't find any reference to it in the search files and my brain isn't working real good today......So I thought I would ask again. [color:red]How do you conditionally format the text color of a field based upon the value of another field? I have two fields: Customer & Status. If the status is "HOT" the text color for customer name should be [color:red]RED. The field is populated via "value from last visited record" and has a calculation set to: [color:blue]Case ( status = "hot";TextColor ( Customer; RGB ( 255 ; 0 ; 0 ) ) ) The only thing that happens when status is …

Stumped once again! I think this should be simple.... I have about 3000 records and from a list view I want to be able to jump to an approximately close record. Example: I have a global field - Last Name Global. Also a field - Last Name I type Smith into Last Name Global in the header section and click on the button. From whatever record it's on in list view it jumps down to the closest match in the body. I'm looking at using the 'Go to Record/Request/Page' by calculation. Or something like that I think... Any help?

I am just looking to be able to validate a field. What I want to do is make sure that different client status' bring up different fields that data needs to be entered. For example, when we mark a client as a prospect then before someone leaves the record and forgot to put in the clients b/d a pop up comes up warning that the bd is not entered, but if we mark that client 'active' then I want a popup showing that we need to put in his address. So far this is how far I get on the code. Case (Status="Prospect" ;If? I am confused after this. Any helpers?

I would like to get the number of records a user has made, so this can be displayed, then I would like to create a function to add 1 to this number so that the next record created would be individually numbered. Then when the user logs in they will see, a total of the records they have made and then when they click back and forth they will see the records numbered... Any help given most greatfuly appreciated, Thanks...

Here's what I have: Field Named: sbtDocs Field has 3 repetitions Calculation result is a Container There are 3 blocks on my Layout that show repetitions 1-3. For the field calcuation I have: If( not IsEmpty(orders::sbtSONO); Case( Get(CalculationRepetitionNumber) = 1; "filewin://srs3/Order Documents/SBT/" & Trim(orders::sbtSONO) & "C.pdf"; Get(CalculationRepetitionNumber) = 2; "filewin://srs3/Order Documents/SBT/" & Trim(orders::sbtSONO) & "I.pdf"; Get(CalculationRepetitionNumber) = 3; "filewin://srs3/Order Documents/SBT/" & Trim(orders::sbtSONO) & "P.pdf"; ) ; "" ) What I'm trying to do is c…

I need to create a simple calendar (one month at a time) for volunteer assignments at a Children's Hospital Thrift Shop. This would have 4 or 5 names per date block, and the assignment names change from month to month. I have the feeling that this could be done in FMP, but I have no idea how to do this. Any suggestions will be greatly appreciated.

Greetings I am busy developing a Sales Scorecard whereby we mark and measure the performance of our sales consultants according to certain criteria. The one thing I want to measure is the number of cold-calls per day. It is compulsory to do a minimum of 5 cold calls per day. For every cold call done, a consultant earns 0.1 points. I have worked out a total number of expected CRM per month, as well as an expected number of CRM to date. If a consultant defaults and his/her total number of CRM to date drops below the expected number of CRM to date, he or she is penalised and loses all points accumulated. His/her points will thus fall to zero for that specific crite…

Hi, again. OK, so I'm still building this financial trading DB. It's now occurred to me that a 'historical performance' functionality would be very attractive. As a new month (or even day) begins, various performance values of the trader's account are logged to new, waiting fields, allowing all manner of comparative studies to calculate against still-stored previous months' totals. But how do I capture, say, a trader's nett profit/loss on a monthly basis, automatically? Any help appreciated, Thanks

Tricky one... What I want to do is be able to get all the values of a field of a related table and combine them into a Cal field in the parent table. For example Related Table is called Contacts. In this Contacts Table I have a field called Name. Name:Record 1 = Dave Name:Record 2 = Bob Name:Record 3 = Tom Name:and so one... In the Parent Table I have a field called Contact list which is a calculation field. I want all 3 names combine into this field. for example: Contact list = Dave Bob Tom I'm sure this can be done, but I'm not sure how to get the cal field to read all the related tables fields and combine them. I realize …

I got a one to many relationship. Its People to Medical Records. I know the age of each person at the time of the Medical Record. What I need to is a field I can search on for anyone that we have a recored for between two ages but also showing me all their medical records. If person has any med_record between the ages of 10 and 12 I want to see all their medial records. How can I do this? Thanks in advance.

When i'm copying a partnumber from my spare parts application (microcat) some invisible characters come along. These characters do NOT show up in Filemaker Pro 6, but they do in FMP 7, 8 & 9. This prevents us from upgrading. I've included a test-file. Can someone explain to me why FMp7+ shows these characters, and FMP6 do not? test.fp7.zip

This shouldn't be tough but its been a long day and I'm feeling a bit fried. In a script using and if statement I need a calculation that will check to be certain that the contents of a number field end in either .00, .0, .25, .5, .50, or .75. So and entry of 8.5 is valid and an entry of 8.3 isn't. Its being used for timesheet entry. Thanks for any help anyone might have.

I'm working on a time card and have 1 field "Time In" and 1 field "Time Out". As long as the time is within one 24 hour period, it calculates perfectly (in time, not numbers) But if a person signs in at 11:00 at night and signs out at 7:00 the next morning then the problems begin. I've tried an if formula, but to no avail. Can these two different sign ins be compatible? Thanks for any help.

Hi, I'm trying to work out if it's possible to allow the user of a runtime financial trade tracking solution to input their own master timezone for their file and have all dates and times used in that file adjust accordingly? e.g. this DB is being created in LA (PST) but will ship to users all round the world who'll each be using a different remote broker for their trades, so someone living in NY might be using a broker running out of Russia, in which case a trade will be actually be executed according to a Russian timeframe. Any ideas gratefully received -)

I would very much appreciate help with trying to work this out. I’m trying to develop a number of databases using Filemaker Pro 9 Adv for a ministry in Kosovo. One aspect that I’m trying to automate for budget and personnel purposes is to show deductions on salaries for income tax. It works like this: There are four levels. After a gross salary there is a deduction for pension contributions (that I’ve worked out it’s a simple calculation and I have a field to capture the result). After that there are the income tax deductions. These are for the first 80 euros the rate is 0 From 80.01 to 250 it is 5% From 250.01 to 450 – 10% Above 450 - 20% For in…

I have a layout that is in list mode and I would like to display some text displayed, for every record, when that record is selected without having to run any scripts. Just a pure calculated field. Here is the code that I tried and failed with: If (GetNthRecord ( ID ; Get ( RecordNumber ) )=ID; "Selected" ; "Not Selected") When this is applied, the text "Selected" always is displayed for every record. My guess is that the Get ( RecordNumber ) is dependent on the record being calculated and not displayed. But at the same time, when I look at the Get ( RecordNumber ) in the Data Viewer, the returned value matches the value shown in the Status Area. I'm n…

Greetings I am busy creating a Sales Scorecord whereby we track various elements of our Sales Team Member's daily activities. My point system allows for x points per activity measured with a maximum amount of points being earned per criteria. e.g. a sales person can earn 1 point per sales course taken online, with a maximum of 5 points being earned in a given month. Can anyone assist me with a calculation which allows for this so-called maximum value. Many thanks!

I have a requirement to randomly mark a record as it is created during a month and end up at the end of the month with a minimum of 10% of the records marked. Using: Int(10*random) and then marking a record if the result is 5 (could use any number 0-9)is close. For 10,000 records you may get 978 one month and 1014 the next month. Is there a formula that can be used to insure that minimum 10% requirement is met each month?

I've never used the field validation before so its new to me but this should be an easy one for some of you. I'm working with 3 fields KitsInOut - text field with 2 option (Sent or Received) CountIn - Number field holds number of kits in CountOut - Number field to hold number of kits sent out. I want to make sure that if KitsInOut is set to Sent that no one can put a value in the CountIn field and if KitsInOut is set to Received no one can put a value in the CountIn. Any advice is greatly appreciated.

Hi I'm working with two different databases. Each record in the database called "Catalog" is of a CD with its information and a portal to another database called "Items". I input tracklistings via the portal in Catalog. Every new portal row generates a new record in Items that records the unique CD number. I would also like the Items record generated by the portal in Catalog to include the track number (what position the song places in the tracklist). Is there a way to define a field so that it generates a track # if a track is defined/Items record generated? I know that an option is to to insert a text box of "@@" to generate a number for the portal row, b…

Hello, is this possible? ( yes I'm hoping to appeal this your professional ambition by asking like that) I would like to enter a given date and time, and have a fraction of a year calculated from then. I.e. I enter Nov 21 12.15am, and a calculation tells me exactly which date and time is a third of a year (well, 0.333333 years) later. My guess is I'll have to go via a third of the 525,600 minutes that a year has. I've just never done date calculations. Cheers!

Hi. I'm struggling with math on a formula and was hoping someone would be generous enough to point me in the right direction? A transactional database. Tracking the trades of a currency trader. Each trade has a duration from a few minutes to several days. Each either closes at a profit or a loss in dollars. I want to find a way of turning the following common language sentences into formulas: "Based on your trading performance so far, you'll have '$x.xx' by the end of 2008" "Based on the monthly/annual target you set yourself of $x.xx, you're on track at x% of your target" Existing fields: profit dollars loss dollars opening timestamp c…

We have a contacts table with several thousand contacts. Inevitably there are going to be instances where two people have the same name but work for different companies. I would like to know if there is a way to have a window pop up that says, for example..."There is more than one John Smith in our system. Please select which person you would like to use." Somehow I would like to have a way for the person to select from a list of those people and have the individuals contact info fill into the correct fields. I have posted this topic before and had several views but no replies. I'm hoping that someone out there can help me. Thanks.

Hi, I'm fairly new to filemaker and have been reading the forum for a while. Thanks everyone for the great help and advice contained here. I have come a cross a problem, though that has me stumped so far. I wish to create new records in a table B that increment by 0.1, related to a record in table A. When a different record in table A creates new records in table B, I wish these to increment by .01 beginning at .01 again. For example. In table A record no 200, is related to records 200.01, 200.02 and record 200.03 in table B. In table A record 201 is related to record 201.01 in table b. In table A record 202 is related to record 202.01 and reco…

hi everyone, hope you can help me. i need to create a report, which summarize the hours * price, by part number and also by customer. i currently have a field: reportTimeReqSummary = summary of reportTimeReq (the total of hours by report number) a summary field TotalHours = getsummary(reportTimeReqSummary;partnumber)*customerpriceperhour which gives me the total price by partnumber, i need the total by customer, if i put TotalHoursByCustomer = ReportTimeReqSummary * PricePerHour, gives me the total of ALL customers, instead divides me by customer i dont know what im doing wrong and also if i put getsummary by customers, when i run the report appears 0.

hey guys, couldn't find a search term to give me the answers I needed so hopefully this is new. I am trying to create a error report page, where you have a column for time code, error and error severity. My problem is that, because the amount of errors will vary, I don't want to create a table with a preset amount of rows. I have seen databases where you could hit a button and it would insert a new row for a new 'error' but am not sure about how I should go abouts doing it. Can someone point me in the right direction?

I would like to have a calculation result also show a text string after the calculated number, e.g. in a merge field. If I have CASE(M>0;Field;)I would like to be able to add a text string after the calculation result for use in a form letter. In other words, if the calculation result is zero then nothing would be in the form letter. If calculation is >0, then the form letter would read 1 "item." Thanks for any help on this.

Hello: I have standard Invoice – InvoiceLineItems - Product setup. I am trying to achieve the following: From the perspective of the parent record if any of the child records contain ProductID P19 return 1. The context is: P19 is a Service Fee that is charged only in specific cases. I need a (control) field in parent table to return 1 if among the charges (ie the line items) there is a Service Fee for that invoice.

If Anyone can help, I'd greatly appreciate it. I want to make a field calculation. And I want the calculation to look at another field in the same record and take 2 letters out of the name and add numbers to it example: "name" field = Adventure Sport I want the "number" field to read "AS001". I can't find the function to actively select the first letter of each word. Can you help me? Thanks.

Hi, Is it possible to retain a negative number's "negative-ness" for the purpose of calculations, but lose the actual "minus" symbol for purpose of display? I'm using conditional formatting to convey positive and negative numbers and in this particular solution, the minus symbols themselves are inappropriate. I realize I can choose different ways to display a negative number, but is it possible to display nothing but the number? Any help greatly appreciated.

I am trying to do the following: have a number appear in a field if a date is greater than a particular day. I have tried a calculation formula with e.g. =50 if Date>1/1/2007 but keep getting the message that an operator is required. Can anyone help?

: Let's see if I can explain what I need... I work at a music publishing company & we receive royalty payments which are shared between us, the writers, other publishers, etc. Many times the payments are made per CD, but are then split many different ways, therefore it is never a set amount of entries for that one CD. My question is this: Is there a calculation that would figure out the total amount paid PER CD, without adding up each payment per person? Here's maybe a less confusing example: CD #1004 (may have 10 entries for a total of $50 for that one CD) CD #1005 (may have 20 entries for a total of $100) Is there a formula that would add up ju…

Hello, I apologize if this has already been discussed here, but a search didn't turn up anything of use. I have a database that I am using to catalog and track foreign language media checkouts. Each title has a catalog # of the form AA-## where the first letter is the language it is in (A for Arabic, etc), the second letter is the first letter in the title (A for Amelie for example), and the last part is a unique two-digit number that we simply increment by 1 when we get another "AA-##" title. For instance, say I have 5 titles with cat #s "AA-". The last one would have a cat # of "AA-05". If I wanted to add another Arabic film whose title started with "A" t…

Hello I have two attachments I would like to send with my email. I check the attach file box at the bottom of the send mail script step. And then I select 2 attachments. Only the first one sends. I would like to send 2 and there is provision for doing so. Is there something I need to do to send 2 attachments? Thanks Dave

do filemaker plugins (troi , activator) work under IWP? cant seem to get them to work there...

I am using a calculation to pull some data from repeating fields and enter the data into a text field. I am using the GetRepetition function in the calculation, however, the result that I get in the text box does not include the number formatting from the Repeating Field, such as the $ symbol, or comma to mark 1000's. Any help would be appreciated. Thanks.

Hi guys, I'm trying to a number of days to a start date. The days have to be work days. I have the below calc, but unfortunately it dies at 15 days because at that point you need to start adding in the additional weekends that may fall inside of the date range. Date04Stgw = work days only Date04sW = start date (adds date if falls on weekend) Date04Stg = number of days TIA If(IsEmpty(Date04Stgw); Date04sW+Date04Stg ; Let ($Day = Date04sW + Date04Stg + ((Truncate (Date04Stg / 7; 0)) * 2) + ((Round ( DayOfWeek ( Date04sW ) / 7; 0 )) * 2) ; Case ( DayName($Day) = "Monday"; $Day; DayName($Day) = "Tuesday"; $Day; DayName($Day) = "W…

: Greetings and happy new year. Rates are rising and I need to change the way they are calculated (currently as a percentage). However, when i do this, all the old record totals are changing too. How can I fix this?

I have a checkbox field of five responses, A through E. The order in which users check does influence what is produced. For example, they check box A, B, then C gives the following: A B C with a carriage return after A and B. If the user were to check B, then C, then A, the following is returned: B C A with a carriage return after B and C. My question is this: is there a way through calculations to alphabatise the response, so that each of the above examples are "ABC'? Thanks for your help!

Sometimes I feel like someone else is taking over my database? (FM9 Windows). How do others stop activity when it is no longer needed. For example, if I use a summary field to get a total FM will keep updating this afterwards in case I need it again. This means that I keep seeing the dreaded hourglass. In FM6 I dealt with this by adding a Close File script step to force it to stop, but this I must not be the first with this problem? Thanks for a response. Tony.

If a layout has “Save Changes Automatically” unchecked in layout setup, a dialog box pops up when a value is changed in a field. I am wondering if there is a way to capture the choice made by the user (Don’t Save/Save/Cancel)? Can Get(LastMessageChoice) be used for this purpose?

Hello, I read all posts (at least I think I did...) regarding images in container and haven't found the answer to my problem. I added a reference image to a db in a container using a calc. (works fine). Use same calculation to "update" or "refresh" all existing records using Record --> Replace Field Content (nice trick that work beautifully). Now I am trying to find all records that do not have an image associated with their record. Using a calc. text field I thought on using the container content but it only displays the three lines of info when imported not when referenced (only the path shows). I used unsuccessfully IsEmpty, IsValid and IsValidExpress…

So I'm creating a database to help manage public events. I'm having issues trying to get the time to be entered correctly. If i set a field as a time type, it requires me to enter the full hh:mm:ss. I would like to be able to enter time in just hours, minutes, and AM / PM, but still be able to use it in time calculations. Any ideas? Thanks!

Hi, I'm having a little problem with doing a calculation what has both a dollar value and text. When I set the calcuation as a text, then the numbers are not formated in the correct demcimal places and the "$" sign is missing. When I set the calcuation as a number, then the text disappears. Here is my code: [color:blue]Case( Contract Term = "Two", "The Contract total for the two year term is: ¶Year One: " & Grand Total & " ¶Year Two:" & Two Year Contract Total & "¶Total Contract Cost " & Contract Term Total, } This is the Result: [color:blue]The Contract total for the two year term is: Year One: 682 Year Two:750.2 Tot…

Here in Canada, they are lowering the GST/VAT from 6% to 5%. I need to redo the calculation for the field based on whether the quotation/workorder/invoice was made before or after midnight tonight. I was trying something like this but it's not working, any help is always appreciated. Case(GetAsNumber(GSTRATE) < GetAsNumber(Date(1;1;2008)); GSTRATE = .06 ; GSTRATE = .05)

I am using the GetLayoutObjectAttribute function to obtain the content from the webviewer. This webviewer is set to automatically check a different page depending on the record it is on (url based on field). A calculated field with GetLayoutObjectAttribute function gets the resultant content accordingly so I get this resultant info stored in my table. It seems to work fine. The problem is though, that it only does it for the record that was active at the moment of defining the fields involved. Also, if the content of the webviewer changes my calculated field does not update itself accordingly. The only way it seems that would work is by using scripts to force …

This is pretty cool, but you need 8.5 to do it as they made window resizing calc change as you change the size of the window. (bit more work and you could probably do any size...) Tip: Resize the window ResizeContainer.fp7.zip

Question says it. I'd like to be able to have multiple images stored in a container, which the user can then "flip" through, ala iTunes album art. Is there a way to do this? FMP7. All My Best, Jeffrey

I am working on a database that will include a photo (small JPEG) in a container field. Is there a way to display the file name of the photo (JPEG) in the database? The photo in the container field is actually placed in the database, in other words, not linked to a separate file. Thanks!

Does anyone know how to generate a list of source tables (not table occurances), exactly what you see when you go to: Define databases window >> "Fields" tab >> "Table" field dropdown list? I find that when using the "TableNames ( fileName )" function, that it lists all occurances. Again, I would like to see just the root table names.

Hello I have a field that i would like to toggle the font color in. I made the field into a button and I used the following script to make the click turn the font from yellow to green and if it was already green to yellow. If[TextColor ( colors::first ; RGB ( 255 ; 255 ; 0 ) ) //yellow Insert Calculated result[select;TextColor ( Colors::first ; RGB ( 0 ; 255 ; 0 ) )//green Else If[TextColor ( colors::first ; RGB ( 0 ; 255 ; 0 ) ) //green Insert Calculated result[select;TextColor ( Colors::first ; RGB ( 255 ; 255 ; 0 ) )//yellow end But it doesn't do any toggleling when I click on the field as a button. Can someone tell me how I can make the…

I am trying to get a running count of the Values of a Field. For example, if I have a field named "Car", populated by text values A, B, and C, how do I get a summary field that will count the number of each Value, A, B, and C?

Currently, in the "Master" table in a runtime solution I'm attempting to code, I have a date field--named "Modified"--that's defined with Auto-Enter: Modification Date; it dutifully records when any of the fields in Master have been modified and it works fine. However... (There's always a 'however'...) The calc only works in the Master table; it doesn't record any changes made to its seven "satellite" tables that are related to it. How would I code a calc so if any of the fields in all of the tables have been changed, the Modified date field in Master will update itself? At first, I thought I could have a latched field in each of the tables so that if a …

HI - I would like to find a formula that would generate random numbers (10 ) of the 1-80 like 7 19 10 27 38 39 40 30 58 80 Is this possible to do in filemaker? Thanks

I am trying to mail postcard out to a group of people but when I try to print the addresses they don't match the information on the other side. They are the opposite on the page. Any advice?

Hi, I would like some help in calculating vacation days used for our employees. Working days are Saturday thru Thrusday (Friday is off). When we calculated vacation days we give each employee 27 working days. Meaning that Fridays will not be counted. So what I need is to subtract the number of days each employee has requested by just seting the start day and the end day. This I have done. The only problem is that I don't want to include any friday that might fall into the vacation period. Example Employee takes vacation from Dec1 to Dec11, that means he will not work on either of those two dates and would be back on job Dec12. The days dedcut…

Purpose: Grab all of the field starting at the first number. Examples are: CSR2400882A (result should be 2400882A) 3266427 (result should be 3266427) CHSZzSTVa241CRMC (result should be 241CRMC) Here's what I currently have (result is text) Let ( [ num = Substitute ( text ; [ 0 ; "~" ] ; [ 1 ; "~" ] ; [ 2 ; "~" ] ;[ 3 ; "~" ] ; [ 4 ; "~" ] ; [ 5 ; "~" ] ; [ 6 ; "~" ] ; [ 7 ; "~" ] ; [ 8 ; "~" ] ; [ 9 ; "~" ] ) ; pos = Position ( num ; "~" ; 1 ; 1 ) ] ; Right ( text ; Length ( text ) - pos + 1 ) ) ... I know, I know ... but I couldn't figure out how to best approach it (obviously). I could also use Middle ( text ; pos ; Length ( text…

Merry Christmas Everyone, We read the Christmas story ... the kids are finished opening presents ... my wife made a wonderful Christmas dinner (Duck). So, I thought I would tackle a database problem ... Weird, I know. I need to export records from an address book database. However, the phone numbers are on a separate table. (see my attached example). This makes exporting a challenge for me. I thought one solution could be to have four calculation fields in the main address book table. (cHome, cCell, cOffice, cFax) ... These fields would get the information from the related Phone Numbers Table. I'm having trouble defining these potential calculation fields.…

Hello- Total NB to FileMaker, but really great product! Question: Is it possible to do a calculation outside of a field. Example: Is there a trick within a standard text box? Thanks!

I am stuck with this: I need a script to replace a field content in all found records. Lets say the field called "IsClient" in all found records should be replaced with "Yes". It works nice manual with the function "Replace Field Contents", but I cannot find a way to script it. Any help would be appreciated.

I am hoping someone can give me some advice on how to get specific data out of a field contained within a portal and show that data in other field. Simply, I have a version field and it's associated date sorted within a portal by sent date (ascending). I am trying to find a way to show that version number in another layout using the same field name, however, it only shows the first data entry made into the portal instead of the latest in the portal. Can anyone give me any pointers?

Hi, I am having trouble with one of my validation fields. I have a field that is not supposed to be empty. When the record is committed, I have a custom message displaying saying the field needs to be filled in. After clicking out the the dialog box, a second box appears (the revert dialog box) I don't want this to happen. I have built other databases that have used this same setup, however, this is the first time that the revert dialog box has appeared after the custom message. I have looked at everything very carefully, but I can't find what is different between the previous databases I have built and the one I am building now. Can anyone explain why this is happ…

I have a field named FullName from which I need to extract the last name into a separate field. I used the Calculatoin in the manual to do this when the field used the format of "FIrstName LastName" but we had to change the field to display "First Last, Title." Can anyone help with a Calc to do this? A comma always follows the last name. i.e., John Smith, MD --> Smith Thanks!

Ok, if I do this calc in a calc field and result text: Date("NonDateText") I get a result of "?" so, is there a way to capture this error and with a case statement offer an alternative answer?

2 tables : Customer table related to Invoice table as follows: CUSTOMER INVOICES CustId = CustId and gZero <> BalanceDue (gZero is a global field in Customer table = to 0) I have a portal of Invoices on Customer layout. How can I display on the layout the number of invoices that appear in the portal (ei: the number of related records)?

I am a woodworker trying to make a cutlist for a project. I've been away from FM for a while, so sorry for the beginner-like question. Using FM7, I'd like to enter data into a field as so (15 1/8) and have it stay that way. I'd, of course, like my calculations to work too! As an added bonus is it possible to have the option to enter data as a decimal and let FM convert it for me (sometimes it's just easier to enter 15.75 but I don't always remember the decimal values for 1/8's & 1/16's) A year ago, I probably would have known the answer, but I haven't entered "Layout Mode" in a while. Thanks. Bob

Hi everyone, I've been working on this database for a few months (never used FM before, all self-taught) and now I'm putting in all the functionality to provide a month-by-month breakdown of the financial side of things. To do this I am using summary fields that read through entries in two other tables (Invoices and Expenses) to determine how much of each relates to each month. I then have set up a whole series of stacking calculations which determine how much of each was present at each month, taking into account the previous months. And so on and so forth. All in all I've created about 70 calculation fields to handle all of those. There's probably an easi…

Hi I have a table named "program" and I have a table named "form" In "program " I have a field named "Billingname" and I want the contents of that field to be inserted in the table "Form" in the Field "Name". I did a script calculation where it insert calculated result in the new text field. It doesn't work. Is the only way to do this in a script by cutting and pasting? Thanks Dave

Need to calculate the total number of hours between two points in time based on four fields, StartDate, StartTime, EndDate, Endtime. I've tried, in shorthand: Hour ( Timestamp(date;time) - Timestamp(date:time) ) Also tried: Hour (DateEnd - Datestart) + Hour (TimeEnd - TimeStart) Tried all sorts of things, and I keep getting a freaked out number. Is there a simpler way of getting this data? Thanks very much!

I have a job ticket database with 3 main tables, Ticket, Bill and Customer. The structure of the database currently is one where each record in the Ticket table contains quite a large number of tally fields, i.e. one quantity (number) field per service offered. The reason it is organized this way is that the customer has a billing preference that we cannot alter. We have to end up with a report breakdown of each ticket in a table with the services provided to the customer in columns across the top. I would obviously like to see the database converted to a more powerful line item system (adding a Line Item table) so that new services can be added easily (amongst ot…

Hi everyone. I'm putting a pdf in a container using insert picture. My problem is that the pdf is multi page. Only the first page is showing. Does anyone know how to show all pages or select a page with a reference. Thanks, Mike

I have a field in a table that displays the following type of entry in one field (entries varies), this info is referenced from another table: Equipment Logistics Speaker Location I'm trying to create a new field in the same table that will display "Yes" if Equipment is one of the entries in the list. Can anyone please help me, Thanks

hello everyone, I need to display the current number of active members.. i have a field "Estado" where it displays if the members is active or not... If ( Fin de Membresia ≥ Get ( CurrentDate ) ; TextColor("OK";RGB(0;128;0)) ; TextColor("NO";RGB(255;0;0)) ) i dont know if the "Socios Activos" (Active Members) can be calculated by looking up the word OK.. and then display the total number that the word OK appears on member profiles in the Estado field? all help is greatly appreciated!

Hello all, I am looking forward to being a part of the community here. Looks like there is a ton of information to learn from. I have a question, that i cant seem to find the answer for, and the search button didn't really help, so here it is: I need to create a database that can easily calculate time figures. I can find a ton of stuff for calculating in-out times, etc. but i specifically need to add figures of time. Here is an example: I need to add up track time on a CD. So i would like to have one field that can have up to 99 times (the max tracks a CD can hold) and then have a separate field that will display the total amount of time that those trac…

I have a sub-summary part called 'Category' to categorise Sales. I have a calculation field called 'Margin', to measure profitability (profit/sales*100). I have Summary field, which is the Average of 'Margin', to enter into the sub-summary part, to enable the margin to be calculated for each category of sales. I sort the report by 'Category', but unfortunately the report shows the same margin figure in all categories. This figure is the margin for the grand total. Any ideas anyone? Chris Dixon.

Hi all !! I have no clue on how to get a list of dates in between two dates fields: datestart and dateEnd. Let see date start= 10/1/2007 dateEnd=12/7/2007. I want a list of Mon-Tues-wed-Thur-Fri-that are on the dates range. Example: 10/1 10/8 10/15 10/22 10/29 11/5 11/12 11/19 11/26 and 12/3. This is a set for Mondays. Then another set for Tuesdays and so on. Not weekends. I don't need to print the years (2007). This field is a head-columned under wich a teacher have to make a mark for each studend "present or absent". It may be just one field for each set. I tried a function (tex) if "field"="Mon" then datestar +0 ...+7...+14...+21 etc. for Mondays but it return wi…

I have Caller ID set up on my mac which opens Address Book and displays the details of the caller. Does anyone no how I would get this to work on FM. Do I use Applescript or the script built into FM or both. Basically when the phone rings, FM needs to open loaded with my database file and search the telephone field for the number, if a number is found the record is displayed.

Greetings I am trying to develop a report which identifies clients' spend with us in 2007 (so as to identify who we must send Xmas gifts to)... I have created a sub-summary report which sorts by "Year as No.", then by "Client Code" and then sub-summary by sub-total of invoices. How can I then perform a search for clients who have spent more than x? It appears as though my GetSummary field is unsearchable which makes sense to me... I just need to find out if there is any way to either find all clients with a spend of more than x or if I can at least sort the records to identify the top 10... Any help would be great! Many thanks!

Is there a way to make a script that will use a inputed date on a field and when that date comes up send a email to a given address? I would like to set reminders if possible -- not sure if this is the best way to do it but if anyone has any other ways to make auto reminders please let me know. Thank you Joseph

Should hopefully be a very quick one here for one of you super clever dudes! Is there a calculation that will give the total number of week days (excluding weekends within a given period?

I have a two tables, floor and building. In floor, I have a field called "name" that is calculated by: name = floor::number & " Floor - " & building::name I need this combined field when I specify where rooms are. It works great when I make a new floor, but if I change a building name, it does not recalculate. I read about creating a script which recommits each record, but is it really that complex? -Jeff

I have an item database. Each item in the database needs to have a picture associated with it via a reference. The files are on a network drive. Basically, I want to tell FileMaker that each item that can be found at a certain location (the location is determined by FileMaker based on the item's ID# - I've already got this working). Once found, the image of said item should be automatically linked to the record I'm having a bit of trouble implementing a solution though. Sorry if my description of the problem isn't thorough enough. I'm using FileMaker 9.0.3 on Leopard. Mark

Hi everyone, I'm finishing my great brand new filemaker database! (my first data base!) It's an amazing soft! But I can't find the function to calculate how many times does a number repeat in found records... I need to add that fuction to this script Audio Freak gave me: -Enter Find Mode -Set Field [Calls::Date_Time; Case( Customers:: Range_ "today"; Get(CurrentDate)...] -Go to Layout... -Perform Find I attach a picture to explain you better. I also attach my table, and you all are invited to take a look at this beginner's database. Thanks my dear teachers!! You make the learning easier for all us newbies B) Table__look_at_the_report_layout_.zip

I'm thinking about submitting a feature request for a new function that could expand the power of the existing calc-engine, I'd appreciate any comments anyone has about the idea, and once its polished up via some discussion, I'll submit it to FileMaker as a feature request. The concept is a function that allows for a simple iteration without having to make a recursive custom function. While there are custom functions that allow something like this, I believe a powerful built-in function could do it better (and of course, faster). I'm envisioning something like: Repeat( variable = ; ) Where the variable provided would take on each of the values in …

Hi I have a paragraph with 4 lines. Like apples oranges bananas Red orange yellow round, round, oblong, Fruit, citrus, Fruit I need to send each Line into a field like "firstline" "secondline" thirdline" fourth line" Could I get some help with this Thanks

Is it possible to export multiple containers of images into 1 image file? Because each container is one component of the image

Hi, I've got a client who is considering the purchase of v.9. They have an immediate need to automate the process of scanning e-mail responses to an online survey. Is there a ready-made solution that could strip the email header info, & flow the subsequent content into the appropriate fields? The survey is being managed by an outside provider, so not a whole lot of control on that end... Please let me know if there's a more appropriate forum for this post...and thanks for your time in responding! RobH

Can you duplicate an existing table with over a hundred fields to create smaller catagorized tables by deleting unwanted fields. I hope I made that clear. The Tramp

I have a calculation field which calculates fieldA - fieldB = X but the result calculates even if field A is empty or if fieldB is empty... how can I stop this? I can do it if fieldA is empty but how if fieldB happens to be empty also?... TIA Ben

Hi, I am trying to create a calculation that will tell me if a field contains 6 or more consonants and no vowels. What I have done so far is create a field that substitutes all Vowels to show 2 and all consonants to show 1. I admit that I started out without figuring exactly what I was going to do. But my plan is to say if there are no 2's and 6 or more 1's create a mark in another field. I was thinking that I could create a calculation that would add together the numbers in the previous filed. I just cant figure out how to add together numbers in 1 field. (I am probably missing something very obvious.) If any one has any ideas on how to accomplish my fina…

I have a field which contains Suburb and State. Sometimes suburb can be one, two or three words, and state is 2 or 3 letters. I would like to separate suburb. I have managed to pull out state using "rightword".

hi all, Can I know how to calculation the date and time? Date Start:12/12/2007 Time Start: 23:00 Total Time Use: 2 hours [color:red]Date End:13/12/2007 Time End: 1:00 So, how I calculation the Date End and Time End auto to after 2 hours? Thank for help!

Can anyone help me with a solution?? Please?! :-) We are tracking foster care youth. Placement agencies give us an excel file with the youth and all their placements - the youth are duplicated in the file- there could be up to 20 different placements or schools they have attended. How do I import these youth into specific fields I have defined? I am baffled at how to do this import... Can you help? or do you need more information? Thanks in advance.

I'm in need of inspiration. I am creating a database that will follow patients after treatment for a condition. One feature of the database will track the results of a blood test over time. There are two tables, patient data and lab data (one to many). I am ultimately trying to calculate 3 pieces of information: 1) Nadir Value - the lowest value before a treatment failure is determined. The progression of values can have small increasing fluctuations like the example below. 2) Nadir Date - the date of the Nadir Value. 3) Failure Date - the first date the lab value is >=(the nadir value + 2). Once a failure date is determined there is no need for the…

Can file maker do "If(Date >= FirstDate and <= LastDate, WeekNO,N/A)" I'm sorry this is the access from method can anyone convert it to File maker? Thanks The Tramp

Hi all I am stumped. I can do this with a script which sets the fields, but I would like it to be dynamic if possible. I have a database of documents, there are main documents (eg. 1) and sub-documents (eg. 1.1). When I sort these documents into date order, I would like the numbers to reflect the order with sub-numbers. I am trying to find a calculation that will take the value of the previous field and add 1 if it is a maindoc or not if it is a sub doc. My script basically loops through setting a global field to the documentID and then if the document is a main document it adds 1 to the global else it sets it to the global. Can this be done…