lrcarey

Hello all, I'm trying to figure out how I can get a calculating field to look at the rows in a portal and compare them to find the highest value in a given field. Then the calculating field should display that highest value. To further complicate it, I only want to include certain rows - the rows to look at are marked with a "1" and the rows to ignore are marked with a "0". (The problem I am trying to solve involves looking at which activity completed by a given person within specific dates involved the most number of hours - if that helps!) - I'm stumped! Thanks in advance, Leah

BD - Thanks for the help. Unfortunately I don't really follow. Would you mind taking a moment to walk me through it? I'd appreciate it! All my best, Leah

Hi all, I'm not sure if this is the right thread in which to post this...my apologies if it's not. I'd like to set up a field that counts ONLY the records in a found set from a related file. The user will enter a date (the "end date") and FMP generates the beginning date (364 days earlier) and through a script goes over to the other file and finds the records within that date span. But the main file still seems to count ALL of the records in the related file, not just the found set. HELP!?! Thanks in advance, Leah

Is there a quick and easy way to create a grid? Whenever I try the "make-the-box-and-place-the-lines-in-it" game, I can't seem to get all the rows the same height. Thanks! Leah

Excellent! Thanks, Leah

I don't know how widespread your needs are. I only needed zip codes for three states (small ones at that!) so I found listings by county on the web and brought them into an excel spreadsheet and then imported them into the database. It was a bit time intensive, but it worked just fine - the only snag was when I copied the tables of zip codes (off the source of the web page on which they appeared), they showed up without the leading zero in the Excel spreadsheet. So then I wrote a little formula to add the leading zero back in. I'm sure there was an easier way to do it, but that's what I came up with. Also (I forgot to tell you this before) in the main data entry document, I made a field that pulled just the first five digits of a zip code (left(zip code, 5)) so if someone entered a nine digit zip code the relationship was only keying off the first five digits. Good luck! Leah

Hi, I'm not one of the experts, but here's what I did: Create a separate file that has just city, state, zip code (and I also have county). Then create a relationship in your main file that matches the zip code entered during data entry to the zip code file. The city and state can be calculated through that relationship. The main drawback I found was that in my area, several towns are covered by the same zip code. In order to give the user the option to choose a town, I made the "town" field a drop down list that is brought in through the relationship you've created. Hope that helps! Leah

Hi, I have a value list in a checkbox field. I'm trying to create a calculation that says "if value A is checked, put A here, otherwise leave blank". However, because I'm saying "Field="A"", the value will ONLY show up if it is the ONLY one checked. If multiple values are checked, none of them will show up in their respective calculations. How can I rewrite the calculation so it will pull value A regardless of how many boxes are checked? Thanks in advance...again, Leah

Thanks, it worked perfectly! Leah

I'd like to script a find to catch all records with event dates from two months back (say 60 days) through today and all future dates. I can't figure out how to set up that kind of date range. Thanks in advance, Leah

Hi, I have set up a report layout to find duplicates with just the essential info on it. About five or six records fit on the screen at once. Users can delete records directly from this screen, but I'm nervous that users might not always be aware of where the little black bar is on the left side of the screen which indicates which record is active, and therefore might delete the wrong record. Is there a way to make the background of the current/active record turn a different color or do something else eye-catching so the users are absolutely certain which record they're deleting? Thanks in advance, Leah

Hello all, When users create a new record they are asked to assign the record to one or more categories using checkboxes. There is an "Other..." option so they can assign their own categories if necessary. I have a tally sheet set up in a related file that counts the number of times each category was selected. Now the users want to be able to also see a list of the values entered into "Other..." and have a count of each value in that list. Is this possible? I'm stumped. Thanks (yet again!) for your help, Leah

Thank you! Leah

CobaltSky, Thank you for your suggestion. I just tried to implement it and I have two questions: 1. Is there a way to get the script to ask for a password? I just created a separate field called "SSN password" and set the script up to check the entry in that field to see if it matches the script and then set the field back to " " if it matches and gives clearance, but it seems like there should be a more elegant way to do this. 2. When I click in any other field on the page, my bullets disappear and the SSN is visible again. If I click out of a field, the bullets come back. Is there something in the field format that I haven't set up correctly? The mask is opaque white with no entry allowed. Thank you again, Leah

Hello all, Is it possible to have a calculation field that is looking up values from a related file that would either: a) display a value if there is only ONE related value, or drop down a list of ALL the related values? I have a zip code file that has zip codes, towns, and states. When the user types in a zip code in the main file, it automatically pulls in the related town and state. However, our area is small enough that there are several places where multiple towns are covered by one zip code. As I currently have it set up, typing in a zip code will pull in only the first related value, but it might not necessarily be the correct one. Any suggestions? Thanks in advance, Leah