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
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • 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

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 101 results

  1. This should be easy, but my brain just won't cooperate! I'm moving a bunch of stuff and want to inventory what is in each moving container. I have a very simple parent-child relationship with the parent record having the container number and category of parts/equipment/supplies and the child records describe each piece of equipment in the container. I have a portal with the child records showing for each container, but want to put anatto-entered item number for each piece that has the container number followed by a dash and then followed by a serialized number for each item in that particular container. For example, I would have container 1 labeled "Glassware" and Container 2 labeled "Chemicals". In Container 1's portal I'd like to see: Item Description Qty 1-1 Beakers, 500ml 4 1-2 Beakers, 250 ml 2 and in Container 2's portal I'd like to see: Item Description Qty 2-1 Potassium 4 g 2-2 Sodium 26 g I'd like to auto-fill the item numbers, but can't figure out how to reset the serialization for each parent record. Any help is greatly appreciated. Thanks and keep yourselves safe!
  2. 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.
  3. 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
  4. 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!
  5. Hello, I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me: I am creating operator timesheet layout for product lifecycle in list-view. Each operator has a list of unique barcodes(printed sheet) for each production function. Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1 and Marc 2. So, on the interface(list view of functions) , when an operator scans barcode of function it will set time-in field value and name of operator in their fields based on calculation from code. I don't want STOP button for each function to set value of time-out (because it requires user interaction), rather, I want it automated. I am looking for some sort of script trigger that runs on every new code scan and search for last record with similar operator name and set time-out value as current time in that record and set the same value as time-in for new function record. Thank you
  6. 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! Â
  7. 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.
  8. 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
  9. 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.


  10. 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.
  11. 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!
  12. 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
  13. 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?
  14. 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! =)
  15. 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
  16. 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,
  17. I was doing a bit of work for a client who is running FM9 clients, connecting to a file hosted on an FM11 server. I don't have FM9, so was doing development on FM11. I thought I had checked out that everything was compatible, but I somehow generated a calculation that doesn't evaluate on 9, but does on 11. The components of the calculations and custom functions used all appear to be innocuous... I am hoping someone here knows what I tripped up on. Here's the field calculation, and the 2 custom function definitions that it uses. The entire point of this calculation is to take a mish-mash text field that they have and make it sort nicely. For this bit I added, I'm just concerning myself with sorting some suffix numbers that occur between parentheses, e.g. 12345(A-1). Field calculation definition: Let ( [ _fileNum = Files::File Number ; //Position of 1st open/close parens, and then extract the text between them: _sParen = Position ( _fileNum ; "(" ; 1 ; 1 ) + 1; _eParen = Position ( _fileNum ; ")" ; 1 ; 1 ) ; _suffix = Middle ( _fileNum ; _sParen ; _eParen - _sParen) ; //Count the leading digits before any non-digit character, e.g. an alpha, or dash or space, etc. _count = CountPrefixDigits ( _suffix ; 0 ) ; //Remove extraneous characters (dash, space): _suffix = Substitute ( _suffix; ["-";""]; [" " ; ""] ) ; //Pad out the string to min 5 characters (helps 75-A sort next to 75): _suffix = _suffix & Left ( "!!!!!" ; 5 - Length (_suffix) ); //Reverse the character sequence (so the Code() call works out better): _suffix = ReverseString ( _suffix ) ]; _count & Code ( _suffix ) //prepend the digit count, but don't encode that count, just the rest of it ) -------------------- 'CountPrefixDigits ( aString ; aCounter )' custom function: If ( IsEmpty ( GetAsNumber ( Left ( aString ; 1 ) ) ) ; aCounter ; CountPrefixDigits ( Right ( aString ; Length ( aString) - 1 ) ; aCounter + 1 ) ) -------------------- 'ReverseString (aString)' custom function: If ( Length ( aString ) > 0 ; ReverseString ( Right ( aString ; Length ( aString ) - 1 ) ) & Left ( aString ; 1 ) ; Left ( aString ; 1 ) ) Thanks, Justin
  18. 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)
  19. 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
  20. 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.
  21. 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!
  22. Hi, I was here a while back learning how to build a horse racing form. Thanks to those that helped, I've been producing a form for several months now. However, I never did figure out how to make the track averages and have FM calculate my speed figures. I'd like to give it another shot, as it will save me a tremendous amount of time. Right now I am doing all the dirty work in excel and importing the track averages and speed figures into FM -- so I'm using FM as a desktop layout program, which I suppose sounds crazy. I can get FM to produce averages in a summary report, but I need separate summaries to get my speed ratings (I think). I'll try and attach a photo of a mock-up layout that might be nice. A few things: There are ten tracks, and over 8oo possible race types i.e Tok_A1_12D (Tokyo, Allowance 1, 1200, Dirt). And I only indicate race types for races on dry tracks, so there is that attribute. Also all my records are imported into a single table - so 150,000 race records so far. Anyway, I thought things like 'do I really need to make 800 separate summary calculations?' But, if that's the way it is, then fine. And as before, I still do think I have some pretty basic conceptual misunderstandings about FM -- I appreciate all the help I can get -- even the slightest pushes in the right direction. R Ave = Class Average (for race type) W Ave = Win Average (for race type) Thanks, Paul
  23. 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.
  24. 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
  25. Hi, I am trying to hide a field in a portal using a calculation on the "hide" behaviour. Based on this article from some versions back - https://www.teamdf.com/blogs/a-very-nice-way-to-format-a-sorted-portal-using-conditional-formatting/. However, I am trying to use Global Variables to achieve this. In short, my portal has a "category" field whose value is repeated. And I want to "GroupBy" it, and only show the first occurrence of the category and hide the subsequent ones. <category> <name> <description> Cat1 ... ... Cat1 ... ... << Hide Cat1 Cat2 ... ... Cat2 ... ... << Hide Cat 2 I tried to hide the <category> field using the behaviour with the following calculation: Let([ This = Category::Name ; $$Prev = $$NextPrev ; $$NextPrev = This ] ; $$Prev = This ) I keep $$Prev as the previous category value, so that if the current "This" field is the same, I attempt to hide it. This will hide all the <category> because presumably $$Prev = This. However, If I test a. $$Prev = "Cat1" b. This = "Cat1" "Cat1" gets hidden. I am just wondering if there's something wrong with my calculation? Thanks in advance!
  • Create New...

Important Information

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