Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


Everything posted by bcooney


    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. 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
  13. 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!
  14. 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.
  15. Active window

    Ah! Right you are Fitch. As usual.
  16. Active window

    This may be the issue. Button bars often have their active segment set to a $$var. When that $$var=a button's name (as specified in the inspector "object name"), then that button is considered "active" and renders according to the assigned style's active specs. Lots of pieces all come together. If you have two windows open, then they are both looking at the same $$var. What you need is a window-specific $$var. I believe Wim D. calls these "named buckets." (see soliant blog) So, rather than $$var, use $$var (code(get(windowname)). Now the $$var is window specific.
  17. https://community.filemaker.com/thread/179309 and https://community.filemaker.com/thread/171375 so, as I read it, one FMS cannot "see" files on another FMS. But I don't have experience trying to do this.
  18. I do not believe that you can use another FMS' files as external data sources.
  19. Security is certainly not my expertise (calling Stephan B. and Wim), but looks as if you didn't install a SSL Certificate and have in the Server Admin SSL Connections section, select [x] Use SSL for database connections. See https://www.filemaker.com/help/16/fms/en/index.html#page/fms%2Fconfig_dbserver_security.html%23 Also, with a cert. the host should be specified by its domain, not its IP.
  20. Simple Join

    Also, "T.zk_TherapistID" is not correct. You would supply the value for the parameter as a typical field reference. See Kevin's code.
  21. Simple Join

    SQL has reserved words , and year is one of them. You should escape it, \"year\" . I wouldn't use ESQL in a calc field actually. You could achieve this using a relationship. What does the data look like in the years table? Could this be a sub summary report?
  22. Sub Summary Record Count

  23. Please advice in lay-out rotation

    Still true! sadly. Perhaps bring in a graphic and rotate in another application.
  24. Sub Summary Record Count

    Not sure what "trap the sub summary count" means. Perhaps you wish to set a var to the value? Use GetSummary( ) or SQL.

Important Information

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