Issue: the problem was caused by the field being a currency field. When I changed it to a regular number field, it worked fine. Some weird bug.
My conclusion about the error below was incorrect. The problem is somewhere else, but I cannot solve it. Here is what happens:
- Load new form
- Select Value A from a lookup Field 1
- On User Input for Field 1 script is triggered:
- If lookup 1 = A, then set Field 2 (currency) to a fixed value and disable Field 2
- Otherwise, set Field 2 to null and enable field 2 (as it might have been disabled before)
- Select Value B in lookup field 1
- On User Input scrip is NOT triggered
The script will not work again once Field 2 (currency) has a non-null value. If I manually remove the value that is there and change the value of Field 1, it works again, but once Field 2 is set again, On User Input stops working. Field 2 does not have its on on user input.
The On User Input is not triggered when I change the value of a lookup field, at least when I first fill out a form.
For example:
- Load new form
- Select New York from pull down menu/lookup field.
- On User Input is triggered.
- Change value to New Jersey in lookup.
- On User Input is NOT triggered.
Also, certain selections should not be made and I want to reset the lookup field back to "-select-" after this happens using On User Input (after I put up an alert to let the user know). using "input.FieldName = null" does not work.
Here is the app/form:
https://creator.zoho.com/msalamon/greenball2012/#Form:Winning_BidsI have provided support access.