pubdss

Thanks you, it worked, now to go back in and change 14 searches!

Hi there, This may be really simple, but I cannot figure the proper way to write this search criteria in a script. I need to search within a field for all days between 2 weeks before today and all dates after. Hope someone can help, thanks in advance.

Thank you and Ugo as well. I think I might owe you both my soul now!! Haha, both worked perfectly, i ended up sticking with the Choose (Sign) method to keep things simpler. Thanks again!

I have been trying to figure out how to extract negative values (or values with a "-" in it) from a repeating text field. i found this script on the FileMaker TechInfo site, which was able to create a text box and input all the values on separate lines - I am not sure if I can use/alter this script for what I need to do. Basically this repeating text box has positive and negative numbers and I want to create a report that only reflects the negative numbers, and a sum of those numbers at that. I cannot figure out how to modify this script from the link above, for what I need, or if there is a better way to do it. Is there, maybe, a quick calculation for this field that would be better? Any help, would be much appreciated!!! Thanks!!!

Woohoo, Choose(TextToNum(Selected Print Estimate), "", Estimate 1, Estimate 2, Estimate 3) worked. I want to thank all of you for your help. I learned more about case solutions and choose solutions. Greg

Hi Lee, It's still being stubborn. Its strange, because it automatically enters in data from the second result and not the others. If I delete the Selected Print Estimate, it reverts to "0" as expected. But Only the Estimate 1 (which is the 2nd test/result) show up. Case(Selected Print Estimate = "", 0, "Estimate 1", Estimate 1, "Estimate 2", Estimate 2, "Estimate 3", Estimate 3) I've attached my file if it helps. Its for school project I'm working on. Greg EstimatingDB.fp5.zip

Pete, Thanks for the quick response. When I try that formula, it doesn't fill in the Estimate Cost with the figure from the selected estimate. I deleted the "" at the end. Greg

Ok, Everyone has already helped me in the past with a Logical function but this one is more in-depth. I've been looking on the forum for a similar example but out of luck. Hopefully someone will be kind enough to spread their FMP knowledge on me again. I'm having a hard time grasping the formulas. I got a simple If() statement going, but thats about it. I need to search for some resources. Here's what I have: Estimate 1: $$$$$ Estimate 2: $$$$$$ Estimate 3: $$$$$$$ Selected Estimate: Pop up value list window with "estimate 1", "estimate 2", "estimate 3" Estimate Cost: Trying to pull data from estimates field corresponding to selected estimate. To give you a better idea of what I thought it would be (i.e. how I don't understand it) I tried this for a calculation formula: Case(Selected Print Estimate = Estimate 1, Estimate 1, Selected Print Estimate = Estimate 2, Estimate 2, Selected Print Estimate = Estimate 3, Estimate 3, "") Thanks in advance. Greg

Thanks everyone for your contributions. I ended up taking mkd256's advice. It works like a charm. Greg

Hi all, This shouldn't be a tough one for you but I've been going nutz over it. I have my visual quickstart book and I've been browsing the forum but I'm still kinda confused. Basically, I have billing address info and shipping address info. I have a field that says "shipping same as billing". What I'd like to have happen is that if someone clicks the option for "yes", the billing field data automatically echoes in the shipping address fields. Otherwise, the user enters it manually. I can't figure out if and case statements. I'm confused what data goes into what section of the calculation. From what I've read, it seams like the case function is more powerful. I'm open to either, as long as I can understand it and get it to work. Thanks. Greg

Hi Lee, The reason I was looking at a FMP solution was because of its multi-user ability. The plan was to create the search database and serve it on our FMP Server. This would allow access to the whole department. I took a look at Disk Tracker and I think its geared more towards a single user. That application also grabs all the contents of a volume, not just the highest directory. Grabbing all of the content may be create too much info per search. I'm familiar with importing data from formats such as text. I'd probably copy and paste it out of fmp and throw it in something like excel or just another text document to import. Hope this helps. Greg

Hi Lee, Thanks for your response. I've got a screen capture of my fmp document. The CD Contents are files and directories copied and pasted from a CD. I hope this helps. If I were to break up the information, could I still do a search (within the Find viewing mode) that scans multiple locations? Greg

Hi Everyone, FMP newbie here. Running version 5.5 on Mac OS 9. I've created a database to keep track of whats on my archvice CD. Each record contains 4 fields: Archive #, Date burned, CD location, and CD Contents. The CD contents are copied from the finder and pasted into the text field for CD Contents. This makes each folder name on its own individual line. Some of my archive CDs contain over > 180 files. The list is very long. I have to turn on scroll bars however its still rather cumbersome. Is there a way I can create another text field box and have the contents flow from one to the next? Almost like a 2x column look instead of one long hard to manage text field box. My next question is: when I do a find under the CD Contents text field for a particular folder, the search works and yields the archives that contain the searched item. Is is possible to make it so that only the item used by the search engine is displayed in the contents box? Currently the search pinpoints the correct archive CDs but I then must manually scroll through the file listing to determine if it is the appropriate item I searched for. Does that make sense? Thanks for you help.

Thank you for the quick response. I tried following your steps but I got a little confused. I tried setting things up slightly differently. Instead of relying on 1 field to fill in data for 5 fields, I've broken it down. If I use three fields to enter data, it should make it easier. I have set it up so that "Quantity Selected" = "Quantity", "Printer selected" = "Printer Selected" & "Printer Name". I achieved this using calculation as an option. The only field I have left is "Option Selected" and how I will get the cost flowed in below. We normally enter a grid number such as A1 or B1 in "Option Selected" however in the actual fields we enter dollar amounts. Can I make it so I can enter an grid number in one field (Option Selected) and it will fill in the dollar amount in the "Printing Cost" field? I think what throws me off is that the data I want resourced from "Option Selected" can be from several different fields. There is not just one point of reference. Any ideas? Thanks again for your help.

I am only experienced with the basic functions of FMP so please bear with me. (my disclaimer before I start my questioning) I want to make filling in fields less repetative using relationships. I have a database with estimates for our clients. In the 2nd section we list printing bids. It is organized like a chart with buyers going vertically and quantity going horizontally and final choices are refered to as A2 or B1. Click HEREto see a screenshot.The quantities are referred to as "option A", "option B",etc. Right now, I have to manually enter the data in below with. The only automation is when I enter the printer code under the "printing bids" section, the printer code and printer name are entered automatically in the next section. I don't know if its possible to automate this process because the field is not specific. Can the sections below accept data from diverse relationships? My desired configuration is HERE. I want "option selected" to provide data for the fields below it. Is this possible? I hope the pictures help. Its difficult to put into words with just an email. Thanks in advance

Moon, Thank you very much for the very clear and concise how to. It worked like a charm. Suppose you had a database with different 10 records. Is it possible to export several records but not all? There are three fields that we need. Name, Job Number, and Billing amount. We usually search the records by Job Number. Is there a way I can add multiple records to an export. The workaround is to export each to a different file and then copy and paste text when its all done. Thanks again for the help. - Greg

Hi, I'm fairly new to FMP so please bear with me. We have a database that has a large amount of records linked to it. We would like to be able to export info from specific records to text. When I try exporting it now, it exports the field information for all the records. Can I have it do the fields of my choice and do only 1 record? Also, is it possible to export the field name as well as the data within the field? Thanks in advance. - Greg

Hi, All the software is up to date: ATM Deluxe 4.61 & FMP 5.5. The font also works fine in the other programs. I somehow managed to get it to work. I've been playing and tweaking just about every font related file on my computer. I decided to test it by opening my file w/out the font activated. The font was substituted as expected. I then closed the file, activated the font, and opened the file up. The font was not correctly replaced and it actually substituted a different font. I ended up spending a whole day and manually changing the typeface throughout the database. Is it bad to use PS fonts in FMP? I found the person before me mixed in Postcript with TT fonts that had styles applied to them [ e.g. bold, itatic, . . etc]. I made sure everything was conformed and used only the PS fonts. Sofar its working fine on all the computers.

Vaughan, Thanks for the response. The fonts are type 1 postscript. I have tried using ones of the Font Folio 7 and Font Folio 8 CD as well as from a working station. I played around with it last night for several hours and at one point it was functioning correctly. I've been playing around with ATM and any font related files on the mac. This morning, I tested it by opening the file w/out the fonts active and then reopening it with the font active. This time it did not revert back to the correct version. It reverted it to a different style of minion. Very strange.

I am in charge of about 10 computers ranging from 7100s to G4s. All have an OS of atleast 9.0. Recently some of the computers have been reformatted with 9.1. We also use Adobe Type Manager Deluxe. The main database is on a remote server and each workstation connects to it. (We're in the process of finishing up a FMP Server). The file is displayed properly on the older macs however the fonts included do not register when on a mac with the new 9.1 OS. It defaults to Helvetica. The database is extremely large and complicated. To reformat it would takes weeks. The fonts register in all other programs and work fine. Its just FMP 5.5 which is causing a problem. The files were converted from version 4 on a machine that displays it properly. The fonts even show up and work correctly under the "Fonts" menu but when my files are opened, the font does not register. I called FM and the technician was very little help. He told me my OS was the problem. I have seen another person with the same problem in this forum. He was never responded to (Similar Problem). Please help. Gregory Firestone