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.
I am still very amateur on Filemaker so i hope my question does make any sense.
I am trying to write a script that would basically import order information from an email and convert it, first in a new account (if the customer does not exist) and later create a Sale Order. So far, I have managed to do that, but the problem i find is when trying to convert the sale order into an invoice. Since this order comes from our webshop when we receive the email means it is paid, so my aim is that when creating the invoice from the Sale order, this would be marked as paid and set the amount due to zero.
This would sound a very easy task, but since our solution incorporates a payments module to manage the payment of an invoice, when i try to incorporate the payment entry within my script, there is when all the trouble starts. For some reason, it gets lost in its way when runnig the script and returns a partial payment all the time. The weirdest thing is thet if I run the script on debug mode, then all works perfectly, so my guess is that the issue may be related to the speed of the script.
So, is there any recomendation as for where to put a pause script step so the script will work also when run automatically?
I have tried every possible combination of long script, shorter with other scripts inside, perform script on server... and all the time something is wrong ;(
Thanks a lot for any insight thst would help us move forward, since we have been trying to solve this for a week already.
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.
Who Viewed the Topic