Populate a multi-line formula field dynamically
Posted on 2004-07-30
I am trying to populate a CR formula field (from VB6) with a 'Select' statement followed by several 'Case' statements. I have tried separating the 'Case' statements with spaces, commas, carriage-returns, line-feeds, and combination of carriage-return/line-feed. I always get a formula error. Here is a sample of what I am trying to do:
case " ": 880
case "10": 17
case "12": 5
I am dynamically determining both the 'case' selection item and its number. Trying to send the entire 'Select' statement as a string for the formula results in an error. Any ideas?