
Our Town
Members-
Posts
24 -
Joined
-
Last visited
Everything posted by Our Town
-
Fenton, You are wonderful!! It works exactly like I want it to work. You helped me save hours of work!!! I wish I understood everything you did in that Applescript! But I know it works. Thanks again. Bev at Our Town
-
I have a folder full of email files. I have an applescript that changes all the extensions to .txt so I can import them into my FMP file. I have two fields in my FMP file, the filename and the email text. Everything works perfectly except the carriage returns that are in the email text seem to evaporate, making all the text run together. I had done this same thing using email files from Entourage and all the carriage returns came over in the import. I am now trying to do the samething with email files from Mail and though I can see that they are there in the email files, they are not there when imported. Any ideas? I am frustrated that it worked before with the other email system but doesn't work with this one.
-
If we saved a clone copy of the database (off the server/on our desktop), exported ALL the data when we wanted to "Save a Copy as", then performed an external script in the cloned copy on our desktop to import the exported data??? Then we'd have the clone filled with the current data and basically have "saved a copy of the file." Of course, each time we'd have to rename the backup file and reset the clone for the next "save a copy." Just thinking of a way to do this... :P
-
Date Calculations Killing me!
Our Town replied to Our Town's topic in Calculation Engine (Define Fields)
What a miracle! After two days of trying to figure out how to do this, the solution was easy. Not sure if I understand WHY it works but it does work. I added two If statements. One to check if the EndDate was before the StartDate...there would be no need to calculate days after StartDate... and one to check if the StartDate was blank. Which can happen if the account is not active. StartDate (date) EndDate (date) Define a calculation field (WorkDays) with a number result with this formula: If(StartDate="";""; If(EndDate Int((EndDate - StartDate)/7) * 5 + If(DayofWeek(EndDate) < DayofWeek(StartDate), Min(5, DayofWeek(EndDate) - 1) + Max(0, 6-DayofWeek(StartDate)), If(DayofWeek(StartDate) < 7, Min(6,DayofWeek(EndDate)) - DayofWeek(StartDate), 0)) )) It works perfectly. Wish I had posted this two days ago! Bev -
Date Calculations Killing me!
Our Town replied to Our Town's topic in Calculation Engine (Define Fields)
Thank you very much! I hope I can figure it out! -) Bev -
I have deadlines for filing contracts. Every month deadline changes, so it isn't always on the 15th of the month or on the second Wednesday of the month. When a contract comes in and the date is entered, I need to know if it is past the current deadline and how many days past the deadline. Have deadlines in a separate Table. Contract dates are basic date fields. The catch comes when my boss tells me not to charge for days on the weekend! Obviously the deadlines occur on different days of the week, as do the contract dates. Nothing I have tried works. Any ideas would be greatly appreciated! I am ready to cry! Bev
-
Are you sure both fields are NUMBERS?
-
This may not be the best way to do this but it has worked for me in the past. Create a field that is X's if salesperson does not equal currentuser. CheckUser (Calcualtion, text) If(Salesperson<>Currentuser;"X";"") That way you can do the find and X that field and set that other date field to check the logon date. Your find will check both. I hope this makes sense.
-
I wish I could give you the answer as I posted this question some time ago without any luck... I will hope for the same... I know I tried in my querey running the proper conversion but still nothing. Not even in filemaker 8.
-
I am still at a loss on this. Does anyone have any idea how one could accomplish this? Thanks
-
Hi, I did a search and came up empty. I have a file I am updating the reference links (well attempting to) so it displays a pdf. I can get this to work locally. But the server it is on is on my desktop. I have this FMP db hosted with FMP7 server currently. I have messed with the paths and I cannot get anyone else to see the pdf's? I copied the exact path, so I thought as they would log into it? No luck. Here is my path. The pdf's are located in samples. It is on the server that is running filemaker server... Ughhh! filewin://192.168.0.202/Library/WebServer.server-applesaved/Documents/samples/ Thanks for any help.
-
Mystery Error message when attempting to delete a record.
Our Town replied to Our Town's topic in Relationships
Yes, deletions are allowed. But never fear, I figured it out this morning. I had several records that had duplicate sponsor ids. (Yes, I know how to prevent this but I am attempting to merge several databases obtained from several different sources, deleting the duplicate records, so the situation is messier than it would normally be.) Anyway, I sat looking at the record I wanted to delete and wondered whether it would let me delete it if I changed the sponsor id so it was different from the other record. I changed the sponsor id and it allowed me to delete it. I have relationships set up with other files and I think when a delete is attempted on a record that is connected with the other databases using the same Key field, it will not allow you to delete because it doesn't know which one is the correct one to delete. If it deletes connected items in other databases and it is the wrong connection, the wrong items can be deleted. So it just refuses. That's the only thing I can think of... It was certainly very strange! I hope this helps someone else who might run ito this in the future!! :hello: -
Mystery Error message when attempting to delete a record.
Our Town replied to Our Town's topic in Relationships
39 previews of my question and not one comment... Is my question stupid? Has no one else ever had the problem? Please throw me a little crumb to help me figure out what in the world I did wrong! -
Mystery Error message when attempting to delete a record. This operation cannot be performed because one or more required related tables are missing. I have a layout/table that has only 6 fields. Customer number Zip code Monthly Average Sold which is a look up from another table in another file entered when a zip code is entered Rate which is calculated based on various selections in another table in the same file for each customer Monthly Cost which is product of Monthly Average Sold and the Rate and the calculation is defined in the table Customer Name which is a lookup from another table in another file based on the customer number Five of the six are defined in that table, text fields, lookups or calculations. Upon going to the layout, the records for the particular customer are found, if any exist. There is a button that creates a new record, copies the customer number into the new record which looks up the rate and customer name. The user can then enter a zip code causing the lookup of the Monthly Average Sold, which then results in the calculation of the Monthly Cost. A user can use buttons to add zip codes or delete them. Now this part of my tables/layouts was created early in the development of my software and worked just fine for a month. I continued my development and when I was nearing completion I started a final run through, checking everything and discovered to my surprise that while I can create a new record, enter a zip code and obtain the results of the monthly cost calculation, when I try to delete a record, I get the lovely message above. I have carefully checked all the relationships and everything looks okay. Nothing is indicating a “missing table.” I have no idea what to check next. Any suggestions? Bev at Our Town
-
BEFORE POSTING PLEASE READ!!!
Our Town replied to Ocean West's topic in Community Videos, Tips, & Techniques, Articles.
I posted a question. After I posted it I read your "Do not post questions!" Can you delete it for me? -
In a sample software I once reviewed, the programmer had done a little trick so that a user could click on Return/Enter rather than the Okay showing in a Custom Dialogue checkbox and the dialogue box disappeared. At the time I thought it was cute but was looking for another solution and didn't register how to do it. Can't find it now. Anyone know the trick?? I know it can be done because I used it. Sorry, posted this is wrong place!
-
Hi, in query builder upon import can't I adjust the query to pull the data in as mm-dd-yyyy verse the mysql format yyyy-mm-dd? I current have a script that changes it after the fact but thought it silly and trying to do it right as I learn more. Thanks
-
Maybe this is being posted in the wrong place but in the past I was using HourBoss for my employees to punch in and out. It had some issues but was over all preety good. Now, I have modified it to a networked version after having issues, and it really didn't improve anything. Does anyone know of anything out there that I could use for employees just as an old fashioned time clock in osx? At this stage I could do one from scratch if need be but my time is/ has become extremlely limited... Any help or ideas are appreciated. thank all...
-
- 1
-
-
I seem to have a constant problem where my sales people are trying to do a apple f for find and hit the d for duplicate. I am constantly removing the dups with a script I found here. They have to add records for notes and such, but can I disable the duplicate function? Thanks
-
Hi, I have a large list of supplies. I am trying to create a simplified menu that branches out by catagory type, then specific items . I have seen this somewhere. I know on websites... Can this be done in FMP?? Thanks for any help you can offer.
-
This may be simple, maybe i am to burned out this evening... How do I finish the following senario... I have a list of data, summarized by a group of owners. Each new owner is on a separate page. Currently I have it doing a search for the known owners. Printing as a pdf and saving with a static name for each. I am bringing on many more and it would be eaiser if I could print each new page as a pdf with the name save as (whomever).pdf in a folder. Any help is appreciated. Thanks
-
Timed automatic import/ update script?
Our Town replied to Our Town's topic in Script Workspace and Script Triggers
is events 4.0 any good? Its by waves in motion and looks like it would do this and more? -
Timed automatic import/ update script?
Our Town replied to Our Town's topic in Script Workspace and Script Triggers
thank for your help. I will look into these and see... Really I think the applescript would work fine. That is certianly not a strongpoint yet for me though. Still learning UNIX first. Would it be tough to do? Any help is appreciated. -
Hi, I have a massive relational database that needs to be updated daily. Problem is it takes about 45 min, even through ODBC. I was looking to see if there is some script I can run or schedual to where it can run at like 3 am or something so it is not such a pain for me. There has to something I figure, just haven't found it yet.