Jump to content


  • Posts

  • Joined

  • Last visited

Marcel1's Achievements


Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Yes, I am hoping to use this for reporting. OK so I tried inserting the calculation If [ A::A = "Zee" ] Set Field [ Related::; Related:: + 1 ] End If into the script, and this morning for some reason it works just fine. Thanks for the help! M
  2. Hi thanks, Sorry should have been more clear; I am actually trying to mathematically increment the present value of the related field by 1 (ie if the present value in the related field is 6 and the conditions are met, the value after the script step would be 7). I am not desperate to use a script, and if there is an easier way, by all means.. I am not sure how to create a summary field to do what I am hoping to do. I did look up summary fields, but it is not clear to me how I can use them to calculate sums on a found subset of records in the main table. M
  3. Right, I can see how something like ( Case Table::result = "value1 1"; 1) could be handy. But then how do I get a sum of these values for a subset of records in my table? M
  4. This seems trivial, but... I am having a little difficulty with a script that is intended to examine the contents of a field, and if it is "A", add 1 to a field in a related record, if it is "B", add 1 to another field in a related record, etc.. Basically I am making a counter script to record the number of times a particular value occurs in a field, that I can run on a found subset of my main table. However, I am having a little trouble creating the calculation. Does anyone know how to do this? Marcel
  5. Hi, I have a table with a large number of records, and a field called "result". Result can have one of 8 different possible values. I would like to create a field that automatically adds up how many records in the table have value1, value2, ... value8 in the field "result". So, I created a global field for each potential value in the field result (g_value1, g_value2, ...g_value8) , created 8 additional instances of the table, and linked them to the original table by relating the "g_valueX" fields to "result" in the original table. I then created fields that count all records, calculated from the perspective of table instance 2, instance 3, ...instance 8. The problem: The solution seems to work correctly, but the 8 count_records fields only have entries when I am looking at the last record in the original table. If I go to any other record, the fields are blank. Why is this, and is there any way to fix it? I think I have to trigger the calculation to occur in all records, but I am not quite sure if this is the problem, or how to do it. Any thoughts welcome. Many thanks.
  6. Changing the table2 field[patientID] to [table1::patientID] worked and seems to do what I need. Thank you. Marcel
  7. OK, I am completely mystified... Tables 1 and 2 in my database are related by a field called sampleId (ie, table1::sampleID = Table2::sampleID). Each table also has the text field "patientID", which does not participate in the relationship. In Table1, both sampleID and patientID are entered manually. Problem: In Table2, I would like to have patientID automatically update to be the value of patientID in the related record from Table1. Seems simple. In table2, I defined patientID to be an auto-enter calculation from this field in table1. However, the entry in table 2 stubbornly remains blank despite a non-empty field in table 1. I tested the relationship between tables 1 & 2 by showing the contents of a field from table 1 in the layout of table 2, and this appears to be working fine. I think I defined the field correctly. I also tried tapping the side of the computer to see if that helps.... Any thoughts welcome Marcel
  8. I have a large database and wish to add a new field to each record that INITIALLY contains the contents of another field, that I can later edit. Is there an easy way to do this? Marcel
  9. Thank you, The first method worked great. However, I did not quite understand the excel part. There are about 300 records to find - how do i put their IDs into a global field? Also, what is GTRR? M
  10. Hi, I am having some trouble doing complex finds using the standard finding function in FM. I would like to find all records in my database where one field is not empty (no problem so far), and where another field does NOT contain a particular value (problem!). Can I use the find function, or do I have to write a script? As a way around my problem, I sorted some records of interest in excel, and have a pared-down list of records that i would like to find. Is there a way in FM to find all records matching a list of serial IDs in an excel sheet? Many thanks, Marcel
  11. Hi David, Sounds like this approach might be helpful. One issue; the "IntervalTime" should always be the time from the 1st sample to the time of any other sample. (I should probably call it "elapsed time"). Any way to adapt your solution? Marcel
  12. Hi, I have a database containing records with fields for "serialID", "patient", "sample", and "time collected". Often, several records share the same values for patient and "time collected". I would like to have a field that calculates "IntervalTime" for each record. This would be the elapsed time between when the sample from that record was collected and the time when the first sample from the same patient was collected. (Obviously, the entry for IntervalTime would always be = 0 for the first sample collected for any patient, and all subsequent samples from that patient would have values > 0) I think this is crying out for a script, but I am not sure how to do it. Any thoughts welcome. Thanks, Marcel
  13. Thank you, this worked very well! Help much appreciated. Marcel
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.