By Richard Carlton
FileMaker Coaches' Corner - Tip 11 - Improve Performance - FileMaker - FileMaker Experts
Get up to speed with the FileMaker Pro 17 Video Training Course!
Top Rated Course by FileMaker Expert, Richard Carlton.
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.
Please feel free to contact us at firstname.lastname@example.org
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
Filemaker Pro 17 Training Videos
FileMaker 17 Videos
Filemaker Pro 17 Video Course
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.
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.
By Eli Walker
I'm trying to use execute sql to populate a field with the sum of all the values in a field of related records. All I get is a ? so obviously something is wrong with my syntax but I cannot figure it out. Any help much appreciated! This calculation is occurring within the 'Collections' table.
Let ( [
query = "
FROM \"Straws_for.entry\" AS S
JOIN \"Animals.to.Collections_join\" AS A
ON \"S.fk_a.to.c.join\" = \"A.pk_join\"
WHERE \"A.fk_collection\" = ? " ;
collection = Collections::pk_collection ;
result = ExecuteSQL ( query ; "" ; "" ; collection)
] ; result )
Also, after some reading on similar threads I see people suggest not using this function in a calc. field... if there's any better way of doing it I'd love to hear it. Thanks for the help, really appreciate it.
I have a set of order forms, in which each order form has X amounts of orders from X amounts of clients. I can summarize with a Summary field the number of orders each client has ordered on one order form (weekly order form) and now I want to make a report that tells me the breakdown from week to week, and quarter to quarter. I can get the report to break apart the weeks by quarter, and it displays each week's correct total, but it won't do a total sum of each quarter, let alone for the entire database.
I've tried summarizing the weekly summary field to get the quarterly amount, either in a new field, or on a trailing sub-summary part. The new field just copies the number from the weekly summary field from the record that is active, and the other way just shows the last above record. Wanna pull my hair out!
I have a feeling that the problem is in how I set up the original weekly summary field, but I just can't see how, or how to make it work.
Who Viewed the Topic