# 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",Dat
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 t
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 t
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 t
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
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
13. ## Self-Join/Multi Table Occ. for One Table/Portals

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 "Re
14. ## AppleScripting a SECURE PDF

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. ## problem with To: field using send mail script step

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...