Jump to content

Search the Community

Showing results for tags 'calculation'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
    • FileMaker Server 17
    • FileMaker Pro Advanced 17
    • Command Line Data Migration Tool
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
    • GDPR
  • FileMaker Server Administration
    • FileMaker Cloud
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • FileMaker Pro 16
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 96 results

  1. Hello FM Mavens, I am likely missing something. I have a script step that calculates the dimensions of an image in a container field. There are many such fields so the script should work with any arbitrary one. I get the name of the field by using script parameter Get(ActiveFieldName). Let's say I have a container field "cont1". The script is triggered by entering the field. I am trying to calculate the height of the image by using GetContainerAttribute (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter ); "height" ) The results are question marks - I am not sure why. If I explicitly identify the fields then the expression works. Tried the same expression (Get ( LayoutTableName ) & "::" & Get ( ScriptParameter )) in the script step "Set Field by Name" and it worked, which means that the expression correctly identifies the field the script is attached to. Then why is it not getting it the first step? What's wrong with the calculation? (FM17) Thanks Asu (I hope I posted it in the correct section)
  2. Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) ) how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help. Thanks for any help DateCalc.fmp12
  3. Hello, Could someone help me with this question? I have a row in a portal in wich i would like to make a calculation: Bedrag= Cases*Prijs, but if Hoeveelheid is filled in then it should calculate Bedrag= Hoeveelheid*Prijs. The fields are all numeric. The calculation should be possible on one row, in this example i have made it on two. Yours sincerely Frans
  4. Help Please, I am trying to figure out how to extract field contents via a calculation as follows: My lookup field is ABCDEFG-01-12345.jpg I want to automaticaly extract only 12345 to be placed into another field? I tried the Calculation Right ( Sorce field; 5 ) but that returns me 5.jpg any adivise is most welcome. Thank you
  5. Hi. I have a single field, call it LETTER, with a massive calculation, but I want that calculation to be vary depending on another variable, ie a person. (Tom, George, Pete, ... ). So I"m thinking I need a table of a calculation for each person. Tom and his calculation, George and his calculation, etc , But how do I get those different calculations into the LETTER field. Is it a lookup command? Appreciate any help. George
  6. Lola

    Auto enter

    Hello All, I am using the invoice starter solution, I add a Catalogue Field to the Invoice Data Table which is an (Text ; Indexed, Look up from related Table Products::Item) I've been playing over the weekend but I cant make into work. If I put the Catalogue Number my item its not filling automatically. Can you please help me. I have also attached the file that Im working for your reference. Thank you Invoices.fmp12
  7. I have a field named "time_status" and want this to change what it displays based on another field "status". I want "time_status" to equal 'delayed' if "status" equals delayed. I want "time_status" to equal 'departed' if "status" equals departed. The last IF would be if "status" is empty I want "time_status" to equal another field named "time". This is my first IF calculation and have read some online examples but they don't seem to be working. Could someone guide me through this? Thanks, Adam
  8. I have a dashboard in my school Information Management database. I have used the technique of single portal rows to display Aggregate data such as how many total classes there are during the week and a differnt portal (& table) to display how many students attend classes (Some once a week, some twice). Ok, so far so good, 36 classes, 193 class attendees. How on earth's name can I create a calculation that shows me the average no. of students per class. (5.36) because as soon as I take this summary aggregate field out of the portal it displays just a single records data? Mmmm, I'm a bit lost here. Thanks in advance for all your help.
  9. This must be so simple, but I cannot work it out or find the answer! Using Filemaker 14. I have an old db in which my records are stock items. I currently have a number field showing the price net of tax (PRICE_NET) and a calculation field (PRICE_INC) which shows the price including tax at 10%, using the calculation PRICE_NET * 1.10. I also have a date field (DATE) showing when the item was acquired. Let’s say the tax increased to 15% at the beginning of this year. I therefore want to change the calculation in PRICE_INC so that it displays the net price + 10% if the date in the DATE field falls before 01/01/2016, and the net price + 15% if the date in the DATE field falls after 01/01/2016. Assuming there may be another tax rise in the future, I would want to modify the calculation to include the date range when the tax stood at 15%. How do I do this please? I want the prices to be always visible – so no scripts please – and I do not want to do this with look-ups.
  10. I'm coming up with questions on an hourly basis it seems...I've done google searches and still can't seem to find answers, but sometimes asking the right question is the hardest chore. Â Ok, I want to have an concession stand customer ordering system and this made sense "to me" in my graphical way of thinking, HA!: Â I have layouts for each step, such as... Â [step 1] "Select order type..." (OrderTYPE is a field with Value List to choose from via radio buttons: Walk-Up, Delivery, Pick-Up). Â I then made a 'NEXT' button that I thought I'd send to the corresponding Layout calculated by the choice selected---let's say [step 2: Walk-Up], [step 2: Delivery], [step 2: Pick-Up] accordingly. How do I do this? Â Via 'Layout Name by Calculation'? If so, what would this calculation look like (I have a basic programming knowledge, artist by heart tho, of 'if/else' or 'case' arguments) in the correct syntax? Am I even on the right thinking path? Â Reason is some orders don't require needed info compared to others (ie: Delivery vs. Walk-Up) Â [step 2] [step 3] [step 4] etc... Â I'm attempting to make a touch screen UI for iPad that is pretty simple and intuitive for taking orders. Â If there's a better way of doing this, I'm all ears (eyes ). Â Thanks for taking the time! Â
  11. I am using FMP11 Adv. I want to do something similar. I have Multiple vendors for products but not every vendor has all of the products. I want to find the average price and then mark the avg price up. I would also like to have a double check that the Sell Price is above the highest vendor price so I never sell for a loss. Example Product Sku Vendor 1 Vendor 2 Vendor 3 Avg Cost Max Price Sell Price Mouse USB 1001 9.97 13.42 10.41 11.27 13.42 14.08 Keyboard USB 1002 10.01 15.48 12.75 15.48 15.94 Optical Drive 1003 45.23 84.91 44.98 58.37 84.91 106.14 Calculated value off average would be --> 72.96 <-- Two vendors are clearing stock of an Item but the third vendor is not. The 2 vendors run out of the item but the more expensive still has stock. so to fill the order I have to get it from the vendor with highest cost. I need a double check here for the selling price so I don't accidentally blow it. One way I have thought to do this is simply to use the highest priced of all vendors. I know how to do this with the Max command in Excel but I can not seem to get an equivalent to work in Filemaker. I have done a lot with MySQL on servers and Excel on workstations. But I am new to Filemaker. I have FM running on a dual xeon quad core with 24GB so cpu time or memory is not a big deal. I know some calculations from all the reading I have been doing takes large amounts of both. My database is around 260K items and around 90Meg on the drive. I do want a clean and maintainable solution. My product list changes about 3 times a week. As I update stock and prices.
  12. I have contact list with "date_of_birth" field and "date_of_death" field. I would like to have a field that sorts the contacts by the remaining days to their birthdays, excluding the persons who have died, in which case, the field should show the remaining days to their memorial or annual "death anniversary". Appreciate your help.
  13. I have a number field that I would like to auto enter either (2, 3, or 9) at random every time a new record is created. Please help! Thanks Matt I tried to do a sequenced auto enter but filemaker simply counts up from 1 and I can't specify the 3 numbers. Thanks
  14. Hi guys, I've been searching through the forums here to get some insight into a problem I've been having, but I can't quite find enough info to figure it out. I have a FileMaker solution that tracks time spent on a job. Each job can have multiple time entries logged for it, and since a few people might be working on the same job, those time entries can overlap. For each job, I want to calculate the net amount of time that was spent. In other words, I want to ignore any time overlaps and calculate the total time spent in general, not just total up each separate time entry. Visualized, my data might look like this: 9 ------- 10 9 ------- 10 11 ----------- 1 12 ------------ 2 In the above example, I would consider the net time as being 4 hours, since some of the time logs overlap. I've attached a very basic idea of my database with some sample data. I feel like there should be a way to do this with self-joins and a couple calculations, but I still haven't gotten my mind wrapped around it. Any help would be much appreciated! OverlappingTimes_Demo.fp7.zip
  15. Hello All, I have two tables Materials Table and History Table In my Materials Table I Have the Following fields Quantity Received Quantity Used Quantity in Hand History Table Quantity Dispensed Quantity Returned Can you please help me find the right formula on how to calculate my Material Balance. For example If I have a 20 Kg Received ; then they Dispensed 5 Kg, Then My Quantity return will give me 15 Kg ; The formula that I'm using to find my Quantity on Hand is If ( IsEmpty ( Sum ( History::Units In ) - Sum (History::Units Out ) ) ; 0 ; Sum ( History::Units In ) - Sum ( History::Units Out ) ) The result is not matching with my Quantity received when I add it. Any help is appreciated. Thank you.
  16. In Matt Petrowsky's video on all things new in Fm 16 , the very first new addition is a new calculation workspace where we can see the results of our calculation. i.e. there is an additional pane in the work space where results can be previewed.( see attached pic). I can get to this workspace from the Data Viewer , but when I try to get to it from Define Fields dialog box, I just get the regular calculation workspace. What Gives ? Why is it not everywhere ? Thanks. kevin
  17. Hi.  I have created a database with clients, treatment records and am now trying to set up an invoice part. The invoice part works fine with invoice numbers  in sequence (10001, 10002... etc) created by a number field with auto-enter serial.  My two  challenges is:  1)I need to set it up so that every user/account (at the time 3 or 4) has it´s own line of invoice numbers. Therapist 1 : 10001, 10002...etc Therapist 2: 30001, 30002...etc Therapist 3: 50001, 50002...etc  Each therapist is self-employed (I don´t know if it is the right word, but I guess you can understand). Therefore, due to tax reasons, they need their own separate sequence of invoice numbers. For the same reason each sequence must be consecutive.  2) To eliminate problems with invoice number sequences, for instance if a therapist by mistake click on the button "create new invoice" I need the invoice number to be assigned when the invoice is printed and not when "create new invoice" is clicked. I can´t just use "on commit" instead of "on creation" with the auto-enter serial, because, as it is right now, I create the invoice lines in a portal, and I guess it causes problems with the relation to the "patientId" field.  Both problems would not arise if there were only one therapist and the therapist did not accidently click on "create new invoice", but unfortunately the databse is not being used in a perfect world  The database is created so that the user has to log in using their own initials, for instance TK.  I have 4 tables (related to this part): "Patient", "Faktura" (invoice), "FakturaLinier" (invoicelines), "Produkter" (products). They are related as you can see in the attached picture.  I guess I can create the 3 or 4 invoice numbers sequences with a calculation, but unfortunately I am not skilled enough yet to figure out how it should be done.  Help with some details will be very much appreciated as I am quite new to FileMaker.  Thanks!
  18. Hello, I have 2 tables (for these purposes) that look at employee records. The first, Contract_Records has one record per person per week and records extensive information about each employee week. The second, Contract_Weeks has one record per person with one field for each week to record either on or off contract. I need a calculation that finds a record in Contract_Records where Contract_Weeks::EmployeeID=Contract_Records::EmployeeID and Contract_Weeks::WeekID=Contract_Records::WeekID. Right now I am using Case ( Contract_Records::week_ID="1"; Contract_Records::Type; "NA") and it is returning the correct value for Week_ID 1 but not for the subsequent fields such as Case ( Contract_Records::week_ID="2"; Contract_Records::Type; "NA") (this is returning NA). Is something preventing FMP from looking past the first record? Is there a way to use Lookup for this calculation? I do want to be able to use Contract_Weeks to change information on Contract_Records. Thanks!
  19. JFC70

    Adding Dynamic Objects / Fields

    Quick Scenario......running FileMaker Pro 14 ADV I run several projects on behalf of clients that have multiple jobs tied to them. For example, a project might be a direct mail campaign that entails four jobs that are made up of printing an envelope, brochure, and letter, plus mailing the piece. Each job is made up of unique specifications (i.e. Size, Stock, Envelope Type, Mailing Specs, etc) that must be bid out to various suppliers. Question? I have created a "job", and "specifications" set of tables. I have populated the Job fields (JobID and JobType) and ALL of the Specifications fields (41 of them) onto an Estimate Layout. With that said, I have been using the "Hiding Layout Objects" and creating a calculation on each of the 41 fields tied to the JobType. My goal is: Tie the right specifications to the job & simplify the bidding of these jobs. Is this the best approach? Thanks,
  20. Hi Guys, I've been working with FileMaker for about a month now and am busy hacking away at my first project. Up to this point I've managed to find solutions to all of my problems on these forums and others but I've now come up against a problem that has me stumped. What I would like to do is to setup a calculation field that compares the current values of a field to the previous record value for that field in a sorted portal. I have a portal that is showing related records. My current portal has 4 related records in it sorted by date and looks like the following: Primary Key: Review Date: Value: Changed? (Has value changed since previous review - Calculated): 2 25/11/2013 5 No 1 24/11/2013 5 Yes 4 23/11/2013 4 No 3 22/11/2013 4 N/A - Inital Review The "Changed?" field is what I want to automatically calculate. I thought about using Get(RecordNumber) to get the previous record but the problem is the record numbers that Get(RecordNumber) uses might not be in order if a user enters data with a date that's earlier than an existing record. I'm really not sure how I can achieve this. I'm thinking I might have to setup some kind of related table occurance but unfortunately my understanding of filemaker is not quite there yet. Any suggestions you guys can give me would be immensely appreciated. Kind regards, LochNess
  21. Hello Filemaker developers, I need some help. I have a portal that could have one or many lines. I need to build a calculation field on the main table that can have all the lines of the portal row. The result will be used on and email that will be sent to the client. The result should be like this. Ref. 06125654 IMac 24 1,250€ Ref. 06125654 iPad Mini 750€ Ref. 06125654 iPhone 5 650€ Ref. 06125654 iPhoto 250€ What king of calculation can I use to build this portal row report inside a calculation field? Thanks for you help and support. Best regards, Joao Coutinho
  22. Hi Forum, Please help me solve a calculation for this problem, i have a table with various records, i would like to implement a field called Order_Check that would display a "1" if the table field Order_Num begins with "PT00" if otherwise it must display "0". This field Order_Num for invoice records appear to be either empty, has value ID that begins with PT00* or just have some random values, i tried the calculation: IF(Order_Number = "PT00*", 1, 0) Thank you for assisting, Miss-Amen!
  23. KA_Dev

    Azor - Project Software

    Version 13.6

    Manage your FileMaker Projects Using a FileMaker Solution Projects, procedures, customers and employees. That’s what it’s all about. Data that has been captured once can be used in multiple modules. This avoids duplication and reduces the error sensitivity. Your Company is growing? Azor grows with you and is easily managed. Try our demo: Project software Controle all your projects Azor is a central point for all information related to your projects. You have direct insight into project information such as budget, profitability, budgeting, involved participants, activities and costs. Sales & CRM Fully coordinated to your branch All your client and contact information easy to understand. Azor supports you in assessing leads & prospects per branch, sector or sales channel. In combination with the to-do module you can schedule and check-off all sales processes. • You can generate reports for your specific needs. • Summary of your contact information. • Send invoices, quotations, costs incurred. • Generate clear sales forecasts directly. • Make advanced selections for Direct Marketing campaigns. • Easily send out paper or digital mails.


  24. A little background I have a DB which keeps users logins/passwords for a business so they have all their login information for everything at work. My Issue I need the user to be able to click a button that creates a random password and places it into the password field when the button is clicked. I am making a button like this for each sections password field. I know I need to make a calculation, I have made these types of scripts before. However, how do I get to a calculation to perform this action with a button in filemaker? I am sure this is so obvious I will slap myself but right now I am at a loss. Maybe I have been working on these 5 solutions too long and need a break. LOL Any help, suggestions are very welcome...Thank you! =)
  25. Hi All, I don't really know if the Title really explains my situation, but here it is.. I have Four Fields: Name, Gender, Class and Policy Policy Field is an Unstored Calculation with the calculation below with result set to Text If ( Gender = "Male" & Class = "Primary"; "RUNNING" ;"EXPIRED") Meaning, my intention is to Set the Policy field as Running, if the Student is Male and in Primary Class, otherwise, it should be set to Expired.. The calculation does not work, some fields are displayed correctly with the correct value while others are not. However, if I remove the Logic "&" from the calculation making it only a single criterion, If ( Gender = "Male" ; "RUNNING" ;"EXPIRED"), then it works well.. Why can't I compare several fields using "&" or "OR" with that function? Is there a better way of actualizing this?

Important Information

By using this site, you agree to our Terms of Use.