Totally not sure if I've put this thread in the right topic category, as I'm not even sure how to go about this. First, I'd like to be very clear on the fact that, if possible, this will be done without scripting. I'm hoping for some kind of calculation. IDK. Anyway, I'm trying to copy or Calc one field from an older record to its newest match (using BatchNum field to match). The two fields are different fields (FormNum is the ID number field) (RefID is the the reference field for FormNum ). RefID would allow the user to find the last time the same arrangement of data (FormNum being its ID number) was used. It's meant as sort of a skipping stone effect, if that makes sense.
My thought was to create a filtered value list of some kind and just set RefID with the highest ID number from FormNum, prior to the newest entry. Or organize by newest Date Created, prior to the newest entry. Again, IDK.
I'm quite stumped and hope this rambling makes sense to you very helpful people. Thanking you in advance....
By Richard Carlton
FileMaker Coaches' Corner - Tip 5 - Portal Record Moving via Sort
For this Coaches’ Corner tip, Kristian Olsen explores using sorts to move a portal record up or down. The key is Sorts!
Grab the sample file here: http://bit.ly/2FTJn3k
Most Recent Upload https://goo.gl/Dbn9fm
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 26 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.
Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.
RCC, Filemaker Videos, and LearningFileMaker.com are headquartered in Santa Clara, CA.
Please feel free to contact us at firstname.lastname@example.org
FileMaker Pro is simply a powerful software used to create custom apps that work seamlessly across iPad, iPhone, Windows, Mac, and the web
Transform your business with the FileMaker Platform
Free FileMaker Training Videos Channel https://www.youtube.com/user/FileMakerVideos
50 Hour FileMaker Pro 16 Video Training Course-FileMaker 16 News-Online FileMaker 16 Training Videos
Top 10 New Features in FileMaker 16-FileMaker 16 News-FileMaker 16 Instructional Videos-FileMaker 16
Sharing your Database with Other Devices and Users-FileMaker 16 News-FileMaker 16 Database Sharing
Introduction to FileMaker WebDirect 16-FileMaker 16 News-Online FileMaker 16 Training Videos
A database management system (DBMS) is a computer software application that interacts with the user, other applications, and the database itself to capture and analyze data
Official site provides the SDK, Developer's Guide, Reference, and Android Market for the open source project
Free FileMaker videos check out ...http://www.filemakervideos.com
Download the FileMaker Pro 16 & FileMaker GO 16 for mobile devices training videos at http://www.learningfilemaker.com
Download FileMaker Go 16 video training at http://learningfilemaker.com/FMGO-16/fmgo16.php
Download FileMaker 16 Full Video Training Bundle at http://learningfilemaker.com/subscription.php
FileMaker Video Training Review-FileMaker 16 Video Course Review-FileMaker Pro 16 101 Course Review
Use FileMaker to create an app with the FileMaker Training Series
FileMaker Pro is a cross-platform relational database application from FileMaker Inc.
Comment, Like & Share Our Videos.
Feel Free to Embed any of Our Videos on Your Blog or Website.
Follow Us on Your Favorite Social Media
Google RSS Feed : https://goo.gl/hxtYvW
By William Slim
Figures for broken references differ completely on the Report Card vs the 'Broken References' node if FMPerception. Some figures, such as 'Impacted Layouts' are empty in the report card '--' yet may have '24' in the Broken Refs node.
What is the difference between them/how should they be interpreted?
I'm guessing the node should be relied upon but I'm having difficulty tying up figures between the two even at a headline level. In this particular instance: 'Fields Impacted' on the report card states '15' yet <Field Missing> and 'Empty Field Reference' are both in the 60's.
Thanks in advance,
Apologies if this is in the wrong forum, new to FileMaker and unsure of how to articulate what I'm trying to achieve.
I am trying to reorganize a database using FileMaker. My client's work is literary, and wants to be able to sort agents/editors by their publishing house/imprint. I am using the Personnel Files starter solution, as it comes with some of the features I'm looking for, particularly the "Personnel List". A quick summary of relationships:
Publishing Houses [House] are parent companies. Sometimes they do their own publishing, but it's often left to children companies, or Imprints. There are House-specific publishers, editors, etc [People].
Imprints [Imprint] are composed the exact same way, with Imprint-specific People. They are owned by parent companies. For simplicity, lets assume that every House has 5 Imprints.
Editors/Publishers/etc [People] have their own specific pages. House/Imprint use duplicate layouts (companies), same with different categories of People.
I want to achieve the following:
The ability to use the Personnel list to sort either alphabetically by name (as is done currently). I also want to be able to sort by Publishing House -> Imprint -> [People]. What do I need to know to do this? I envision a list of all Houses. Then, clicking on one, the imprints show up in an adjacent list. Clicking on the Imprint, People working for that Imprint pop up, and then clicking on one of them leads to their Details page (currently set up). In order to view details on the House itself, the House's own page would be set up as an Imprint.
What are the gaps in my knowledge here? Where should I start? I am trying to create a system of increasing specification for finding data quickly.
Who Viewed the Topic