richardb

Is there anyway to have a graphic element on a layout which acts as a field, in that when a user clicks on a certain area of the graphic, it returns a different value. For example: A line on which the user indicates a point, and that returns a value ie. a visual analogue scale or A picture of the bowel where the user can mark the position where a tumour occured and that would return a value. Any thoughts much appreciated.

Was working through the audit trail solution in the book Advanced FileMaker Pro 5.5 by Bowers and Moyer. As some of you have noted in previous posts, if you follow the book it doesn't work but it does on the supplied CD file. The problem is that in the book (pg.88), the authors say that calculations will trigger before lookups, allowing time for a calculation (Audit_Current Text) to capture both the old and new values in the field. But it doesn't work if you constuct the fields as they suggest in the book as the capturing calculation is created AFTER the lookup has been created - hence only the new value is captured. If you go to the CD file which does work and in Define Fields order by creation, you will notice that the Audit_Current Text field is the first one created and hence will capture the old and new changes before the lookups. It is the order of creation and not the concept of calculations triggering before lookups that seems to hold true here. Perhaps the book could have emphasized this point and saved me (and I suspect a few of you) several hours of deep contemplation (garnished with a bit of frustration). I post this to hopefully save someone else some time nutting it out.

I am writing a simple log book of operations for 250 surgical trainees in Aus. I am needing some advice on the best way at the end of each 6 months, each trainee could e-mail their data to the supervising body. I know how to save a found set as a fmp file or .csv file etc, but was wondering if there was anyway to simply have the found set exported to an e-mail message eith the push of a button, without having to save it first and add it as an attatchment to an e-mail message. Would appreciate any advice.

I have 2 fields in my database. One is a number and the other a description. A list of the numbers and descritions exist in another realted file. I want the user to choose the value they want for either field as a value list. My problem is that I need the flexibility that if a user wants to enter the number, the description will automatically be looked-up and entered OR if they want to look at a list of descriptions they can click on that field and when they select the one they want, the number will be looked-up and entered into the number field. I can get it going one way easily using look-ups, but can't get it to work the other way around at the same time. Any help much appreciated.

Worked well thanks kindly

Sorry. Should have made it clearer. I have data with some records which have a number at the start eg. 443. The rest are text. I wish to find only records which have a number as the start of a particular field and not the text. But the number must be the start of the field, not somewhere else in it.

Is there a way to find a range of numbers in a certain position within a particular record? I wish to find records that have a number in the first 4 positions of the record, but not records which have numbers in other positions within the record. Thanks

Is there a size resitriction to value lists ? I have 2 related files, which when I create a value list from them showing 2 fields, will always (I mean always) cause FileMaker to crash if I try to use the value list in the main file. I am assuming they are too large and File Maker can't handle it. Assuming this is the problem, is there anyway that you can have a user select an item from a list of say 1000 options without using the value lists as they stand. Thanks

Thought about it this am in theatre and believe it or not, it works The whole file took 3 mins to process. This is the looping script - it might be of value to anyone who has a similar problem. Loop Go to Record/Request/Page [First] If ["Left(Raw data, 2)="10""] New Record/Request Set Field [Mark, "New"] Set Field ["10", "Parsed 10 field"] Set Field ["20", "Parsed 20 field"] :: and so on for all the fields you want in your final record Omit Record Go to Record/Request/Page [First] If ["Left(Raw data, 2)="10""] Set Field ["Parsed 10 field", "Middle(Raw data, 3, 5)"] Else If ["Left(Raw data, 2) = "20""] Set Field ["Parsed 20 field", Middle (Raw data, 22,7)"] ::and so on for each line, parse out the data you want:: Else :: this is how I appended or merged the "50" items into one field:: If ["Left(Raw data),2)="50""] If ["IsEmpty(Parsed 50 field)"] Set Field ["Parsed 50 field", "Middle(Raw data, 13, 80)"] Else InsertCalculatedResult["Parsed 50 field"," " & Middle(Raw data, 13, 80)"] End If Omit record Exit Loop If ["Stauts(CurrentFoundCount)=0"] End Loop Note: The "Parsed 10 field" and the like are the global fields and the fileds "10", "20" etc. are the final fields for each record. You find all the records that you created as they have "New" in the Mark field. You will have to delete the very first record marked with "New" as it is created right at the start of the script and contains no data. Thank you very much for the advice which allowed me to achieve this. Feel free to improve on this script.

Bob, thanks for your ideas. I finally got a looping script to work as you suggested, with one line of raw data per record. My only remaining problem is, and forgive me if this is a simple technique (I'm a doctor not a FMP guru :-)), I am unsure how to append or join the "50" records together, as several "50" items form the complete field in any one record. Cheers

Thanks for the idea Bob problem is that the file is 1.3 MB I might just have to split it up, but the idea of a looping script for each line is a great one. I suppose I can use the middle function before appending the "50" items to just extract the required text for each record. I'll give it a go when I get some time thanks again

I have an ASCII list file which I am trying to import into FMP. The problem is that the list is not 1 record per line, but any record may be comprised from up to 7 lines in the list. The only way you know when you come to another record is if a line begins with "10". 2 records are given as an example: 1034127 01.12.199100.00.00003 T8 3 SN 2001.11.200001235.3000926.5001182.80 4001.11.19940029 17729 5001.12.1991Arterio-venous fistula of the abdomen, 5001.12.1991dissection and repair of, with restoration of 5001.12.1991continuity 5001.12.1991(Assist.) 1034130 01.12.199100.00.00003 T8 3 SN 2001.11.200000386.4500289.8500333.95 4001.11.19940012 17712 5001.12.1991Surgically created arterio-venous fistula of an 5001.12.1991extremity, closure of 5001.12.1991(Assist.) 10, 20, 30, 40, 50 at the start designate different fields in the same record. My problem is (1) how to separate the records as there is no delimiter other than the occurance of a "10" at the start of a line and (2) the lines which start with 50 need to all be in one field in the final database for each record. I am not sure how to combine them. Any ideas much appreciated.

I have two fields in my database, Item Number and Operation descritption which are listed in another related file. What I want to a achieve is, if you click on item number, a value list of all the item numbers comes up and once one is selected, the corresponding operation description is entered AND (and this is the part I can't do) when the operation desciption is clicked on, the list of operations pops up and the item number is automatically entered!! I can do one or the other but not both. The idea being that the user can look-up either the item number OR the description and the other corresponding variable is automatically entered. Any help much apprectiated. ------------------

I have a value list which looks up values from a second file. When I use the option of showing a second field from that file in the value list, FMP simply crashes each time I try to use the value list. Any help much appreciated. For those who understand these things, I get the following techno-babble. FILEMAKER PRO caused an invalid page fault in module FILEMAKER PRO.EXE at 015f:004943a1. Registers: EAX=00000004 CS=015f EIP=004943a1 EFLGS=00010246 EBX=00000000 SS=0167 ESP=0098f9d8 EBP=01b70b00 ECX=02862678 DS=0167 ESI=02862678 FS=57bf EDX=00010050 ES=0167 EDI=0000000f GS=0000 Bytes at CS:EIP: 66 83 40 02 0e c3 90 90 90 90 90 90 90 90 90 a1 Stack dump: 00494b07 00000004 0000000f 0000000f 0098fa38 0098fa40 00000001 00000008 02862678 00000015 000006d0 01b70000 0068374e 01b70b00 00808080 01b70b10