Jump to content

bac mac

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About bac mac

  • Rank

Profile Information

  • Gender
    Not Telling

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Actually, I found that this was a new bug that has cropped up in Filemaker and Claris is working on it: https://support.claris.com/s/article/SMTP-mail-fails-when-sending-an-attachment?language=en_US
  2. Fitch- That was a good idea. After switching it to Documents path, it still failed to send the pdf, but I could see the saved file. Strangely, it did not seem to have an extension and had a google chrome icon. Double clicking it opened it in Chrome and it rendered the pdf OK. There is no Acrobat or Acrobat reader installed on that server- would that solve it? Thanks, Bruce
  3. At wits end- When I try to send an email with a record saved as a pdf attached, it won't send. The email is sent fine via the SMTP server if I do not include the attachment. With the attachment in the send email script step, the error is 1506, can't send the email. The pdf is generated from a Save Records as PDF script step to $$ACORPReportTemporaryPath The variable was generated from Get (TemporaryPath) & "ACORPReport.pdf" If I email the value of the variable in the body of an email from the script, I get: $$ACORPReportTemporaryPath = /C:/Windows/Temp/S217/ACORPRe
  4. Cool, I'll try the popover. I had looked at a couple of the starters for different approaches but I hadn't looked at Invoices- it seems to do a very nice job with this. Thanks very much.
  5. It seems that WebDirect can't access a field under another field. This will be a problem for several solutions that I've set up over the years and I wonder if there is a better method for the following: For example, in an Orders table and layout, there is a field Requestor ID that contains a foreign key that would match the Primary key in the Personnel Table. For each Order record, there is only one Requestor. The Personnel table of course contains name, contact info, etc. for potential requestors. In the orders layout, I have an underlying field (Orders::Requestor ID), that is se
  6. Thanks for the tips. Calling AppleScript worked fine.
  7. With several different PDFs in different fields, and also in different related records, I need to combine the pdfs into a single pdf. I can save the current record Save Record as a PDF and this is the only script command that can append to an existing pdf. But that doesn't solve the problem of needing to append in PDFs from a variety of different container fields. For some reason, the Export Field Contents script step does not have an append option, as does Save Record as a PDF. Recommendations?
  8. Usually, we only need to look at the exact matches because the most common test subject, Table A record, will match records in Table B that have sufficient cases for statistical significance. Failing that, we need to look further, e.g., include matches where there is one additional or one less disability- both cases would have a score of 8/9 compared to 9/9 for a perfect match. And yes, it will be entirely dependent on the test subject. We will include a limit on the mismatches and it may be 8/9 or possibly lower.
  9. That is a very concise calculation that would do well identifying records with one mismatch and allow for that mismatch to be in any of the 9 fields. Would it also go beyond that and help evaluate less equivalent matches? The context for this involves a table (B) of hundreds to thousands (depending on which data set we use) each representing a subject type with 0 to 9 different disabilities, e.g., inability to walk without assistance, inability to bathe without assistance, etc. For each of these subject types, we have a record that indicates the status with respect to each problem. Eac
  10. From a record in Table A that includes 9 fields, I need to identify the records in Table B (of hundreds of records and include 9 corresponding fields) I can easily define a relationship that retrieves the records in Table B where the contents of the 9 fields exactly match, 9 out of 9, between the Table A query record and Table B records. How do I include the best, but not perfect matches, e.g., 8 out of 9 of the fields exactly match. I can script through all of the table B records and set 9 additional temporary fields with a 1 for exact matches and 0 for mismatches, but that seems cu
  11. I am accessing SQL tables from FMP 12 via ODBC and this has mostly been working fine, except for some performance issues that crop up now and then, e.g., Not Responding appearing at the top of the window for a few minutes now and then, but then it always clears and continues to function. I don't fully understand exactly how the connection operates or the best practices. For some of the connections, I just obtain a total count of the records and the names of all of the fields in the remote table. The remote table may contain 2-40 fields and about 80 records to 150 million records. Since
  12. That totally does it. And I greatly appreciate your speedy replies. I never would have come up with that syntax. I don't think I've ever used the Quote function. In my current incarnation, I have Table Name fed by a drop down list populated by a field calculation: TableNames("") and now, when I select the desired table, I instantly see the total record count in the SQL table desired. I'll investigate the other points that you mentioned. Thank you!!! Bruce
  13. That solved it instantly! I had initially used the * and I also had tried escaping the table name, as well as too many things to mention, but never hit the correct combination. Now, I just tried playing with getting the TO name entered into the calculation from another field, and I tried escaping that as well, but can't get that to work. I also tried using the ?: ExecuteSQL ("Select Count (*) From ?";"";"";Table Name) Table Name is a field in the current table. I suspect I have to add a calculation to generate the appropriately escaped TO name. Do you have a suggestion for that sy
  14. I need some info from many tables from an SQL system and I have ODBC working and I can use the data through relationships with filemaker commands and almost everything is fine. I'd like to count the records in various SQL tables without setting up relationships and I've tried a large number of variations and searched the posts and web with no luck. For example In a calculation: ExecuteSQL ("Select Count () from Dflt.epCLC_Step3_RAN50";"";"") yields a ? This is a simple table of one field of scrambled IDs, just 50 records. Eventually, I plan to have the table specified by a fi
  15. The filter was hard coded into the portal, but I was trying to get away from using that portal. Good observations. Thanks you
  • Create New...

Important Information

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