Jump to content

HonkyCat

Members
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

0 Neutral

About HonkyCat

  • Rank
    member
  1. Thank you "Comment"! That worked perfect!! Kristine
  2. Hi, Thanks for the response. I know it says I'm working on Dev 7; but for this scenorio it is actually for FileMaker 6. So I'm thinking that solution won't work. -( Sorry about that. Any other suggestions?
  3. Hi, We currently use the following calculation (see "a") to display a month, day, and year date (and it works great). Now I want to add an option that will look for a certain customer number and if the result is true, then display only the month and year of a date. If the answer is false, then display the month, DAY, and year. Example "b" shows my new calculation, but it does not work. I've been racking my brain on how to make this work including different variations...case statements, etc.. Can anyone tell me what I'm doing wrong? a. If(LabSchedule="Monthly",Date(Month(Sample Date)+1,Day(Sample Date),Year(Sample Date)), If(LabSchedule="45 Days",Date(Month(Sample Date),Day(Sample Date)+45,Year(Sample Date)), If(LabSchedule="Bimonthly",Date(Month(Sample Date)+2,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Quarterly",Date(Month(Sample Date)+3,Day(Sample Date),Year(Sample Date)), If(LabSchedule="120 Days",Date(Month(Sample Date)+4,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Semi-Annual",Date(Month(Sample Date)+6,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Annual",Date(Month(Sample Date)+12,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Random","", If(LabSchedule="Other","","")))))))))))))))))) b. If(LabSchedule="Monthly",Date(Month(Sample Date)+1,Day(Sample Date),Year(Sample Date)), If(LabSchedule="45 Days",Date(Month(Sample Date),Day(Sample Date)+45,Year(Sample Date)), If(LabSchedule="Bimonthly",Date(Month(Sample Date)+2,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Quarterly",Date(Month(Sample Date)+3,Day(Sample Date),Year(Sample Date)), If(LabSchedule="120 Days",Date(Month(Sample Date)+4,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Semi-Annual",Date(Month(Sample Date)+6,Day(Sample Date),Year(Sample Date)), If(LabSchedule="Annual",Date(Month(Sample Date)+12,Day(Sample Date),Year(Sample Date)), If(Customer# = "145" and LabSchedule="Monthly",Date(Month(Sample Date)+1,Year(Sample Date), If(Customer# = "145" and LabSchedule="Bimonthly",Date(Month(Sample Date)+2,Year(Sample Date), If(Customer# = "145" and LabSchedule="Quarterly",Date(Month(Sample Date)+3,Year(Sample Date), If(Customer# = "145" and LabSchedule="120 Days",Date(Month(Sample Date)+4,Year(Sample Date), If(Customer# = "145" and LabSchedule="Semi-Annual",Date(Month(Sample Date)+6,Year(Sample Date), If(Customer# = "145" and LabSchedule="Annual",Date(Month(Sample Date)+12,Year(Sample Date), If(LabSchedule="Random","", If(LabSchedule="Other","",""))))))))))))))))))
  4. Thanks for your help Jerry! Kristine
  5. Thanks for your help Jerry! Kristine
  6. Thanks for your help Jerry! Kristine
  7. We are a lab that tests compressed air for our customers. With FM 7 we want to be able to better track when each customers compressor system is due to be tested. One customer can have many systems to test and it is possible for each of their systems to be on a different testing schedule. I know we need at least 3 tables. A table for customers, a table for contacts, and a table for the compressor systems. One customer can have many contacts; and one customer can have many systems to track. Some of our customers also have customers of their own (they are distributors for us). In the past we did not keep track of their clients compressor systems (they handled it on their own). But with FM 7, we want to start keeping track of when their customers are due for tests as well. However, I don't want to lump them in with our DIRECT customers because we need someway to know that they 'belong' to another customer. This is where I start getting confused on how to design the solution. Would it be best to have another table (we'll call it "Their Clients") and then a completely separate table with 'Their Client Contacts' and then another separate table with 'Their Client Compressor Systems'? Or is there a way to keep track of all of this information in the original 3 tables I described? The 'key fields' involved are tripping me up. I hope this makes sense. Thanks for any help you can give me! Kristine
  8. We are a lab that tests compressed air for our customers. With FM 7 we want to be able to better track when each customers compressor system is due to be tested. One customer can have many systems to test and it is possible for each of their systems to be on a different testing schedule. I know we need at least 3 tables. A table for customers, a table for contacts, and a table for the compressor systems. One customer can have many contacts; and one customer can have many systems to track. Some of our customers also have customers of their own (they are distributors for us). In the past we did not keep track of their clients compressor systems (they handled it on their own). But with FM 7, we want to start keeping track of when their customers are due for tests as well. However, I don't want to lump them in with our DIRECT customers because we need someway to know that they 'belong' to another customer. This is where I start getting confused on how to design the solution. Would it be best to have another table (we'll call it "Their Clients") and then a completely separate table with 'Their Client Contacts' and then another separate table with 'Their Client Compressor Systems'? Or is there a way to keep track of all of this information in the original 3 tables I described? The 'key fields' involved are tripping me up. I hope this makes sense. Thanks for any help you can give me! Kristine
  9. We are a lab that tests compressed air for our customers. With FM 7 we want to be able to better track when each customers compressor system is due to be tested. One customer can have many systems to test and it is possible for each of their systems to be on a different testing schedule. I know we need at least 3 tables. A table for customers, a table for contacts, and a table for the compressor systems. One customer can have many contacts; and one customer can have many systems to track. Some of our customers also have customers of their own (they are distributors for us). In the past we did not keep track of their clients compressor systems (they handled it on their own). But with FM 7, we want to start keeping track of when their customers are due for tests as well. However, I don't want to lump them in with our DIRECT customers because we need someway to know that they 'belong' to another customer. This is where I start getting confused on how to design the solution. Would it be best to have another table (we'll call it "Their Clients") and then a completely separate table with 'Their Client Contacts' and then another separate table with 'Their Client Compressor Systems'? Or is there a way to keep track of all of this information in the original 3 tables I described? The 'key fields' involved are tripping me up. I hope this makes sense. Thanks for any help you can give me! Kristine
  10. Hello, I'm hoping someone can help me. The goal: to AppleScript a SECURE PDF through Acrobat and have it automatically have the PDF attached in an email. I don't know AppleScript very well so I'm having trouble doing this myself. I currently have an AppleScript that I got from either Apple's website or from this website (not sure which). It will automatically create a pdf, give me the option to name it, then it automatically creates a new email message in "Mail" and attaches the PDF. The script resides in my Library folder inside a folder named "PDF Services". That way when I print a document, there is a button in the print dialog box called "PDF". When I click it, my AppleScript (I named it "Email PDF") is right there for me to click. Then boom, it's done (the PDF is created and attached in a new email). It works beautifully, but it won't automatically SECURE the document. Someone has to go and manually do that. Through Acrobat Distiller there is a way to set up a folder called "Watch" in your documents folder, then have an "In" folder and an "Out" folder inside of the "Watch" folder. You only have to do this one time. Then you go into Acrobat Distiller and set the security for the "Watch" folder (you only have to do this one time as well). Once you've done that, when you go and "Print" a document from FileMaker (when the Print Dialog box appears) you see a list of choices (mine starts with "Copies & Pages"). If you click on that list, there is about 12 options. One of those options is "Output Options". Under "Output Options" I can check mark a box for "Save as File". Then I can choose "Format: Post Script". Choosing "Post Script" is what tells FileMaker to send the document through the "Watch" folder, then to the "In" folder, then spits it out into the "Out" folder. I'm sure Acrobat comes into play somewhere, but I never see it. I guess it goes through Acrobat Distiller. But, once it's gone through those folders, when it gets to the "Out" folder, the document is secure. So my question is can someone script the Output Option (Format: Post Script) into my existing AppleScript (and have it work right)? I already have the Watch folder, the In folder, and the Out folder so I don't need that. Here is my current AppleScript... on open these_items try set this_file to item 1 of these_items tell application "Finder" set the file_name to the name of this_file set the parent_folder to (the container of this_file) as alias end tell tell application (path to frontmost application as string) repeat display dialog "Enter a name for file:" default answer file_name set this_name to the text returned of the result if this_name is not "" then exit repeat end repeat end tell tell application "Finder" set the name of this_file to this_name set the target_file to (document file this_name of the parent_folder) as alias end tell tell application "Mail" set the new_message to (make new ougoing message with properties {visible:true, content:" "}) tell the new_message tell content make new attachment with properties {file name: target_file} at before the first character end tell end tell end tell on error error_message number error_number if the error_number is not -128 then tell application (path to frontmost application as string) display dialog error_message buttons {"OK"} default button 1 end tell else tell application "Finder" to delete parent_folder end if end try end open Thanks to anyone who can help me!!! Kristine
  11. Hey Ray, Just wanted to tell you I did what you said and it works perfect!! Thanks for taking the time to help me! I really appreciate it!! Kristine
  12. Hi Ray, You're right about me working in FM 7, I was just testing you. Old habbits die hard. Thank you so much for your response. I'm not currently at work so I can't do what you suggested right now. But judging from what you wrote, I guess I was REALLY taking the long way around!! I'll let you know how it works tomorrow, but I just wanted to say thanks in advance! I love this forum!! Kristine
  13. I need help! Or tell me I'm making this too difficult and there is an easier way!! It's driving me crazy! I have two tabels (Company and Contacts). The goal that I'm trying to achieve is to be in the Company table with a portal showing the different contacts for that particular company. We have 4 main types of contacts for each company... Reporting, Billing, Shipping, and Purchasing. We can have multiple contacts for each category. I want to have a layout where Company information is the main table in the layout, and a portal showing the contacts. I want to have a tab labeled "Report Contacts", another tab labeled "Billing Contacts", another tab labeled "Shipping Contacts", and a 4th tab labeled "Purchasing Contacts". When the user clicks on one of the tabs (lets say "Reports") then it shows all of the Reporting contacts we have for that particular customer. Then if they click on "Shipping Contacts" tab, it takes them to an identical layout that instead shows all of the Shipping contacts we have for that particular customer. I have a field in Contacts called "ContactType". The user would choose from a pull down list the type of contact it is, (shipping, billing, reporting, or purchasing). Then I have 4 calculation fields in the Contacts table. The first is called "ReportContact"; it's indexed, from Contacts = If(ContactType = "Reporting"; "Reporting"; " "). The 3 other calculation fields are exactly the same as this one, but replace, "shipping", "billing", and "purchasing" respectively in each. I hope that makes sense. Then I made a self-join relationship to each of the 4. 1st relationship is from Contacts (Table Occurance) to Contacts 2 (TO) using the Company ID and ContactType as the Key Fields and Company ID and ReportContact as foreign keys. Again, made another self-join relationship...this time from Contacts 2 (TO) to Contacts 3 (TO). Company ID & Contact Type as key fields and Company ID & ShippingContact as foreign keys. I did this 2 more times. So basically I have a total of 5 Contacts table occurances on the graph. I then put a portal on the first layout (to show the Reports contacts), I used the Contacts 2 (TO) and the fields from that same table occurance for the fields. Then on a second layout I used Contacts 3 (TO) to show the Shipping Contacts. Then a thrid layout I put a portal showing Contacts 4 table occurance for the Billing Contacts and fields from that table occurance. And so on for Purchasing Contacts on a fourth layout. The Reports Contacts works perfectly, shows all the right data etc., but none of the other portals display ANY information at all, even though the fields are marked correctly as a shipping contact, or purchasing contact, etc.. What am I doing wrong??? Please help! Thanks! Kristine [color:"red"] [color:"red"]
  14. Hi, I was reviewing post #101779 in the "PDF" section of the FM Forums. The post talked about AppleScripting the creation of a PDF. I copied Apple's "AppleScript" as suggested...the script makes a PDF and sends it straight to an email. It works great! I'm just wondering now if there is a way to incorporate making a SECURE PDF into that same AppleScript. Anyone have any ideas or suggestions on where I can find out how to do this? Thanks!! Kristine Stone
  15. I'm having the same exact problem as Reed where the email address doubles itself. I'm doing the same thing...have a script that loops through the found set and sends a customized message to each recipient. I'm using OS X 10.3.2 and FMP 6.0 v4. Kristine
×
×
  • Create New...

Important Information

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