In the left column, they will enter a number. I would like for the right column to be calculated from that. However, the currency amount (ie. 100, 50, 20, etc) isn't a text field. It is simply text that entered in another program. What I'm looking for is a way to do this without having to make the currency amounts a text field. Something along the lines of X*100=.
If you can give any help or suggestions, I would greatly appreciate it.
You will have to hard code the currency amount into the script.
In the first line, create 2 text fields, Text1 and Text2. Use this as the custom calculation script for Text2:
event.value = this.getField("Text1").value * 100;
//Clears Text2 if nothing is in Text1
else event.value = ""
The second pair of text fields would have "50" instead of "100" in line 2, etc.