Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About chrisknight55

  • Rank
  1. I have a parent table: CUSTOMERS I have a related table: INVOICES and I have a related table: PAYMENTS On an individual Customer detail layout I have portals for both Invoices and Payments In the related table INVOICES I have a summary field SumInvoices and In the related table PAYMENTS I have a summary field SumPayments both show on the Customer detail When the summary fields are in two different tables, how can I find the balance due? SumInvoices - SumPayments to get BalanceDue Thanks Or should I combine them into one table INVOICES_
  2. Really sorry. Below your picture it says 'Mostly Harmless' and I thought that was your username ( it could happen...). I see now your name is Vaughn. So I meant: Vaughn, thanks... Sorry. Cute works 50% of the time, at best.
  3. Thanks, Steven. Right, Usernames must be unique. I suppose an employee could ask to change it, but it would have to be done by a full access user, so we'd be aware.
  4. EDIT: Figured this out. So simple. Rather than use a field calculation in the table, I just calc it in the same script that enters the ClockOut timestamp. In a timeclock program, a timestamp is entered into a ClockIn field first, then when the employee leaves a timestamp is entered into a ClockOut field. A calculation field shows how many hours between the two. But it gives an error number (-176221) when only the clockIn field is filled. How can I suppress that (for aesthetics mostly) until the 2nd field is filled? thanks
  5. I've built a neat program that uses FMP's login to build a TimeClock that automatically clocks an employee in when they first login if they haven't yet that day. Then it offers to clock them out whenever they close the program. Works great, and seamlessly and transparently builds a payroll journal. This starts with Get ( accountname ), which I use as their unique UserName. But I can't guarantee it's unique, and thus doesn't work as a primary field. Is there possibly another field imbedded in FMP's login account t table that is auto-incrementing and unalterable, something I could
  6. This! I misunderstood your original comment of 'disproportionate' to mean my use of programming time. As to large amount of records, my strategy was to archive attendance records. Four hundred students, 20 classes a month, 12 months a year is 100,000 records in a year, five years would be half a million records, but the records are almost never used after their current month. So I'm faced with maintaining two tables, the original parent list of classes that generated the attendance roster for each class, and the attendance roster itself, and faced with operating a very large table on a
  7. Well, a shoe of course Is this the case in my request for my found set? Is it wrong? I understand I could build this 'better' by using a parent list to make the attendance roster in the first place, but I see a limitation with that. But I'd say that's not my point. The responder said "You can't.." (I don't mean to rag on him in ANY way. I so appreciate his and yours and others' help.) I'm just asking for some encouragement. Like... Here's what you've asked for. Or... Look into Omit Record and you'll find an answer. BUT, here's why a bett
  8. Yes, of course. Sorry, sorted first. And just to say, I so appreciate your help and that of others here. I'm often dead in the water by the time I get here, but I so often feel a discouragement of sorts. When someone says you can't do this, I hear I shouldn't try. But I feel just the opposite. I'm happy to keep trying. At my beginner level, every bit of this is hammering square pegs into round holes, and when it finally works I'm ecstatic. This isn't disproportionate. It's ten lines of code, it does exactly what I need, and doesn't seem to make FMP bow to my will, rather than
  9. I've found a solid solution (This from a FM-Forums in July 2008) goto record [first] loop exit loop if [ get ( foundcount ) = 0 ] if [ $id =timestamp ] omit record else set variable [ $id ;timestamp ] go to record [ next , exit after last ] end if end loop Thanks all for your help, always.
  10. I have an school attendance roster of three entered classes, with a copied time stamp: Billy Kidd Math 4/20/2011 1:21:10 Jane Doe Math 4/20/2011 1:21:10 Al Schmidt Math 4/20/2011 1:21:10 Carole King Math 4/20/2011 1:21:10 Bob Tripp Science 4/21/2011 3:18:05 Julie Tool Science 4/21/2011 3:18:05 Art Deli Science 4/21/2011 3:18:05 Joey Twoo English 4/23/2011 9:28:15 Kay Jewel English 4/23/2011 9:28:15 Daddy Love English 4/23/2011 9:28:15 How can I Perform a Fi
  11. It would hard coded, one of five or so field sets I would find and process with one script. I think I've found what I wanted: Set Variable [$aidtype; Value: "pellgrant"] Enter Find Mode[] Set Field By Name ["Students::" & $aidtype; 1] Perform Find [] If you think there's a neater way than looping thru five changes of this variable, I'd like to know.
  12. I have flag fields for types of student financial aid Students::Pellgrant Students::Staffordloan Students::Plusloan How can I write: Set Variable [$aidtype; "Pellgrant"] Enter Find Mode [] Set field [students::$aidtype; 1] // to find records where Students:Pellgrant = true Perform Find []
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.