habitude

Hey all... Just a comment, maybe a lady canine and whine... Ver. 7 was released in 2004 Ver. 8 in 2005 Ver. 8.5 in 2006 Ver. 9 in 2008 Ver. 10 in 2009 Ver. 11 in 2010 Working for a small company where I am the only one who knows what Filemaker is, keeping up to date with each version is almost impossible. How does one justify an expenditure like this? lol, having the ability to create a chart from my data hardly seems a good reason to spend another few hundred for V11

Hey, sorry it took this long to reply... I like your suggestion but having a bit of trouble making it work. Could you possibly elaborate a little more please?

Need help with a design problem.. 3 Tables: Accounts, Contacts, Work Orders Accounts contains names of Companies, addresses, etc. A "company type" field has choices (Real Estate, Escrow, Construction, Church, or Other.) via Value List. Contacts contains people and contact info. A "contact type" field has choices (Realtor, Escrow Officer, Manager, etc) via Value List. Accounts & Contacts are linked by "AccountID" Work Orders table is my problem... I need to show this information: 1. A Company & Contact (in this example a Real Estate company & Realtor with their Contact Info) 2. An Escrow Company (and Escrow Officer, Info, etc). Is it possible to show both types of info on the Work Orders layout with this design or does each company type or contact type need to be in their separate tables and then somehow pulled in? Is there another method not shown here? Whichever way works, can someone show me how to set it up? Please and thank you.

Howdy... Long time since I was here last, but hoping that one of the wizards here can help me nail this down. Anyway, writing a solution that creates a simple work order and it includes the usual entities like Contacts (or customer), Service (instead of product), Invoice, etc. The majority of the contacts come from a variety of Real Estate offices, they call and request an inspection service on a home they are negotiating. Many times they will ask us to invoice an Escrow company, which brings me to the scenario... Currently, to create a Work Order means locating that Contact (if they exist, is not creating a record for them first), and clicking the "Create Work Order) button. Doing this creates a new record in Work Orders and pulls in the Contact info via lookups. (BTW, once in a while, that process will fail and only pull in the ID of the contact). I want to create a selection portal that upon clicking a button like "Add Escrow?" will display a pop up window with a portal displaying available Escrow Companies/Escrow Officers on file. All the user needs to do is click on the invisible button in that row in the portal and it adds the info. If it's a new Escrow Company and/or Escrow Officer, have the ability to create that record as well. Questions: Can this be done? Can it be done with the Work Order Requestor (Contact) also? Is my thought process in the wrong direction? Would appreciate any constructive ideas, thanks

Howdy. Is it possible to programmically scrape (or extract) road directions from the web viewer into a usable text format? A scenario: Work Order is generated with customers name & address, work order #, job instructions, etc... and somewhere on the page it has directions to the job in a format like: [Directions: From HQ, Drive South 2.5 Miles on First Avenue, Turn Left at First Signal, Proceed .5 Miles to Job at 2345 West Main Street] Something like that. I figure if the web viewer can display a visual map on the screen, maybe there is a way to tap into the code that produces the road map, yeah? Thanks in advance.

I seem to have a problem with FM9 Adv... I get excessive flickering or flashing, screen refreshes usually working in layout mode. My PC is an AMD Sempron 3300+ running XP Pro and this problem does not happen any other time, except in FileMaker. The constant screen refreshes are incredibly annoying and hinders any productivity. Typically, I will get four or five so-called "refreshes" in a row for no reason, and at least one "refresh" just about every time I select a field or other element on a layout. Does anyone have a clue on how to resolve this?

I'm experiencing something odd with V8.5 & V9, where the entire window does this sort of shifting or flashing or skewing several times before it finally stops. This happens usually in layout mode, although it has happened in browse mode a few times. The screen/window always snaps back into place, but I can't figure out why it does this. Never had this issue in V7, and I have downloaded any/all updates from FM. Anyone else had this happen?

I'm trying to calculate players ages determined by a set date. For example, I need to find out how old a player will be by April 30, 2008 when the players birthdate is entered. Can someone please help me with this? Thanks Using 8.5 Adv on WinXP

Is it possible to search a hard drive for files (ex: *.mp3, music files), and create a record containing the file name, database path, etc, for each file found?

I want to find out why it takes a certain script to finish. Is there a way to calculated the elapsed time from start to finish? USING FILEMAKER 6 Thanks in advance

Fenton, thanks for responding so quickly. I was thinking the same thing. That should do the trick

In the Define Fields Options Auto Enter - Serial Number Dialog Box, you can assign a number, such as 1. Let's say you have an "x" amount of records, and you want to delete all, and reimport a new set of records. Is there a way to programically reset that field option back to 1, so the newly imported records start with a value of 1? I know its unorthodox way of doing things, however, it needs to be done somehow. Can anyone help? Thanks in advance, Habitude

Comment, I wanted to say thanks to you too for helping me with this issue. I learned alot from it. I have another question, which probably should be posted in the Scriptmaker forum, but here goes anyway... Is is possible to write a script that would automatically make all the changes with a click of a button, or do I have to repeat the same process with each calculation field when this type of task comes up in the future?

I agree 100%, and I did make the suggestion to my bosses that making the date proper and in its own field (at least for indexing purposes) was a better way to go... I was told to just do what I was told! LOL

Works Beautifully, thank you LaRetta!!!!

I'm sorry, I didn't mean to confuse you with the red. This is the desired outcome: > Change this < --- Wednesday February 23, 2000 17:11:43 By: CW P/M T/Y "CLOSING" LETTER TO CLIENT ; CERTIFIED AND REGULAR MAIL. > To this < 02/23/00 By: CW P/M T/Y "CLOSING" LETTER TO CLIENT ; CERTIFIED AND REGULAR MAIL. The latter is a complete paragraph in a single field. (for what it's worth, this data was pulled from an old FoxPro app that became whacked when the year 2000 rolled over, thus changing the way the date was auto-entered into a record, this is a part of the normalization process task at hand)

Wow, thanks LaRetta, your example worked great! Only thing is the new date has to preceed the rest of the text (01/01/01 By: ). Each of these represents a line item of a master record.

Hi LaRetta... Yes, working in FM6.

Thanks Vaughn. The trim function worked fine. My question about the CASE statement - Converting the day name, day, month & year require a separate CASE statement? Or is there a way to to say "[color:red]if this date is Tuesday April 2, 2002 13:46:02" - "[color:blue]change it to 04/02/02" and omit the day name & time? Also, is this a calculation through a new field, or a script?

[color:blue]I have some records that are in the following format: --- Wednesday February 23, 2000 17:11:43 By: CW P/M T/Y "CLOSING" LETTER TO CLIENT ; CERTIFIED AND REGULAR MAIL. [color:blue]They need to be changed, so they appear in this format: 02/23/00 By: CW P/M T/Y "CLOSING" LETTER TO CLIENT ; CERTIFIED AND REGULAR MAIL. The goal is to remove the 3 dashes, the weekday, and the h/m/s, and only show the date in 01/01/01 format. I'm working in FM6. Anyone have any tips? Thanks in advance.

I'm very thankful for the help. I managed to fit all the pieces together (similar, but different from the example) and the script processed all the records the first time (over 40,000) in details! :-)

Here ya go. I hope this works And by the way, thank you kindly! Comments_Copy.zip

"You could just write a simple loop to parse it into separate records" How do I write this? If this could be done, and all the data moves over correctly, that would be very righteous.

I created the followiing calc field to show each "paragraph" as a single item: Middle( c_Comments_Add_Pipe, Position( c_Comments_Add_Pipe, "¶", 1 , (g_loop_counter-1) )+1, Position( c_Comments_Add_Pipe, "¶", 1 , (g_loop_counter) ) - Position( c_Comments_Add_Pipe, "¶", 1 , (g_loop_counter-1) )-1 ) Now the task is to copy each one of these into the details file, as new record of the "client ID" record (like a line item). I'm assuming a script that processes each paragraph as a new line item in details is what I need, but I'm not sure how to do it. Also, when the routine gets to the last paragraph within that record in the main file, the script needs to start the next client id record and strip out the text and add it as a new record of the new client id in the details file. Does this make any sense? :-!

In another text field, using that substitute function I mentioned earlier, I was able to get that data to appear as a separate record (starting with a date, etc), and I also added a carriage return char so the data looks more normalized. The final result of this should show the following: (client_id) (comments) DOS100022 01/02/96 Bla Bla Bla This is some text DOS100022 02/15/96 This is some more notes for this client DOS100022 03/30/96 Some other notes -- DOS100043 06/05/96 Notes on this other client and so forth... All this needs to go from a comments file, into a comments details file. What am I missing? :-(