Actions give you the power to control the interactions between a User and your Tables. Sitting 'in-between' your Tables and Users is a Datasource (a data layer) and Actions. It would be a bad idea (99% of the time) to allow non-HR employees direct access to your Tables.Actions give you the controls.
Actions can also be used in concert with CRON to automatically 'run' an Action at specified intervals. So your HR Department can be working over the weekend. That's the best kind of productivity. Work without working. Chances are very high that someone in your IT department knows Php & can write Expert mode Actions. If not, we can help.
Four simple but powerful Actions are automatically created when you create a Datasource from a Table or Query. You may Edit these Actions, anytime. They are: Select (Select records from your Table) (also for Query)Insert (Add a record to your Table)Update (Edit data in an existing Table)Delete (Delete a Record in your Table) When an Employee uses an Application, they are not working directly with your Tables, they are working with a Datasource - a layer of data. An Action allows (or disallows) interactivity between the User and your Tables. Think of Actions as a means of providing you with an additional layer of security. Actions are used for many facets of complex data driven projects, such as employee benefit statements
---><---
User(Browser)
Datasource
---><---
Actions
Tables
---><---
Data moves from left to right and back to the user, very quickly. The user does not need to sit and wait as a screen refreshes.
Actions can also be used as a way to retrieve remote data (example: the weather updates anywhere in the US from the National Weather site) - or - to manipulate data that is already in a Table. Example, a Table that has:Name __ ee_address __ city__state__zip .... can be reformatted to be: Nameee_addresscitystatezip
This can be done without altering the original Table, keeping it 'clean' and in its original condition.
Select New --> Action from your Menu. Give it a name and description.From there, you would work in the Action Editor. Examples will soon be available.
Have a Question?
Your email
Expert mode allows a type of Action called a Procedure where additional control can be added. A Procedure can be used to direct a certain class of employees to different types of self-service, employee benefit statements.