Question

Problem Retrieving Forms Content In For Each Row When Variable Has '.' in Name

Workflow Version 9

Updated September 15, 2014

asked on September 12, 2014 • Show version history

I have a Form that when submitted is set to kick off a Workflow. In work there are two 3 activities:

In the "Insert Data" activity, the controlling, development, organization, and conventions values are not inserted into the database when their value is set to the "ForEachStudent" values. Instead it sets the value as 0. If I set them to the "Retrieve Laserfiche Forms Content" values, it populates, but that obviously doesn't iterate through each row.

I have found that the 4 values it does not work with have a "." in their attribute names in Forms. Would that cause the issue?

Workflow Designer: 9.1.1.395

1 0

Replies

replied on September 12, 2014

Based off of my assumption of the "." in the variable name causing the issue, I renamed the variables in Forms to remove the "." and then changed the Workflow values accordingly and it worked. It looks like this is a bug in Workflow.

1 0

View 1 previous reply

replied on September 12, 2014

It does. You can test it for yourself if you create a new field and at the end of the field name put a ".".

1 0

replied on September 12, 2014

You're right, but I guess that's a Forms issue where it does that, I thought this was not the case because when I put '.' in fields, it's usually to number things, so when it's like this: "4. Test" it gives it a variable name "__Test" so I assumed it would do the same thing to all periods.

0 0

replied on September 12, 2014

So I think that either Forms needs to be changed to not allow periods or Workflow needs to be changed to accommodate them.

1 0

replied on September 12, 2014

Blake, if you track the token before inserting it into SQL, does it have the right value?

0 0

replied on September 15, 2014

I enabled tracking of all tokens. I then removed the period from all variables in Forms except for one. After submitting the form I see tokens for all of the "foreachstudent_" tokens except for the one I left the period on. So workflow isn't even tracking it.

1 0

You are not allowed to follow up in this post.

Question

Question

Problem Retrieving Forms Content In For Each Row When Variable Has '.' in Name

Replies

Sign in to reply to this post.