kcid

I am constantly blown away by your solutions. Just when I think I am getting pretty good at this, I run into someone with skills I can't even fathom. I have seen "Ceiling" and "Position" functions, but would never have thought to use them together like that. Wow, simply, WOW!

That is really my big problem. She isn't consistent. Sometimes where I would like to see 9/17/2010, she will write September 9, 2010, or Sept. 17, 2010. The message says enter the date as x/xx/xxxx, but for whatever reason, she just doesn't remember. sound of head banging wall> I just need to have it return the correct format, no matter what she does. Or should I just give up. (I am going to miss my girlfriend) I am checking Match.com as we speak.

I have a person working for me that no matter how many times I tell her she must enter a date as "x/x/xxx", she insists on typing out the month name, "Jan or January". Since this date is inserted as part of a script, I would like a way to filter what ever she types, to match what everyone else types. It seems simple, but I just can't find it. I spent yesterday looking and experimenting, but no go. Just point me, and I will try and find my way. Note: I have used the drop down calendar, but she would rather type. I can't fire her (my girlfriend's sister), but I am at the point I am considering looking for a new girlfriend.

Thank you. I was able to make it work for me once I understood the self relationship method. Once again you got me out of a hole. Sometimes I find myself going down the rabbit hole and not knowing the way out. Rather than a validation, I used conditional formating that turns the text [color:red]BOLD and [color:red]RED when [NOT IsEmpty( EQ2:_ID)]. Then they can go back and fix the conflict from the other end if they want. Thanks once again.

I hope I am posting this in the correct part of the forum. I am trying to do some resource management. I have multiple pieces of equipment which are loaned out for various periods of time. People often reserve months in advance. There may be 10 advance reservations for one particular piece of equipment, and I need to identify if a new requested period is in conflict with an existing reservation for that piece of equipment. I am not asking someone to do this for me, because if I don't do it, I won't learn it. But I would appreciate some guidance or aiming me in the right direction.

WOW ! That is really cool. I am constantly amazed by the knowledgeable people on this forum. It works great. Thank you.

I would like to build a script that allows the user to insert a picture into a container field. I think I want to use the [color:blue]Insert Picture script so I can be sure they only install a link to the image. But here is where I have an issue. I would also like to direct the user to a specific folder defined by the script, containing specific types of images suitable for the container field. The [color:blue]Set Path part of the script does not allow me to set a particular folder where the user can pick the correct image, only a specific image. I know I can leave the [color:blue]Set Path part blank and let the user navigate to it, and there is no way to stop them from navigating away from it, but I would at least like to start them off in the correct folder. How do I set the path (relative because the folder with the images resides with the FMP doc), not a specific image, but just the directory. Thanks for the help in advance.

Hi, Thanks. I made a couple of changes to the DB itself, and adapted your suggestion. Thanks, again. All is good.

No matter how hard I try, I leave out one important detail. I just need an indicator in the parent table record that confirms a certain condition exists in any of the related records of the child table. If the conditions are not true in any of the related records , then the indicator is empty If the condition is true in any of the related child records, the user can decide to investigate further, by viewing the related child records. I hope I did better this time in explaining my need.

I know this is probably simple, but I just can’t get my head around it. I have a table (A) which is related to another table (. A single record in (A) may be related to many records in (: Table B has 2 field, (B::Status and B:Type) B::Status’ will contain either “Active” or “Complete”. And B:Type will contain either “Old” or “New” I need a calculated text field in table “A” return “Yes” if [color:purple]any of the multiple related records in “B” have [color:purple]both “Status=Active” and “Type = New” I hope that makes sense.

When purchasing equipment, they will order: 4 Widgets 135.00 540.00 total But need to track them individually in the file in question (serial number, location, service history, etc.). Since the purchase volume is somewhat high, it is not practical (or desirable) to duplicate the needed records by hand. If they had the money it would be great to integrate the two systems, but that will never happen. This department is simply trying to get a handle on their inventory which is scattered far and wide. So when purchasing/receiving sends them a file (usually excel) saying they are getting X number of these, they need to create a record for each, individual item. I have found a way to do this, but it seems far to convoluted, and I am sure some of the great people on this forum have a simple, elegant answer.

I need to duplicate a record a number of times based upon a value in the record (Quantity). There may be 12 records imported, three of which may have a quantity greater than 1. I need to make duplicates of the records with a quantity greater than 1 so I end up with enough copies to equal the original quantity. I hope that makes sense.

Thank you very much. I was on the right path, but close doesn't quite work.

I need a formula that combines two 'Text Format Functions' in one simple formula. Here is a simplified example. (One Table) Three fields: Priority(text), Title Entry(text), Title Result(calculated) So what I need is: The title to turn Red & Bold when the priority is 'HOT'. A formula or custom function that will turn the text in a field both Red and Bold at the same time, if certain conditions are true in another field. I have not been able to figure it out. Seems pretty simple, so I am ready to feel foolish.