Related to forms
I have a workflow consisting of three forms: Customer Details, Address, and Health Care Details.
-
Customer Details Form: After filling out this form, I save the information to the customer table via an API call. If this operation is successful, I proceed to the next form. If it fails, I delete the customer entry from the table.
-
Address Form: Upon successful submission of the customer details, I fill out and submit the address form.
-
Health Care Details Form: After successfully submitting the address form, I proceed to the health care details form. However, if an error occurs while saving the health care details to the table (for instance, a failure in the write operation), and no entry is created in the health care details table (which uses the customer ID as a foreign key), I need to delete the previously saved entries in both the customer and address tables to maintain data consistency.
The challenge is that if a node fails during this process, Appian halts further execution, making it difficult to continue the workflow or perform cleanup operations.Any solution to solve this ..?
