TRIGGERS ARE AWESOME, BUT NEED
TRIGGERS ARE AWESOME, BUT WE NEED TO HAVE SOME OF THEM AUTOMATIC AND NOT FORCED. EXAMPLE: IF DIFFERENCE BETWEEN DATE ENTERED AND TODAY'S DATE IS 30 DAYS, IT AUTOMATICALLY MOVES RECORDS FROM ON TABLE TO THE NEXT.
ALSO, THE NEW TRIGGERS NEED THE OPTION TO BE ABLE TO SEND THE NOTIFICATIONS AND ACKNOWLEDGEMENT EMAILS OUT JUST AS YOU CAN WHEN YOU USE THE DATAPAGES.
I HOPE YOU CAN IMPLEMENT THIS REQUESTS SOON, BECAUSE DOING THINGS MANUALLY IS GETTING OLD.
THANKS IN ADVANCE.
Michael
shared this idea
Email and SMS options are now available in Trigger Actions in Caspio Bridge 12.0. More information can be found at https://howto.caspio.com/tables-and-views/triggered-actions/
-
Douglas Vega commented
But that wont resolve Michael's point. Right now, triggers would need someone to update the data so the trigger gets fired.
But how about this:
For example, I have an orders table with due date field. If due date is before today, I would like to add a new record to Overdue Orders table. None would update this, it will just be overdue. I think that is what Michael meant by "Automatic and not only Forced triggers".It will be awesome to have something like this.
-
Tony S
commented
Hi Michael,
isn't it possible to reach your first scenario with the current triggers in Caspio? There are date functions present.
That can looks like INSERT + SELECT with WHERE DATEDIFF date and today > 30 days.