The BeforeAdd event is executed before the record is physically added to the database. It works in all add modes: Inline Add, Regular Add and an Add page in popup.
BeforeAdd($values, $message, $inline, $pageObject)
Note: Field names are case-sensitive. If the field name is PlayerId, you should use $values["PlayerId"]. Note that $values["playerid"] or $values["PlayerID"] will not work.
Note: If the field was assigned an alias in the SQL query, then the $values array will get the alias instead of the field name from the database.
E.g., if you have an SQL query SELECT salesrep_id AS Inv_Salesrep ..., you should use $values["Inv_Salesrep"].
an list of values to be written to the database. To access a specific field value, use $values["FieldName"]
message to display to the end user in case if you return false.
true for the Inline Add or Add in popup, false for the standalone Add page.
an object representing the current page. For more information, see RunnerPage class.
True: continue adding the record.
False: the record would not be added.
Applies to pages
Add, Inline Add.
Recommended sample events:
•Add custom field to form
•Limit number of records users can add
•Select multiple values from checkboxes or a list field and have them appear as individual database entries
•Update multiple tables
•Send mass email to al users
•Rename uploaded files
•Speed up data entry using events
•How to control Inline Add/Edit functionality from script
•After record added
•Choose pages screen
•About SQLQuery class
•About SQLQuery screen
•Additional WHERE tabs