Record Validation
From the Settings tab in the Table Settings, set the Record Validation.
In the validation code, you can not only compare values of posted data, but can use the InfoLobby internal function to query your data. This allows you to validate very complex scenarios.
In the video example above, we showcase a simple case of ensuring a "to" date is always greater than a "from" date, but you can easily use validation to gather data from other tables and validate the input accordingly. For example:
- In a vacation table, ensure the employee has available vacation days
- In an orders table, ensure the product is in stock
- In a timesheet table, ensure the budget of the project is not exceeded
- etc ...
