I am looking for a way to update a CDT field after each step of a process.
I am building a recruiting process. After each user task in the process model I would like to update the candidate CDT and write that to the datastore. However when I try to do so, I end up creating a new line (a new candidate everytime). But actually I just want to update the existing candidate.
It should work something like this:
After the phone interview:
After the OnSite interview:
I do have a running application, but it uses a workarround. In addition to the candidate CDT I am using a phoneInterview and a onSite CDT. Both CDTs have a foreign key candidateId.
How, can I achieve the same only using the candidate CDT? Thanks.
Best regards Karl
Discussion posts and replies are publicly visible
Please validate if you're collecting properly the candidateId field. I assume that field is your database primary key. That field must have the correct value before executing the Write To Data Store Entity. If that value in your CDT is empty, it will create a new row in your database. If the value of that field is an existing Id in your database, it will update that particular row.
I suggest you run your Process Model in Debug Mode in order to validate if your CDT has the correct value in it.
© 2021 Appian. All rights reserved.