-
Content Count
4,017 -
Joined
-
Last visited
-
Days Won
51
bruceR last won the day on June 1 2020
bruceR had the most liked content!
Community Reputation
164 ExcellentAbout bruceR
-
Rank
consultant
Profile Information
-
Gender
Male
-
Location
Redmond WA
FileMaker Experience
-
Skill Level
Expert
-
FM Application
18
Platform Environment
-
OS Platform
Mac
-
OS Version
High Sierra and El Cap
FileMaker Partner
-
Membership
FileMaker TechNet
Recent Profile Visitors
37,162 profile views
-
bruceR started following Auto entry based on Checkbox Set and Numbering portal records
-
While comment's suggestion works, I experience a few problems with it. Consequently, I always add a calculation field to my tables, and make it unstored, get( recordNumber). See attached example file and screenshots. The advantage of using a layout variable is that you don't need to modify the field definitions. The disadvantage, in my experience, is that any time you touch the formatting of the variable, it resizes itself. SimpleRecNum.fmp12
-
Glad you have found it useful. It's a good staring point for you but there are certainly things I'd change or improve. Others may or may not jump in to demonstrate some of those improvements, by modifying this file or contributing their own.
-
I updated the example to take away a few of the messy parts.
-
Comment has suggested a much more relational approach. Attached is one take on that, hopefully it will give you some ideas. It uses tables for Patients; CASES; CaseCharges (line items); FEES; and a PROCEDURES table and associated ProcedureCharges table. It is in a semi-polished state, some things are in place that I was just testing. CHARGES_TEST modBFR.fmp12
-
As stated by comment; you don't select it using the TYPE field. CardsMyExample MODB.fmp12
-
" I have 2 tables; CARDS and TYPE" Nope. You have two tables; PASSWORDS and TYPE. Nothing about your design requires TYPE to be unique.
-
Josh Ormond started following bruceR
-
Script for incrementing a counter
bruceR replied to John Chamberlain's topic in Calculation Engine (Define Fields)
Help will be impossible until you specify user name and password for your TEST file. -
Why? Why do you think you need to do this?
- 3 replies
-
- script
- go to field
-
(and 1 more)
Tagged with:
-
It’s generally a lot easier to understand a complicated request if you post a clone or an example file.
-
Replace command in script fails
bruceR replied to John Chamberlain's topic in Script Workspace and Script Triggers
What you have quoted is erroneous. There can be no double quote in the go to field statement. But delete that line anyway; it isn't needed. Instead: Go to Layout ["Client Data" (Client Data) Replace Field Contents [ No dialog ; Client Data::New Emergency Date ; ""] -
Table-Based Value List: Can't Retain Names Entered On-The-Fly
bruceR replied to Peterteneldas's topic in Value Lists
Note that this exact same subject is being discussed on FileMaker Community. https://community.filemaker.com/thread/184913 -
Local Variable held from previous session
bruceR replied to eswanborg's topic in Script Workspace and Script Triggers
I'd suspect something else then. Some conditional formatting or hide calc, some ill-written custom function, even your data viewer watch functions; something is declaring that variable. The fact that you can't post a full and complete script - is also troubling. Have you got Advanced? Can you generate a DDR? -
Where is your actual script? How are you triggering the script? Can you show us your file or a simple example file? There will need to be a second step in the script so you can stop in debugger and look at the variable contents before the script ends. Since you are using a script variable ( single $ variable) it will always be empty after the script runs. While this is something you should be able to do successfully - in real life, what do you want to do with $fieldName?
-
Major Detail on a Child layout/table, not the Parent
bruceR replied to Christoph's topic in FileMaker Server 16
WHICH two layouts? No, they are not independent of each other. They are based on the same table. Your entire premise here has been to do something "not the parent" which makes no sense, and you have been unable to explain. -
What does select mean - to you? And after "selecting" - what is next? What are you actually trying to do?