# HonkyCat

Members

35

0 Neutral

• Rank
member
1. ## Date Calculation

Thank you "Comment"! That worked perfect!! Kristine
2. ## Date Calculation

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. ## Date Calculation

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. ## How Many Tables Do I Need?

Thanks for your help Jerry! Kristine
5. ## How Many Tables Do I Need?

Thanks for your help Jerry! Kristine
6. ## How Many Tables Do I Need?

Thanks for your help Jerry! Kristine
7. ## How Many Tables Do I Need?

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. ## How Many Tables Do I Need?

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. ## How Many Tables Do I Need?

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. ## AppleScript a SECURE PDF & Email It

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. ## Self-Join/Multi Table Occ. for One Table/Portals

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. ## Self-Join/Multi Table Occ. for One Table/Portals

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