Drop Down options to provide response in a diffrent field
I have managed to create an interactive form with its various functions, however have a couple of areas not working out as preferred.
1. for example I have a Drop down field (Named "AREA1") with three options to select from, however depending on which one of the three options selected I requirer a diffrent text/descriptions showing in another text field (Named RC1) for each of the options from the drop down field. What script is required and in what field do I allocate the script?
2. I have three numeric column (Amount), (GST) and (Total). I have written scripts to the GST and total columns which automatically calculates the GST value and also the total of the original amount plus the GST. My problem is that in a user format or PDF preview the GST and Total Column is showing 0.00 and I would prefer these fields to not show anything until the amount column is populated. some kind of conditional formatting perhaps?
Some simple feedback to both of these would be greatly appreciated.