Skip to main content
Nintex Community Menu Bar

Smartform method did not update a field in workflow

  • May 24, 2022
  • 3 replies
  • 16 views
K
Forum|alt.badge.img+3

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

1 Attachments

    3 replies

    T
    Forum|alt.badge.img+15
    • tbyrne777
    • Scholar
    • May 24, 2022
    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?
    K
    Forum|alt.badge.img+3
    • KimL
    • Author
    • Rookie
    • May 24, 2022

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

     

     

     

    T
    Forum|alt.badge.img+15
    • tbyrne777
    • Scholar
    • May 24, 2022
    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
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement