profile validation - solution design question

Regarding the following use case:
Each time a user's profile is viewed, by anyone with access rights, a validation routine is triggered to evaluate the profile data and return a set of messages to be viewed within the profile itself. (a read-only text area.)
Saves would also trigger validation and update the validation results caused by profile field changes. The updated validation result messages should also appear after a save.

Complications:
The number of validations is large (over 50 fields to be validated, some fields are validated/dependent on other profile fields)
The number of profile fields to be validated may also vary, based on values in certain other profile fields

I'm quite handy with SQL, so I was thinking of building a MySQL procedure that returned the message strings.
Questions:
Assuming this is an auto-action, what are the event triggers for viewing and saving a user profile?
Other suggestions on alternative methods?
Thanks,
Fred

Depending on the validation you can probably just do that using a Custom HTML field and substitutions. Worst case you use a CB Code Field and write the PHP to validate everything and return whatever messages you want displayed, which will display wherever you put the field. You could also use CB Query Field if you wanted to do it entirely with SQL. Validating 50 fields won't be an issue for PHP or substitutions.

Kyle -
Thanks, appreciate the fast reply.
Is there docy/tutorial on using substitutions?
Fred

See the below tutorial for substitution usage information.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18353-using-substitutions-throughout-cb

You'd just use IF substitutions as shown at the bottom of the tutorial to validate. You can use REGEXP or just simple matches to validate as needed.

Thanks for the tutorial links - good stuff.

To follow on with this use case - I need to set a value in another profile field based on the validation results.
Is that possible from the Custom HTML field, or would I need to move to php Code field and include the db helper classes and all that?

Assuming I would need to move to php, how do I determine what user profile I'm executing on, within the php code? (I found a reference to $user array in a tutorial, so I assume that's the answer...)

Fred

To follow on with this use case - I need to set a value in another profile field based on the validation results.

You could do that dynamically using the Layout features for fields. Edit the field that you need its display to change then under Parameters > Layouts you can adjust how the field displays on profile view based off a IF substitution. Example as follows.

[cb:if username="demo"]This is Demo being displayed.[cb:else][value][/cb:else][/cb:if]

In this example if the username is demo it shows "This is Demo being displayed." otherwise it shows the value of the field. If you actually need this value stored in the database it gets a lot more complicated unfortunately and you'll likely have to use CB Auto Actions acting on profile update triggers and just do that behavior at storage time.