Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


bcooney last won the day on January 15

bcooney had the most liked content!

Community Reputation

111 Excellent

About bcooney

  • Rank

Profile Information

  • Gender
  • Location
    Long Island, NY

FileMaker Experience

  • Skill Level
  • FM Application
    16 Advanced

Platform Environment

  • OS Platform
  • OS Version

Recent Profile Visitors

19,023 profile views

    Hmm...I did know about the fact that ESQL's performance suffers if the table that you are querying has an open record. However, I'm not sure PSOS gets around that. I think if that client has an open record, even with PSOS, you still suffer. Maybe Wim will confirm...

    Not sure in what form you need the results. Here's your file back with two global fields that contain a list of unique skus and the count of that field (set by script). DEMOv2.fmp12

    I think we're missing a piece of the puzzle. can you post a file? attached demo showing two ways to get a list of unique skus. Also can use value list (old school technique). uniqueDemo.fmp12
  4. Glad to help. Step back and think data model before diving in always helps. Build a solid foundation.
  5. NewBoard, OK, so you're in the process of beginning a new FM project and your goal is to report on deliveries, by supplier. I immediately think thru the entire system needed to support such a report, perhaps the following tables: Supplier (or party) order order_line shipment shipment_line parts Each shipment has a type (incoming for receipts, for example), id_supplier and a date. So, by reporting on the shipment_line table, I can generate your report. No need for a month table (I just group by month of shipment date, supplier). Also, I'd ask the user via a dialog for a date range, and incorporate a find in my script. Still not sure how you determine whether a shipment receipt was "on-time." Where is the date that you expected to receive the shipment? I would expect it's in the related Order record or related order_line record. To answer your original question: List (relatedTable::id) provides a delimited list of the related table's ids. or Let ([ $query = “ SELECT id FROM myTable “ ; $result = ExecuteSQL ( $query ; “” ; “”) ]; $result ) //end let if you'd like to use SQL
  6. Not how I would model this. In what table are you recording receipt of parts?
  7. "List of all Records in a Field" not a valid phrase. List of all values in a field, perhaps? That depends on where you are in the relationship graph. So, where are you? On a supplier's layout based on a table occurrence that points to the supplier table? And, if this is a report of on-time delivery, what data are you reporting? Sounds more like a sub summary report is needed perhaps from a table based on receipts? EDIT: I hope I'm not coming across a bit pedantic. It's very helpful to use the proper terminology to be sure that you build your FM knowledge with a firm base.
  8. It's not clear what context you're in or how the tables may be related. However, the first thing that jumps out to me is your use of List ( ) https://fmhelp.filemaker.com/help/16/fmp/en/#page/FMP_Help%2Flist.html Note, unless you're pointing to a related field, you will not get a list of values. If you are on a found set of suppliers, perhaps you could use $supplierCount = get (foundcount) It's also not clear where you're going with this. A Month table?
  9. FM Versions vs Mac OSX versions

  10. Filter a Portal with a Calculation Field

    Yes. I think you might need a commit and refresh. Have a look at this technique for "filter as you type". http://filemakerinspirations.com/2010/10/dynamic-portal-filtering-while-you-type/
  11. https://fmforums.com/topic/100780-server-smtp-with-gmail/
  12. Just an update. My issue was that the break field needs to be in the same table (even if it's an unstored calc) as the summary field. The hide calc = GetSummary ( summary_field; break_field) = 0. (The summary part is sorted by the break field). hope this saves someone else the hours it cost me!
  13. Well, I realize that get summary is needed because these are subtotals. Still not working in my actual file. I'll try <1 rather than =0.
  14. I'm running into an issue hiding a text object in a sub summary part when a summary field in the same part is empty or zero. I created a little demo file to show my issue. I resorted to using Get Summary, but that still doesn't work in my solution (but it's much more complicated report there). I'd appreciate feedback as to why I needed Get Summary. tia, Barbara summaryhide.fmp12

Important Information

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