Jump to content

Field Validation for Accede / Resign Solution...

This topic is 2266 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

Hello everyone


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


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.


Now, based on my project description, a couple of the fields will have to be validated / not empty, 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 I think the built in feature is bonkers..... (Sorry FileMaker..) 


Therefore I was thinking of making a script to each of the different fields, which needs validation, and is this even a good solution


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

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


Fields such as; Company Name, HR-manager name, HR-manager e-mail, employee SSN, employee name, employee surname etc. 


I don't want the scripts to interfere with the other option types ( X, Y, Z ) which each is set by an unique ID, as well as fields, although the fields used in these option types are from the same table.


Please see attached images of my setup.


Hope you can help me, for the best possible solution.

If you need more information, let me know.




P.S. The language/text on the layout is Danish, although shouldn't be considered an issue for understanding my problem.

Skærmbillede 2016-04-11 kl. 16.07.20.png

Skærmbillede 2016-04-11 kl. 16.07.31.png

Skærmbillede 2016-04-11 kl. 16.07.40.png

Link to comment
Share on other sites

This topic is 2266 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.