Bookmarks
Account
ACL
Tools
New
Add to Bookmarks (1)
Manage Bookmarks (1)
Change Personal Details (1)
Change Personal Password (1)
Change Account Details (1)
Manage Users (3 pages)
Add User (2 pages)
Monitor Users Activity (1)
Manage Roles (6 pages)
Add Role (1)
Chat (2 pages)
Project Manager (1)
Application Analyzer (1)
On-line Designer (GYRE) (1)
Barcode (1)
Site Wizard (4 pages)
Publish Site (5 pages)
Table (11 pages)
Query (1)
View (1)
Function (and Triggers) (2)
Template (1)
Action (3)
Application (1)
Chart (1)
Image (1)
Site (4 pages)
HTML (1)
Datasource (1)
File (1)
PDF (1)
GYRE Module (1)
Other
Y-Tree (1)
Help (1)
Type (1)
Tutorial Introduction
New. Action
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.9% of the time) to allow all Users direct access to your Tables.  Actions give you an additional set of controls along with an additional means of manipulating a Datasource.
Actions can also be used in concert with CRON to automatically 'run' an Action at specified intervals.
So your business 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.
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 a User 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.
---><---
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.
If you are a Novice - you will usually Create a New Datasource using the Wizard.  It will generate 4 Actions automatically.  If you are an Expert with PHP, then you can simply Create --> New Action and then write your script.

Click # 2 above for an Example of 1 of the 4 automatically generated Actions when you create a Datasource using Wizard mode.
Click # 3 above if you would like to view an image of an Expert's, scripted Action.
Four simple but powerful Actions are automatically created when you create a Datasource (USING the Wizard) from a Table or Query.  You may Edit these Actions, anytime.  They are:
Automatically written Wizard Actions (PHP)
New Action -Step 1
1
2
3
Start
Wizard
Expert