February 17, 200520 yr I want to check that once a new record is created and a particular field ('Events') is entered into, that if subsequently 'Events' is altered (but still contains text), that a warning message is displayed. Can't figure how to check for modification of field and give message (or bar it if necessary) Grateful for any help
February 17, 200520 yr Under validation of the field, enter a calculation "not length(field_name)". This will give a warning whenever the field is changed unless was empty to begin with. If you select Allow User to Override, they will still be able to enter the changes.
February 17, 200520 yr Author thanks - but that only works if the user has clicked outside the field. I want a way so that at the moment of entering new data a warning is generated. At the moment I'm using the field also set as a button firing a script that checks against a calc field for any changes. Works okay - but requires two clicks into the field (I can't work out why yet).... so it's all a bit clunky.
Create an account or sign in to comment