Sabrina

I need a web based electronic claims filing service's program to interface with a FMP5 Server application. The other company says I need to create a TCP/IP socket and send HL7 messages. I'm getting the HL7 down, but I'm not sure where to start with connecting with them over a TCP/IP socket. I don't see anything IN FMP that allows me to create a socket so is there a Plug-in that is eluding my search? Help, please! Sabrina

I'm downloading the program but I'm not sure it's an option right now. I can't afford to buy it on my own and I'm not sure this client is going to allow an extra expendature on her bill. If I like it I'll submit it as a proposal since the data-dump is an add on to the originl program. Either way, do you know of any other options? All I need is to send one field that is a calculation field with all the data compiled that she needs to do her report to Word. Thanks! I'm interested to see what this program will do!

I am trying to automate a data dump into Word. My client wants to be able to take some of the results, press a button and have it "magically appear" in Word so she can fine tune the information into a report. My problem is I can't get AppleScript to allow the copy from FM to Word. I get an error message along the lines of "Word does not have access to that data." I have never used AppleScript before so I do not know the rules of data sharing in this program. Can someone point me to a resource that explains this or tell me the theory behind what I want to do? I started with this script in FMP: tell application "Microsoft Word" activate make new document at the beginning of documents set the name of window 1 to "New Filemaker Report" end tell Now I want FMP to either insert the data or Word to fetch it. Now that I'm explaining my problem, is there a way to copy the data to the clipboard then paste the clipboard into Word? What would that command be? Thanks all!

I'm not finding the exact answer to my question in the posts I've read so please forgive me if I'm repeating a question. I need to create a record in another table from a current table behind the scenes (the user doesn't see and get confused. ) I want the computer to create it because there needs to be a relationship inherently made. (not relying on the user) In 6, I put a script in table 2 named "New Table 2 Record" consisting of the command "New Record/Request". In table 1 I put a script "Create New Table 2 Record". In "Create New Table 2 Record", I would set "g_Table 1 ID" with "Table 1 ID", call "Table 2: New Table 2 Record" Then set "Table 2: Table 1 ID" with "Table 1: g_Table 1 ID" Here's the problem in 7: When I call the "New Recod/Request" command in Table 2, it creates a new record in Table 1. I can understand why it's doing this, but I don't know how to work around it. What do I need to do so that I'm creating a new record in Table 2 and setting the field properly in FMP7? Thanks All! Sabrina

To accomplish this in FMP 6, I created a calculation in each database with the value 1. (User can't edit without much effort and all records match.) Table 1: global_join = 1 Table 2: global_join = 1 I then set up a relationship between the tables using the "global_join"s and used that relationship for the portal. In FMP 7 this relationship set up isn't working. In 7 I have an instance of "Customers" called Global Join connected to an instance of "Party" using the "global_join"s in each table. The part that is confusing me is the portal shows one record but that record isn't the first record like one would expect. It only shows the SECOND record. I've checked to make sure the relationship is going to the correct instance and I've made sure that all records have the "global_join" correct. I can't find anything wrong. Here's the bottom line: I want to see all of the Customers' names through a portal in the Party table. I then have a button and script set up to add the customer to the Party. The button and script are working perfectly but the portal is not. Help! Thanks! Sabrina

In response to the post about FMRobot, I have tried contacting the company and for some reason they aren't contacting me back. If anyone has an "in" with NMCI, kick them in the pants for me and let them know they are going to lose a customer if they don't get their act together. I don't have time to chase down a salesperson to convince them to sell me their product! I talked to FileMaker about the importing and at first they sent me to their tech line and wanted me to pay $45 dollars (or $3 a minute) to figure out if the product would be advantageous for me to purchase. I did call back later and got a sales rep that knew what he was talking about but really! Why do they think we have time to chase them down for answers? What Leader said about the documentation applies to my frustrating search for answers BEFORE buying, every hour spent chasing is an hour taken from developing. I finally came here because I'm not getting straight answers anywhere else! Stann, thanks for your post. I had the same question and it's been answered well. I hope you found the solution you needed. Thank you all for posting answers found and say a quick prayer for me to find out the last things I need to know! (Next time I'm coming here FIRST! Silly me thought the actual company would answer my questions quicker . . .)

Yes, the loop is pretty much as follows: Goto Record (First) Loop Perform Subscript(External Script:Factor Assignment.fp5) Goto Record (next, exit after last) End Loop Goto Layout (View Factors) Like I said, I've stepped through the script to make sure it was going to the next record. (I set messages to pop up when the new record step is called and looked at the current record. It is stepping through the records.) I'm wondering more if there is a default where FMP will take the first record only.

I am trying to assign records in a seperate database with data from records in the first. The problem is that the script is only assigning the first record over and over again. How I have things set up is the first database (Statement Entry) is the data entry part where questions are assigned on one layout then the question text is automatically inserted into a seperate layout (magic!) where the responses to the questions are entered for each respondent. I have things set up so the records are one to each respondent. Each question has 3 factor fields where the user assigns a broad definition(s) to what the respondent said. The second database (Factor Assignment)is where I'm trying to take the Name, Factor Name and Statement Text and assign each set to individual records. The script is a loop from the first database (Statement Entry) starting at the first record and looping until the last record. The loop calls a script in the second database (Factor Assignment) that assigns the Factors, Statement Text and Name to new records. Then the second database calls a clean up script that loops through the records and deletes any records that don't have a factor name. (Some statements only have one or two factors.) It works perfectly except for the fact that it will only copy the data from the very first record. I've steped through the script and the loop is working (moving to the next record and staying there until told to move again) but FMP still takes the data from the first record. I've tried omitting the record after assigning it but FMP still assigns the first record. I've tried assigning the fields in database 2 (Factor Assignment) from the first database (Statements Entry) but it doesn't assign the data and I end up with blank records. I'm willing to overhaul my script but I can't think of anyother way to do the assignment besides assigning every statement to a generic global in the first database and then assigning the global in the second. The only problem is that is a huge amount of scripting to add on top of the monster I already have in the second database. Help!

OK, I see where you are going with your files . . . thank you! It's pretty gal-darned close to what I need. You're a scha-weet heart! Sabrina

I came up with a working sample. Where can I send it? Sabrina

OK, what I am hearing (reading) is there are 3 fields where different zippers are entered. I am also hearing that there are infinite possibilities of zippers but most are already set. A main snafoo is to make the database be able to quickly adapt to a zipper added. Then there needs to be a script to tally each type of zipper entered in any of the 3 main zipper fields. Question: are the 3 zipper fields on the same layout and in direct tab order of eachother? Question: there was some discussion about color. Is the color in the main serial number that you are trying to track or does color need to be tracked also? I do have an idea. I'll post it once I have a working model. Sabrina

I don't see those files . . . Am I going blind too? Sabrina

Unfortunately, there is no way to track the criteria because it all depends on the group of people being quoted. For example, some groups are presented with questions of fruit while others are asked about car oil brands. No, I cannot change each group to their own file because I would end up with thousands of files and messy architecture but I do need to find someway to sort what the fruit group says about the aspects of the fruit shown to them. Because we don't know what each individual is going to notice about the fruit we cannot program that in. Also, because almost every group of respondents are given different things and scenarios to evaluate, I need a way to quickly change the field without having to change the hard coding all of the time. I won't be here forever. I hope that all makes sense! Thanks! Sabrina

Even more to the problem . . . I've been playing around with this and discovered that if I leave the value list empty and try to access it from somewhere else, I only get the first entry. Ya know, I'm getting a little frustrated . . .

I don't know if I'm too late to get in on this but if you have a summary of the first zipper field and a summary of the second zipper field, can't you make a calculation field that adds the two summary fields? You both prolly have it figured out by now but that's what popped into my mind when I read your posts.

OK peeps, I have a conundrum here . . . I need to track entries with a summarized (not summary) field next to the fields. For example: Name: Robert Field 1: There wasn't enough light (summarized) Field 2: light conditions The Field 2 needs to be tracked with a data validation so that the summary lettering is always the same so that I can send Field 1 ("There wasn't enough light") with the name (Robert) tacked on the end to a collection field displaying all the comments under the title of Field 2 ("light conditions"). Here's the problem: The solution I thought up for the data validation is to have a pop-up menu or list set without entries and have "Other" selected in the main screen so the first time a person goes to the field, the pop up list says only "Other" and the "Other" menu pops up giving a blank screen for the data entry person to enter the first summarized title. Now the catch: I need to write a script that will look at the first value (light conditions) in the value list and send all the statements to the collection field with light conditions as a summarized field. I can figure out everything except how to get FMP to capture the individual values in the pop-ups. Is it even possible? In a purely scripted language, I would store the summarized titles in an array and simply access the individual portions of the array. Here's the other catch: Only about 20 records will have the same titles in Field 2. When all the data entry is done, there will be thousands of records so hard coding is not an option. There is no way for me to anticipate all the summarized field entries needed and even if I could, it will be in the millions and invariably, my boss will ask me to change something making me go insane because I have to go through the hard code (which shouldn't be done in the first place) and my poor son will have the stigma of having a lunatic for a mother. If not for me, please help for my son. : Any suggestions? A work around would be OK if what I want isn't possible. Sabrina

OK, I see where my equasion didn't make sense, so I corrected it. Case(Month(Respondent_Date_of_Birth) > Month(Focus Group::Focus_Group_Date), Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth) - 1, Month(Respondent_Date_of_Birth) = Month(Focus Group::Focus_Group_Date) and Day(Respondent_Date_of_Birth) > Day(Focus Group::Focus_Group_Date), Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth) - 1, Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth)) I know this seems like a lot of work, but the other equasion wasn't working and it is vital the age be exactly correct.

I also fixed his equasion with the paren before and it did not help. I kept getting 1 for the ages. *Shrug*

The equasion I wrote is actually working perfectly. I went through tons of dates and it was always correct. I'll go test it some more, but it seems to be fine. Thanks!

The best way I see for them to create a record w/out the mouse is the command (Win -Ctrl, Mac -apple key) + N. My boss didn't even know about scripts and has used this program for 10 years. He just used the keyboard shortcut. The other script I would leave in the menu like you said. Hopefully someone else out there can be more useful. I can't see why anyone wouldn't want a mouse, but I guess there's all kinds out there. good luck!

I had a similar problem . . . You will need to track how many records you have for this to work. We'll call that variable g_num_Records. The fields with g_ at the beginning are globals and MUST be globals for this to work. <! initializing variables> count = 0 g_field_One_value_One_Count = 0 g_field_One_value_Two_Count = 0 g_field_One_value_Three_Count = 0 Loop If (Field_One = value_One) set Field (g_field_One_value_One_Count, g_field_One_value_One_Count + 1) End If If (Field_One = value_Two) set Field (g_field_One_Value_Two_Count, g_field_One_Value_Two_Count + 1) End If If (Field_One = value_Three) set Field (g_field_One_value_Three_Count, g_field_One_value_Three_Count + 1) End If count = count +1 goto Next Record End Loop If (count = g_num_Records) I then had a layout specifically to display the globals. Hope this helps you out! It's long and laborous, but the only way I figured out to do what I needed!

This is working perfectly! Thanks for setting me on the right track! If(Month(Respondent_Date_of_Birth) and Day(Respondent_Date_of_Birth) > Month(Focus Group::Focus_Group_Date) and Day(Focus Group::Focus_Group_Date), Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth) - 1, Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth)) P

Thank you for yor response! You typed: Year(Focus Group::Focus_Group_Date) - Year(Respondent_Date_of_Birth) - (Focus Group::Focus_Group_Date < Date(Month(Respondent_Date_of_Birth), Day(Respondent_Date_of_Birth), Year(Focus Group::Focus_Group_Date)) Unfortunately, this equasion didn't quite work even after I played with it. It's closer than what I had, but still not right. Say the Focus group was today, July 23, 2003 and the person was born August 22, 1967. The equasion would look something like: 2003-1967-(serial number of July 23, 2003) < (serial number of August 22, 1967) right? What if I did an if statement . . . If (Resp month & day > Focus group month & day) (year(FocusGroup) -1) - year(Resp D.O.B.) Else year(FocusGroup) - year(Resp D.O.B.) End If I'm going to go try this . . . wish me luck!

OK, I can't find somewhere that it's already posted how to do this . . . I'm trying to automatically set the age of a person on a set day by entering their date of birth. The calculation I figured out that isn't working is: Focus Group::Focus_Group_Date- Respondent_Date_of_Birth I know why it isn't working -because I'm subtracting the serial number assigned to the date and not the number date, but I can't figure out an alternative. I tried searching for a previous post, but I can't find one. Can anyone point me in the right direction or help me come up with a formula that works? Thanks all!

I didn't know that you could leave that blank! You and Ernst are awesome! Thanks for your help! Sabrina