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

Question

Question

Values not passing through from Forms to Workflow

asked on December 18, 2018

Here is the table pre-populated from the database:

When Workflow is iterating through the rows on a 'For Each Row'

The MatUnit which is the ACRE and EACH dropdown is empty:

 

Does Workflow not allow values to be passed through from dropdown if populated by a SQL Lookup?

0 0

Answer

SELECTED ANSWER
replied on December 20, 2018

That has to be the issue. I actually posted on this because it appears to be a bug. If any of the rows have that column hidden, it will ignore all of the values.

https://answers.laserfiche.com/questions/152879/Possible-Bug-Forms-not-saving-values-when-a-column-is-hidden-on-other-rows

1 0

Replies

replied on December 19, 2018

How are the dropdowns configured? I have dropdowns that are populated with lookups and the values can be retrieved by workflow, but the user takes action at some point so that might be the missing piece of the puzzle.

Do the users interact with your dropdowns at all?

0 0
replied on December 20, 2018

 

This is the configuration for the drop down.

It is pre-populated from a stored procedure and I have all the possible values within the Drop Down as well so the use may select another option if they desire. 

 

I simply wish to take the value at submission and I'm not sure why workflow is receiving a blank value for it.

0 0
replied on December 20, 2018

My follow up question is, who is setting the "ACRE" or "EACH" values? Does the procedure populate the list, then the user selects it, or is something else happening?

You don't have "append choices to lookup results" selected, so if the lookup is working correctly it is going to wipe out those values and they won't be able to pick them anyway.

0 0
replied on December 20, 2018

The Stored Procedure is pre-populated it like stated.

It does look to work as intended for that:

Here is the table pre-populated from my stored procedure.  When selected the drop down, all of the options are available for the user to select a different value.

 

Here's a section of the results from the stored procedure within SQL Studio:

 

0 0
replied on December 20, 2018

The reason I asked is that I needed to know if the Stored Procedure was providing a list of values, or one specific value, because it makes a big difference in the form's behavior.

I don't really see any reason why the values would not be saved. Can you try the following to help narrow things down?

  1. Start a new submission
  2. After the data is populated, change one of the drop downs manually.
  3. Submit the form
  4. See if it saved the value you changed manually

The results will help determine where things are going wrong.

0 0
replied on December 20, 2018

I re-ran and manually selected another option for the 2 Step Hydroseeding as seen above.

 

It still is not passing the MatUnit value through to the Workflow.

Here is the Form submitted.

The form when submitted is not holding the values as well.

 

I think at this point I will delete and recreate the field and see if that helps.

0 0
replied on December 20, 2018

Let me know if that helps. I'm honestly stumped. Do you by any chance have field rules that hide that column under certain conditions?

0 0
replied on December 20, 2018

Sorry I should have shown the correct part of the submitted form.  

And yes it does:

The condition should ignore values if the field is hidden.  And it should be shown when the value is Material which it does.

I have tested as well with changing the Ignore to Save hidden data and it still has the same result.

0 0
SELECTED ANSWER
replied on December 20, 2018

That has to be the issue. I actually posted on this because it appears to be a bug. If any of the rows have that column hidden, it will ignore all of the values.

https://answers.laserfiche.com/questions/152879/Possible-Bug-Forms-not-saving-values-when-a-column-is-hidden-on-other-rows

1 0
replied on December 20, 2018

I tested it removing the field rule completely and it does in fact hold all the values.

I would have liked it to only care about the fields where that field is needed.

Quick solution I feel would be to split the results up within two separate tables.

0 0
replied on December 20, 2018

Yup.  Thanks for going through that with me.  I will keep an eye on updates or what 10.4 may fix for us.

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

Sign in to reply to this post.