Compare two fields and show hidden field
I have two fields, one is calculated (text2) and the other has the user entering the data (text1). I want to compare the number entered to the calculated field. (The calculated field does not use the entered field in the calculation. Also, the calculation occurs prior to entries into text1) The entered number needs to be less than or equal to the calculated field. If it is not, I would like to un-hide a third text field (text3) - or I could use a popup alert. I do not want text3 to show until after something is entered into text1, meaning I don't want it to show before the user has a chance to enter a number.
I've read through an assortment of similar posts but can't seem to find an answer that will work. It is unclear to me if this should be a validation script, a custom calculation, or added to an action.
Any help would be greatly appreciated.
