I have Validate action step and database insert action sptep
It works great but when the validate condition (does if database exist) is true the actios step is stopped
Why ? @Teodor
I am not sure i understand your question.
What have you set up and what is the issue exactly?
this is my situation:
action steps:
Validation Data Action Step works fine but when it finds a repeated or duplicated email stops !
example:
email1 (inserted correctly)
email2 (inserted correctly)
email3 (inserted correctly)
email2 (not inserted and action step stops)
email4 (not inserted)
email5 (not inserted)
…
ok ?
Well of course it will stop when the value exists in the database … what do you expect to happen?
I would like the Action Step continues inserting the followings emails (ex: email4, email5 …) !
The idea of validate step is to stop processing of the server action if it finds an existing record. Same as your form doesn’t submit if you have validation errors.
What are you trying to achieve?
I want Validate Step to skip to the next email when it finds an existing record
Then don’t use a validation step for this.
In the repeat step add a database query and filter it by email from the API repeat - check if the record equals
the email column of the query.
Then add a condition step and check if query1.length < 1
where query1 is your query name.
Then > Run the insert
Else > Leave empty