6 Replies Latest reply on Jun 11, 2010 2:57 PM by philmodjunk

    Encoding text to numbers to make a calculation



      Encoding text to numbers to make a calculation



      I am using filemaker 11 on windows XP, with the eventual intention to publish on the web or network. I am a novice filemaker user, but have some experience using a simple coding language for a statistics program known as stata, but little filemaker experience.


      The database is being created to follow surgical patients for a particular type of surgery. And four variables I can collect can be used to calculate a score. For example:


      Field 1=Headache; valuelist=yes/no

      Field 2=Hair color; valuelist=red/blue/blond/brown/black

      Field 3=Head size; valuelist(number)


      I need to encode the values into 0-1 for field 1, 0-3 for field 2 (some colors have same score), and field 3 I will score according to three created dummy variables: <10cm, >=10cm & <=20cm, >20cm. These will then be scored from 0-3.


      My calculation field, (field 4) will need to sum these scores up for a final score....



      I am having trouble finding out about how to do this, and have checked out the filemaker function manual, but I really need some outside help.