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 Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • 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
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • 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

Blogs

There are no results to display.

There are no results to display.

Categories

  • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 97 results

  1. I found a thread regarding this from 11 years ago, but couldn't find anything else so thought it may be best to check if the newer versions of FM have a solution to this problem. Is there any function or custom function that would allow me to check if the value in a field is numeric? I have a field that is supposed to be only numeric (primarily only positive integers) however occasionally there are entries like '1 + 4' or '10 + 2'. I'd like to enter the contents of this field into another field, but only with the entries that are numeric only. Any thoughts? Really appreciate any help.
  2. 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)
  3. 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
  4. 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.
  5. 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
  6. 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!
  7. 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
  8. 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?
  9. 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! Â
  10. 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
  11. 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!
  12. 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! =)
  13. 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.

    $500.00

  14. 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
  15. 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!
  16. 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.
  17. 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!
  18. 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
  19. 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
  20. 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,
  21. 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
  22. 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
  23. 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.
  24. 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.
  25. 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
×

Important Information

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