Search the Community

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.

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 Log Summary Table: Summary ID (Primary Key) Accession ID(Foreign Key from Orders) Modified by User Modified Date Change Type (I, U, D) Audit Log Details Table: Audit Log Detail ID (Primary Key) Summary ID (Foreign Key from Summary Table) Column Name( Field that changed in orders table) Old Value New Value I know how to create the trigger to insert Accession ID, Modified by User, and Modified Date into Summary table upon Insert, Update, or Delete. I'm not certain how to stamp the change type field - based on Insert, Update or Delete. What I'm really struggling with is next step. For each event, how do I identify Fields that changed, and insert changes into details table? An would I be nesting this into original trigger in Orders table, or creating a new trigger in Summary Table? Pasting 1st part of trigger for reference. Any help or guidance greatly appreciated...

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.

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 Information (Parent Table), Workflow Table 1(Child Table, Workflow Table 2(Child Table)...