AnsweredAssumed Answered

Data validation

Question asked by SorenSondergaard on Feb 20, 2013
Latest reply on Feb 21, 2013 by philmodjunk


Data validation


     I'm told Filemaker is the promised land of  databases but I seem to stumble before entering: in Excel a function 'data validation' allow you to associate a drop menu of choices via an equation of nested if, then's to a number. E.g. a dropmenu of heart rates <60, 61-70,71-80,>80 needs to be associated with numbers 1,2,3 or 4 - which is later to be summed with other numbers from other drop menus to create a 'risk number'. How to do it?

     Please let me in,

     yours sincerely,

     Soren Sondergaard