Search the Community
Showing results for tags 'triggered action'.
-
I'm looking for a workaround to remove a value on my dropdown field if it was already selected by one of my users and submitted using a submission form. Is that possible?
-
Using Table Variables in Triggered Actions
CraigSZ posted a question in Tables, Views and Relationships
Hi all, Is anyone able to please explain how Table Variables can be used in Triggered Actions, ideally with screenshots of how they are set and used? I have a Triggered Action where I am currently creating & setting (via select) a large number of individual variables and I believe that a Table Variable would allow me to do this once. I have not been able to find any useful Caspio documents on Table Variables and have just been on a very frustrating chat with support who confirmed that there is no documentation/instructions on the functionality. The only mention I can find of -
I am creating an on insert trigger for my table but upon testing, I got this error. Modified the trigger to a simple insert like this: However, the error still persists. Does anyone encounter the same issue? Any help would be greatly appreciated.
- 2 replies
-
- trigger
- triggered action
-
(and 1 more)
Tagged with:
-
Adding attachments in Triggered Action Email
ssneni posted a question in Tables, Views and Relationships
Is there a way to add attachments to the Triggered Action Email? -
Need help using Text255 Zipcodes in a triggered action
DarkRangerEX posted a question in General Questions
Hello, I am trying to make a triggered action that inserts records that have certain zip codes into a different table. The zip codes are stored as the Text 255 data type. The records that I want to send to the new table are ones with the zipcodes 00001 - 29999; 32000 - 34999; 40000 to 71599; and 73000 - 99999. I have been trying to use "SELECT WHERE #inserted.zip is greater than/less than" to filter the data, but I am getting weird results. For example, a zip code of 90210 gets shot to the other table, but 99876 does not, even though they both should be "greater than" 73000 in an alphanum -
When updating a record using the REST API, I encounter the following error: "Code":"TriggerRuntimeError","Message":"Data change cannot be performed due to triggered action failed. Please contact administrator." The table has a triggered action to send an email anytime a record is updated or inserted. The really strange part is that everything works perfectly fine when using chrome. The error is only thrown in mozilla and only thrown when updating a record. Inserting a record works as expected. I am using php & curl to make the requests.
- 4 replies
-
- api
- triggered action
-
(and 2 more)
Tagged with:
-
Creating Audit Trail via Triggered Actions
kgraham2121 posted a question in Tables, Views and Relationships
Hi, I'm trying to to created a triggered action that populates and Audit Log Summary Table (1 record per event - ) and an Audit Log Details Table ( 1 record per changed Field/Column). Workflow is upon Insert or Update to Orders Table want to Log Changes. Trying to keep Log tables as simple as possible. Assume following Table Structures: Orders Table: Accession ID (Primary Key) Editable fields 1 Editable fields 2 Editable fields 3 Editable fields 4 Editable fields 5 Last Modified - Timestamp Last Modified by - User Stamp Audit -
I would like to create a triggered action that inserts a client's "random ID" onto other tables with the same client's first and last name. I have tried on my my own without success.
-
triggered action to create record in child table
bryscottatx posted a question in Tables, Views and Relationships
i am thinking that this is not possible with triggered actions but i am looking for any alternatives that may be available. i would like to populate a primary key into a new record in a child table so that i can avoid having to use a submission form. ideally i would link to a details report data page from a main page using external parameter and the user would add information for that table. each table is a different part of a process and will not all be completed at the same time so i need a way for them to reference that table even if no data has been added yet. Client Informati