LPL to restrict field value on form field

mbozenik

We are trying to restrict the range of values to be entered on the "FTE" field in the "workassignment" business class on the "Transfer" form.   I've tried raise alert but it doesn't work and I've tried display as slider but it appears to only accept percent from and to values and not a number.   We are trying to restrict FTE from 0.000000 and 1.000000.  Is there a way to do this?  Also tried if (!FTE >= 0.00000 and FTE <= 1.00000) cannot be entered "FTEValueIncorrect"  --but that appears to only work on derived fields.  Are there any ranges, limit, constraints, conditions that can be applied for form fields

apiazza

Yes, you should be able to do this.  Quick caveat to my reply, we are currently on premise.  This LPL code should work:

FTE

    constraint(FTE >=0.000000

    and FTE <= 1.000000)

        "FTEValueIsIncorrect"

Basically you need to say the value has to be greater than or equal to your lowest possible acceptable value AND less than or equal to your highest possible acceptable value.  Then another indent under the constraint should allow you to put in a custom error message.

Good luck!