You are viewing limited content. For full access, please sign in.

Question

Question

Update SQL value if Radio Button option 'Y' selected

Workflow
Updated July 23, 2019
asked on July 23, 2019

I have a forms table that displays the RowID of data from a SQL table.  In my form, if I want to update the row data, I select 'Y' from the radio button. 

I want Workflow find the RowID for that Forms row, (in this case 913) and then change the 'Confirmed' value in SQL from 0 to 1 only if a Radio Button option 'Y' has been selected for that given RowID.

 

Can this be done with Workflow?

 

0 0

Answer

SELECTED ANSWER
replied on July 23, 2019

In a Workflow started by the Forms process (Workflow Service Task),

  1. Use Retrieve Business Process Variables to retrieve the table (not the columns, the entire table)
  2. Use a For Each Row to iterate through the table rows
  3. Use a Conditional Sequence (If  For Each Row > Confirmed is "Y", or whatever the actual value is)
  4. Inside of the conditional add an Update Data activity
  5. Use the "RowID" of the Current Row to target the row you want to update
3 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...