KimL
Novice

Smartform method did not update a field in workflow

In the workflow I use Smartobject method to update data in a table.  We update 6 fields. One of the field is statusid. In the Input Mappings, I set statusid = 6

 

Sometimes, the workflow does not update statusid. Other fields are updated.

Does anyone know why it updates other field, but not statusid ?

Thanks in advance, 

Kim

Labels: (1)
0 Kudos
Reply
3 Replies
tbyrne777
Contributor

Re: Smartform method did not update a field in workflow

You say that sometimes it does not update statusid... what other variables are involved? That is, can you determine anything different about when it does work vs. when it doesn't? Is there any consistency at all or it seems random?
Secondly, is the underlying table a smartbox table or a database you've created?
0 Kudos
Reply
KimL
Novice

Re: Smartform method did not update a field in workflow

 We just set the statusid = 6. Other data is from variables in the workflow. It seems random.

 

KimL_0-1653418024180.png

 

 

0 Kudos
Reply
tbyrne777
Contributor

Re: Smartform method did not update a field in workflow

Hmm... maybe try putting an update trigger on that table (if it is a table you control) that writes a record to a different table that says what it *thinks* is being updated? I see nothing that would cause concern from your screenshot, so we need to go a level deeper to see what is actually reaching the database
0 Kudos
Reply