This topic is 2525 days old. Please don't post here. Open a new topic instead.
I know the solution is probably very easy but it escapes me. I got this database, which I use to create invoices, year after year, I created a report page where with a neat summary field I get the "lifetime revenues", "lifetime general expenses", "lifetime total taxes" and "lifetime total invoices number", which is handy, but I need to have the same data broken down by year, and I can't figure out how to achieve that.
In another post I have been suggested to consolidate the three tables I had (Invoices 2018, Invoices 2019 and Invoices 2020) into a single table (Invoices) and then use a "subsummary" which would give me the data I want based on how I sort the records but I am not sure how to use subsummaries nor I am sure I want something where I have to multiple click to re-order records to get data one at a time; I'd rather prefer a report where a calculation of some sort would make a sum of the total revenue of my invoice records broken down by year, as I exemplified in the database I'm attaching, is that possible in an easy, possibly not involving complicated subsummaries way?
I'm beginning to get desperate on the subject, please have mercy.
By Michael Stevens
I have a parent table with 3 child tables. In the child table, there can be many related fields. I need to export only one row of data for each record in the parent table. This would require that a new column be created for each of the many values related in the parent to the child.
Noah Justin has 3 Email Address NJ@Test.com, NJ2@Test.com, and NJ3@Test.com
When I do an Excel Export from FM I get
Column 1 . Column 2
Noah Justin NJ@Test.com
Column 1 . Column 2 . Column 3 . Column 4
Noah Justin NJ@Test.com NJ2@Test.com NJ3@Test.com
I'm sure it's pretty common and there is an easy solution to this.
I have a text field, with each sentence separated by ¶ .
I would like to create buttons for each line in this field, so that I can copy each line individually (and paste manually in different application for example)
I assume that it's easy to do in calculation with GetValue, and make a script using Get (ScriptParameter) = line number in that field, for each button. ( I ll need only 7-10 lines max).
1. I can't figure out what script function I need to use to make a selective copy...
2. If one of the option is Set Selection function - how would it work in my case?
I have always developed with FileMaker for windows. I have bought myself a MacBook Air and love it. So now I am using FileMaker 16 Pro advance for MAC. I know that MAC does not label their directories like windows does. So I am having problems figuring out to get the right coding to access my photos. I have a folder called "Photos" that reside on the C: drive in windows. Then I reference that folder so pictures will populate automatically when I put in a record. Here is what I have on the windows fileMaker:
Let ( [ // Transform the contents of a container field named Images to text ImageRef = GetAsText ( ImagePath); Photos = Position ( ImageRef; "/"; 1; PatternCount ( ImageRef; "/")) ]; Middle ( ImageRef; Photos + 1; Length ( ImageRef ) - Photos ) ) images:
"imagewin:/C:/Photos/" & Film::title & ".jpg" Then I go into Import folder and point to the folder all the photos are in. The problem I have now is how to point to that folder in "imagewin", is their an alternative called imagemac, then I could put in Macintosh HD/Users/patricks/Documents. The folder is in the Document folder, called Photos. Thank you for any help.
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