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.