By Richard Carlton
FileMaker Coaches' Corner-Tip 8-Converting from fp7 to fmp12-FileMaker-FileMaker Experts
Download the free PDFs to see FileMaker’s documentation: http://bit.ly/2nSg7BM
Get up to speed with the FileMaker Pro 16 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 16 Training Videos
FileMaker 16 Videos
Filemaker Pro 16 Video Course
I'm sure there is a simple solution to this problem, but I can't seem to figure it out!
I have a custom app that allows the user to write letters amongst other things.
Each patient is linked to a GP and a Consultant, when writing a letter to a patient there is the option to CC both the linked GP and Consultant. However, occasionally another GP or Consultant might need to be CC'd in the letter (in addition to the ones already linked to the patient). So I would need the address of this additional consultant/GP to also be CC'd in the letter. For the life of me I can't work out a simple way to do this.
Does anyone have any suggestions?
Thanks in advance.
I have a filterable portal (1) displaying contact names from a staff table. I need to click on a contact to add them to a separate portal of invitees (portal 2) on the same layout (Events) . I then need the original portal to either hide (or in some other way denote) the people already added to the second portal. In other words, it needs to be clear that a person already invited can't be invited again.
The layout is from the table: Events
Portal 1 is showing records from Staff (filterable via a global search field)
Portal 2 is showing records from EventInvitees
I need Portal 1 to only filter through those staff who haven't been invited yet.
Any help would be gratefully received.
I am struggling around using 'conditional formatting', 'hiding when…' options and non-matching field relationships!!
Thanks in advance!
New to Filemaker and new to this forum. Hoping someone can help me out.
I am working on a personnel planning system with, among others, the tables Employees, Shifts and Availability.
tblEmployees has fields like Employee ID
tblShifts has the fields Employee ID, Start Timestamp, End Timestamp
tblAvailability has the fields Employee ID, Start Timestamp, End Timestamp and Status
When in the layout Shifts I want to open a portal in a popup and I want this portal to be sorted by Availability and I want the portal rows with employees to be 'greyed out' when status = 0, green when status = 1 and normal when no Availability is given.
I basically need to know which records from tblAvailability match records from tblShifts and then which records from tblEmployees match records from tblAvailability.
How do I go about this? Do I need SQL?
Hope this is a somewhat clear question. Many thanks!
I have read the guidelines for posts in this forum. Therefore I did not enter the Post title that came first in mind: Do I understand portals (aka do I understand Filemaker) and I do not emphasize now on being new in Filemaker issues.
I am trying to achieve something simple at a first step of a big plan: Entering recipes in a Filemaker testversion database.
The longterm goal should be a database in which I can enter my collected recipes.
Followed by tool for a weekly menu plan for my family and a shopping list coming out of the database after taking care of my fridge's stock => so far so good, but currently this is a plan for the next ten years I realized starting with Filemaker.
I searched different apps and database programs, and Filemaker seems to be my solution as I did not find anything that fits exactly my expectations.
So back to the first problem: how to enter my recipes?
I created a table of recipes with an unique ID_pk (I learned already about pk and fk), Name and How-To-Make-it as well as IDs(fk) from the other tables which are Zutaten (Ingredients) with the name and the amount, Form_Zutaten (how the ingredients are used i.e. chopped, sliced, etc.) and Einheit_Zutaten (unit i.e. cup, liter, etc.). Why I have choosen this structure: because all ingredients must be combinable with different units and how the are used. otherwise I have to enter e.g. avocado sliced, avocado mashed, etc. or make rules like liquids can only be liter or mililiter or cups while flour can only be gramms etc.
So a combination of all three tables should be possible.
What I though might be an easy task is to create a recipe layout than with
and a dynamic portal depending on the number of ingredients constisting of:
Zutat - Form - Menge - Einheit
in english: Name of the ingredient - how is it, which kind/form - how much (qty) - which unit
so I related the tables via pk and fk, created the layout and bam: complete disaster.
after needing a couple of days to make the values appearing in the dropdown (learned about the value list), some fields in the portal do show the all entries of the ingredients, while the kind/form and unit fields do always show the first value of the table?
and although I locked the fields, the first entry is always shown and is getting overwritten by the choice I choose from the dropdown...
and nothing is dynamic, meaning that 7 ingredients will make 7 lines and it always starts with one empty line, etc.
I am not sure if my descriptions do make sense, therefore I am attaching my work, hoping someone could help me with how to use the portal for a convenient data entry.
thx in advance!
Who Viewed the Topic