Jump to content

Search the Community

Showing results for tags 'calculations'.



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 31 results

  1. FileMaker Coaches' Corner - Tip 11 - Improve Performance - FileMaker - FileMaker Experts https://youtu.be/5D2qoA_S7u8 Get up to speed with the FileMaker Pro 17 Video Training Course! Top Rated Course by FileMaker Expert, Richard Carlton. http://learningfilemaker.com/fmpro16.php Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions. The course is 50 hours of video content! Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. Richard works closely with RCC's staff: a team of 28 FileMaker developers and supporting web designers. He has offices in California, Nevada, and Texas. Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving FileMaker for Startups and Entrepreneurs, and client server integration. Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution. Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development. RCC and LearningFileMaker.com are headquartered in Santa Clara, CA. http://www.rcconsulting.com/ Please feel free to contact us at support@rcconsulting.com If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store. Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw Looking for FM Starting Point free software download: http://www.fmstartingpoint.com For More Free FileMaker Videos Check out Http://www.filemakerfree.com Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training. Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There. Please Comment, Like & Share All of Our Videos. Feel Free to Embed any of Our Videos on Your Blog or Website. Follow Us on Your Favorite Social Media https://www.facebook.com/FileMakerVideos https://twitter.com/filemakervideos https://plus.google.com/+FileMakerVideos/videos Filemaker Pro 17 Training Videos FileMaker 17 Videos Filemaker Pro 17 Video Course #FileMakerVideos #FileMakerTrainingVideos #WhatisFilemaker17 #FilemakerPro17Training #Filemaker17VideoTutorial #FilemakerPro17Videos #FileMakerCoaches'CornerTip11
  2. Hi guys, I’m brand new working with FM and would like your help with a calculation if I may. I want a calculation to display an estimated number of paint tins needed to paint a boat based on it’s length and width. With this information I would also like the cost of the estimated paint. I'm assuming IF can not be used as there are too many variables, can CASE? With the boats width, I've got anything over 7 classed as wide, so I've been using Jobs::BoatWidth > 7 to define narrow and wide (only two classes of widths). I'm using the table below to give our customers a rough idea at the moment but would like information to be displayed in FM specific to boats length and width for each customer after entering that data: Jobs::BoatWidth and Jobs::BoatLength. Cost of each tin is £26.32. Hope I haven't left anything out and thanks in advance.
  3. hi i have a table with 4 fields field 1 = number result 1 field 2 =number result 2 field 3= percentage result field 4 = calculation by taking in whichever is lower field 1 or 2 and multiplying by field 3 the question now is how do i script the calculation it should pick up which ever is lower but ignore if field is empty. i hope i am clear , i would appreciate if someone could help me out with this calculation.
  4. Placeholder text is a great new feature in FileMaker 14. With it you can specify by calculation what label text is to appear in a field that is empty. You can also have complete control over the styling of that text. In this article we demonstrate how to setup a placeholder and some of its benefits over standard labels. We also show how placeholder text can be used as a powerful user interface tool for displaying virtually any calculated value direct on a layout without the need for fields or variables. Click here to check out the full article at FileMaker Weetbicks
  5. jsword

    Complex Subsummary Reporting

    Hello All! I am having trouble building a complex subsummary report efficiently for a real estate database. The report layout is simple: I basically have a layout with 18 columns, all years, 2000-2017. The layout only has subsummary parts, no body parts. The subsummary part I am using to display data is sorted by a field called Micromarket (basically a geographical area). I want to display the number of units built in each year for each Micromarket. I have the report working perfectly, but I had to add many fields to my property table to accomplish this. The fields are as follows: Field Name: Number_of_Units_2000: Calculation: If ( (Year_Built)=2000;Number_of_Units ) and a corresponding Summary field that is the "Total Of" Number_of_Units_2000. I have done this for each year on the report, so I have made 18 Calculation fields, and 18 corresponding Summary fields. I then put each Summary field in its corresponding column on the layout, and for each Micromarket, I am able to display the number of units added in a given year. Is there a more efficient way to do this? I have tried performing a different find for each year within a script, then populating a Merge Variable with the result, but the Merge Variable doesn't behave the same way on the layout as a Summary field does. Any help would be appreciated!
  6. I have a Layout in Table Mode as (partially) shown in the attachment. (Note: First row will have a Country Code in it - not shown in attachment) I want to "fill-down" the last country code in all rows (in the Country Field) UNTIL the country code changes. Then I want to similarly do it for that one. Until I reach the end of rows. My database will grow from 500 to 10,000 rows of text/number data. I am uploading in batches from Excel. Is this possible? I've tried various calculations and scripting without much success. Thanks! I'm trying to get something like this: COUNTRY IT IT IT IT IT IT IT IT ES ES ES ES ES AU AU AU AU AU IN IN IN IN .......etc
  7. I am trying to chart and analyze sale data. In particular, "Most popular product(from a specific product category) this quarter/month/year/etc" and things of that nature. In this database there are several tables: I will try to explain how they are linked Sales Order -Sales Order Line Item --Product Product Category -Product --Sales Order Line Item For example, I want to see the most popular product during a certain fiscal quarter do do so, I need to filter the line items by the following criteria and then have a calculation of the sum of found line items grouped by product * order quantity: Based on the tables this criteria needs to be met: SalesOrder::OrderStatus /= "Open" (not equal) (i.e. closed/completed orders) SalesOrder::Year=CurrentYear SalesOrder::Quarter = Fiscal Quarter(or can be month or can be omitted entirely) Product::Category="my category"(whatever) I've tried many solutions and getting somewhat close, but I get stuck with Un-Index-able match fields(keys) dues to calculations from related tables or circular references. Any tips would be great. Lastly, I think I can accomplish the same thing with a script and perform multiple searches against the LineItems based on related tables, but wanted to know if there is a more direct way via the relationship graph. I'm happy to provide more details if needed. Thanks in advance.
  8. I'm trying to develop a Sports Competition Management System, which ties in with a few other features for my sports association. We have a number of leagues, based on Gender, Age, etc. which vary in team numbers, for example some leagues may have 12 teams, other only 7. Some teams play each other only once per season, other two + times, it depends on the size of the league. I have a few scripts which combined build the schedule of games (Time, Date, Round of Play) and my next step is how to create a Balanced Schedule for an Even Number of Teams, or a Cyclic Schedule for Odd Number of Teams. Obviously, an IF function determines which Scheduling Algorithm to use, based on the number of teams in that particular league. My problem now is to automatically assign the teams participating in the matches, in a way described at the following links I assume it involves a rather complex calculation at some point in the script, but after searching high and low for some inspiration, and a few trial and error attempts... Nothing tangible to show for it. Even # of Teams (Balanced) Odd # of Teams (Cyclic) My file can be downloaded from this link https://www.dropbox.com/s/3onnzm4w75s08r2/Association%20Admin.fmp12 Thanks in Advance
  9. I have the following: Table 1 – Expenses Field A: Date Field B: Concept Field C: Amount Table 2 – Flight Time Field D: Date Field E: Flight Time (in hours) I need a report that will give me the expense cost per hour, i.e. the total of Field C divided by the total of Field E. Table 1 and Table 2 are not related. What relationship must I establish between them to obtain my desired result? If establishing a relationship between the tables is not the answer, how else can I achieve the figure I need? Thank you for any help that can be provided.
  10. Using an auto-enter calculation on a field is a great way to populate its contents when other fields are modified, including itself. But what do you do if you want to use a calculation that references itself without having it trigger its own auto-enter calculation? The answer lies in thinking outside the calculation.... Read the Full Article Here…
  11. There are three tables: Services ServiceTransactions ServiceTransactionLineItems Relationships: Services:materialName::ServiceTransactionsLineItems:Material_FK and Services:MaterialYear::ServiceTransactionLineitems:TransactionLineItemYear (Services may change from year to year, and within one transaction you might line items for both current and future years.) ServiceTransaction:TransactionNumber::ServiceTransactionLineItems:TransactionFK :Services:MaterialBudgetAllocation is a user entered number. What I am hoping to do is: Get the yearly total amounts of each material (Material_FK) and subtract that from Services:MaterialBudgetAllocation to get a remaining amount.
  12. This is probably an easy design concept, but my dense brain isn't seeing it. I'm working on a timecard system, and I'm running into a problem where I have co-dependent fields. In my hours table, I have a field which calculates the amount of VTO (Variable Time Off - like vacation time) that is used if the total hours entered on a workday is less than 8. However, the system can only fill the deficit in hours (8 - hours worked) if you have enough VTO available, so the calculation first checks the value of the VTO_Available field from the related VTO_Month table. It looks like this: Let ( [ Worked = TotalHours; Deficit = 8 - TotalHours ]; Case ( Worked >= 8; 0; //No VTO needed to fill in for the current date Deficit > 0 and (VTO_Month::VTO_Available >= Defict); Deficit; //If there is enough available VTO to cover the time deficit, return the amount of the deficit Deficit > 0 and (VTO_Month::VTO_Available < Deficit); VTO_Month::VTO_Available; //If some VTO is available, but not enough to cover the deficit, use up the available amount (take to zero) 0 //Otherwise, you can't use any VTO if you don't have any! ) ) //End of Let In the VTO_Month table, the VTO_Available field is calculated as (VTO_Start + VTO_Earned) - VTO_Used. VTO_Used is a calculated field defined as Sum (Hours::VTO_Today). Obviously, I can't have two fields whose values depend on each other, but I can't think of how to set up the design to avoid this problem. I seek your guidance! Help me get to that moment where I smack my forehead and say, "Duh! I should have been able to figure that out!"
  13. I have a checkbook journal with a calc that figures the balance. I know this should be easy, but I am having a hard time figuring out how to capture the balance daily (the end of the day) and do a simple report, list, or portal that shows the daily balance. ((kind of what you see when logging in to your bank). Any ideas anyone? Than you in advance. Amy
  14. I have a table where we do our estimates. This table is used by 10 people. The estimates are comprised of estimates made by telephone, by email, and by a physical person entering our office. I have already created calculations and summaries in this table, even with the percentages for each type of estimate based on the total estimates. I have another table with the the actual contracts that have been made and the summary count of contracts made by each person. This table is used by the same 10 people. Now i need to make another table to give me the summaries of all the data from above by month. The percent of estimates that have become contracts and etc. My problem is with the relationship and the fields in the new table. I am wondering how to do this correctly? Dave
  15. There is probably a simple solution to this problem that I'm not seeing but I've read through my entire 900 page FileMaker Pro Missing Manual and I can't find the appropriate answer; I'm using FMP 13 Advanced and I have some basic experience writing scripts, etc. Here's The Goal: To start each day with a screen report of tasks to complete for my client files. I want a report that says 'today you must take care of the following items..." To keep it simple, I have a client table & a transaction table. For each transaction that I handle for my client there is at least 25-35 documents to complete. Certain documents are completed at the time of sale and other to be done during & after the sale over several week's time. It's difficult to keep track of what forms have been completed. Also I could be handling several sales at the same time compounding the administrative challenge. I do this manually now. Currently I use a simple chart layout with checkboxes that I manually fill in as each task is completed for each sale but I'd like to have it automated with daily reminders of forms still needing to be signed today, 1 day from now, 7 days from now, etc. It's easy to create a single date calculation field that says I have "X" number of days until the deadline for one item but can I do this for 25-35 reminders and ... (Here's the challenge) have a daily report telling me what is still due? I'm thinking I may have to create a "task" table that would have a related record for each one of the forms I need to complete on each client and have it connected to my transaction table. Then a script to search all relevant dates across all records. But that seems like so much redundancy to have 30+ records for one transaction file. Is there an easier way? Thanks in Advance!
  16. beckham

    Charts from value list

    Hi can anyone point me in the right direction, I have a database that as a Field populated by a value list, i.e.,: Christmas,Easter,Mothers Day , etc. I want to chart how many records exist of each chosen category. I thought it would be from a summary field using Total of and count but that option isn't available, How do I get filemaker to count the number of uses of the word Christmas from that field , can anyone help please? Thanks in advance
  17. Hello, I've been using filemaker for quite some time and tried to use it to build a "backtimer" log for Live television applications. however, after much searching, i cannot find a "real time running clock" function or plug in that allows a field to be updated with the "current time" in real time(system clock every second). a script does now work for my application as i need to be able to use the database to type notes as the time calc runs in the background. I have not been able to get a web viewer window to work because i still need a script to update the field every second. In my search i have read several times that filemaker cannot do this. I find this hard to believe. Any help is much appreciated. Thx,
  18. Hello, first time poster and FM newbie. I'm creating a DB that tracks sales for a small retail sales team. One table called "Quarter" contains a primary key called "__kp_Quarter" which is a unique identifier of a fiscal quarter. An example would be "2012 Q1". There are also two fields, startDate and endDate, which the user sets to the start and end dates of the quarter. This is entrusted to the user because lengths of fiscal quarters may vary. In another table called "Sale," which tracks individual sales, there is a "Date" field. This is also edited by the user, because some sales are backdated. I'd like to have the field _kf_Quarter, where the content is auto-entered by detecting which quarter's date range contains the sale's date. How is this possible? Is there a better method to track sales by fiscal quarter?
  19. Hello! I am trying to write a simple calculation that is proving to be more difficult than I thought. I have a real estate database with the tables: properties, transaction, and people. A property can have multiple transactions associated with it, and each transaction has people attached to it (buyer, seller, broker). I am trying to flag all the properties (in the properties table) when a certain person is linked to any of the properties associated transactions, call this person "Bill". Taking it one step further, I would like to display a "C" when the Bill is associated with a transaction with the status of "Closed" and a "L" when Bill is associated with a transaction with the status of "On Market". That is easy enough and I have that portion working (in the transaction table). The problem is I want the "C" to be prioritized, meaning if Bill is associated with two or more of the associated transactions for one property, and one of those transactions status is "Closed", and the other is "On Market", I would like a "C" to be displayed in the property table. The way it is set up now, I can only seem to look at the most recent transaction (based on closing date) and display either a "C" or "L" depending on the status of the most recent transaction. Sometimes the transaction with the status "Closed" is more recent and vise versa. How can I set this up so that the calculation looks at all related transaction records, determines if any are flagged with either a "C" or an "L", and if there are both, display the "C"? Any help would be appreciated!
  20. Hello, I am new to FileMaker and still trying to find my way around the scripting language. Even though the scripting language is quite rich, I don't feel as comfortable and flexible as I do in lets say VB. To my query now; I have designed a solution for my company which processes invoices. These invoice forms input numerical amounts tied on budget codes for each department and in turn are stored in a different table. As you can see on the image attached, I cannot find a calculation function that will sum all the amounts for each BudgetCode into AmountAllocated. AmountAssigned is the yearly department budget predefined. I will be grateful for any suggestions or ideas. Thanks
  21. Below is an image of my Script. Problem Area:(Highlighted in Yellow) Set Field [Table::Vehicle_Description1; $&"VD&$i Goal: Variables $VD1-$VD8 are holding data. I am doing a loop $i which is a counter that increments from 1 to 8. If there is Data within the variable then I want the field Vehicle_Description1 to be filled with $VD1 on the 1st iteration. Current Output: When running the script, assuming data is in $VD1, I am getting VD1 within Vehicle_Description1 instead of what data is within the variable $VD1. What is unusual: The counter $i is working fine. You can see this with the output VD1 InShort: How do you read a variable when you have to concatenate and read a dynamic variable? Any help or suggestion would be much appreciated.
  22. Hi, I have a field in a db that has a value list attached to it and checkboxes. I need to make calculation fields that will look at the field and if it contains certain text, will put "T" in the calculation field. Field Name: FEDHAZ Value List Name: Hazard Category Values: a. Fire b. Reactive c. Pressure Release d. Acute Health e. Chronic Health Since a chemical can have more than one of these values, and be checked in any order, there's quite a bit of variation as to what text the field can contain. I need to make a field, Acute, that if the field contains the "d. Acute Health" text, it will fill the Acute field with the letter "T". I could say: If (FEDHAZ = "d. Acute Health"; "T"; "" However, as you know, that will only work if the only item checked is that one. How can I get the same result no matter which other ones have been checked? Something similar to: IF (FEDHAZ contains "d. Acute Health"; "T" "" What function could I add for "contains"?
  23. Hi all, I'm hoping you can help here. I am trying to make a calculation on a layout. I need to calculate measurements of a specific drop down value that I write in a specific field. The value is called "pool." There are other values called "rapids" and "riffles" etc., but I need to write a calculation that finds running totals of the lengths between the "pools." Is it easier to run a script? If so, how to do I do this? FYI- I have another field that gives unit lengths. Again, I want to calculate the unit lengths between the value "pool". I hope this is clear enough. Ideas? Thanks!
  24. Hi! I have an Hours Sheets table, and hour sheets are created per month. I have Absences table which has absences specified by start and end date. and I have a Calendar days table, which is related with Absences with start date and end date. Now, When I create an absence spanning over two or more months, (e.g 26th March to 5th April) I want to get related calendar days for the particular month in hour sheet. (i.e if I create an absence from 26th March to 5th April I want to have 3 days (26th, 27th and 28th) in hours sheet of February month and 5 days (1st, 2nd, 3rd, 4th and 5th) in hours sheet of March. I am not able to find a way to separate out the days based on a month. ( I can not use portal filter, since I need the days to use in calculations) I have attached a sample file. Any advice/suggestions will be greatly appreciated. Thanks! absences.fmp12.zip
  25. Hi there I am on the hunt for a function or calculation that will operate like the native Extend () function but I need it to grab the data from another related REPEATING field instead for a non-repeating field which is the limit of the Extend () function. To give a bit of background on what I am doing, I have built a responsive image grid and a responsive notes grid very akin to the Facebook interface. I am at the finish line. The last thing I need to do is add "Edit" and "Delete" options to the bottom of each repetition in the portal (like a Facebook post). All other items in the grid are populated using the extend function and it works as it should of course because they are non-repeating unique data points. The structure is simple. I have a Contact table, a notesdisplayrows table, and a notes table. All data points are calculated in the displayrows table. Example: GetNthRecord (Extend(CONTACTS_NOTESGRID::ID); Get(CalculationRepetitionNumber)) However, where the "Edit" and "Delete" options are concerned I need something that will grab both the 1st and 2nd repetition of a field so that they will display as lower menu options for each repetition (I.e. Facebook). I currently have a repeating field in the notes (notesgrid) table and the 1st rep is "Edit" and the 2nd rep is "Delete". Any suggestions?
×

Important Information

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