AnsweredAssumed Answered

Field Validation by Script - Global Field

Question asked by ChristofferRexen_1 on Apr 8, 2016
Latest reply on Jul 3, 2016 by Andy Hibbs

Hello everyone


I am currently working on a database, which HR-Managers can access via WebDirect using login-information, to accede or resign employees.

Now, based on my project description, a couple of the fields will have to be validated, which the HR-manager is prompted to enter before the record can be committed.


Now, I am aware of FileMaker has it's own Field Validation, but it is not a secret it's bonkers..... (Sorry FileMaker..) 


Therefore I was thinking of making a script to each of the different fields, which needs validation.


Furthermore, I have made 6 possible option types for the HR-employees to enter data into, set by an unique ID, but with the use of the same fields.



X fields with option type 1 (Accede)

Y fields with option type 2 (Resign)

Z fields with option type 3 (Maternity leave / leave)

.. Etc. 6 option types in total.


Question one; how do I do this, the most easily? Is it possible?

I have 8 required fields for validation, fields are global.

I don't want the scripts to interfere with the other option types, X, Y, Z, which each is set by an unique ID.


Please see attached image of my setup.