Warning Message

[samarthmkt]

How we can get an warning popup message on every data field to avoid incidentally editing or When we go for editing any data field(Once data have entered).

Thanks

[Kris M]

 Please define "avoid incidentally editing" and "editing any data field(Once data have entered)." more precisley so we can help you.

I dont think your gave us enough to go on.

[samarthmkt]

Thanks for reply

 

My request is that if we put any data in text or numeric field and save the page. Once the page have been saved and if in future we again visit to same page and incidentally the field data is deleted. So before going to delete or change any data field it must warn by popup message (you are going to delete or change the field -- yes or no )

[milanm]

You could do this in at least 2 ways...

One would be in field validation section in Manage Database (File~Manage~Database~Fields~Options~Validation) - see if anything there could stop users from importing the value and display message before they try t do so.

Other way is by placing a script trigger on each field (you could do this in one go for all selected fields) that would display the warning message on object enter if the field contains the value.

[Josh Ormond]

Another approach is to just give the user a View only screen. With all field entry disabled. Provide an "Edit" button, that takes them to a layout that allows editing.

[LaRetta]

Another option is for each table to have an 'unlock' number field (1 being locked) maybe called isLocked.  Then let security stop modification of the record by:

 

not IsLocked

 

Then if someone needs to edit a record, they just unlock it first.  As indicated by the number of responses, there are many approaches.  The best approach would depend upon the type of data, how critical is the lock, what is the work flow, whether different Users would have different rights to unlock, does the record have children which must also be locked or protected etc.

 

Using security, you will get an unpleasant message but Users will only get the message a few times before them begin to remember to unlock before changing information.

[samarthmkt]

Thanks to all above friends for there valuable tips.