AnsweredAssumed Answered

Field Validation by Script - Global Field

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

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.

 

So...


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.

Outcomes