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

Question

Question

Wrong field value in the approbation step

asked on August 20, 2014

Hello, I have a form that list product from suppliers to make orders. The fields are the following :

-Supplier

-Product

-Quantity

 

Product and Quantity are both in a collection to add products in the order. My business process also have an approbation step.

Here is the problem, when I want to approve a form, in the "My tasks" part the product field value is right for the first product but not for the other ones that have the same value. The quantity field value is always good.

 

Attachment:

- the "form1.JPG" is the screenshot of the form with good values (without approbation task)

- the "form2.JPG" is the screenshot of the form on the approbation page.

form1.JPG
form2.JPG
form1.JPG (34.05 KB)
form2.JPG (43.54 KB)
0 0

Answer

SELECTED ANSWER
replied on August 20, 2014 Show version history

it may have something to do with it performing a lookup to get the product in that repeatable field. The supplier is not in a collection, so it is not a problem. 

 

Might be a bug for the collections, but have you tried using a table instead?

0 0

Replies

replied on August 20, 2014

Thank for your answer Kenneth,

 

I've just try to replace collection with table, it works perfectly.

0 0
replied on August 22, 2014

Hi Moana, 

 

If your question has been answered, please let us know by clicking the "This answered my question" button on the response.

 

If you still need assistance with this matter, just update this thread. Thanks!

0 0
replied on August 28, 2014 Show version history

Sorry,

 

I thought that it was good, but I just see that is not. I've replace the collection with a table but I still have the same bug. Each line of my form have the same product name even if the product ID is different. But when I just open the form for approbation the good values are displayed less than 1second and then all the product fields take the same value than the first one. So I think that the form values save in DB are good but for an unknown reason that is not what is display.

0 0
replied on August 28, 2014

Moana,

 

Please share with us if you are using any Javascript or CSS. You must have something occurring that is causing the values to reset. Is the lookup based on anything?

0 0
replied on August 28, 2014

can you show us the lookup page? I feel like something you are doing is wrong. I have never run into this issue before.

 

Also, what installed version are you using? 

 

Can you also confirm you are not using any Javascript or CSS? If you are, please tell us/show us what you are doing to the form so we can help. 

 

What you are reporting now to us is that whenever the form is submitted, it keeps the values of the fields that are not a part of a lookup, but the repeatable fields that are part of a lookup are resetting to the first value? Is that right?

0 0
replied on August 29, 2014

I don't use any css/javascript code for this form. The lookup is based on a SQL Server Database.

In my form I have 5 fields 'Supplier', 'Ref', 'Products', 'Quantity UM' and 'Quantity' only the quantity field isn't part of a lookup. Every fields except 'Supplier' are in the table. When I submit my form the only field that reset is the 'product' field. In other words, at the approbation step I have a table with all products for this order, all data are good except the product one.

 

See the attachment: 'form1.jpg' is just before I submit the form and 'form2.jpg' is what I see at the approbation step. All data are good except the product designation.

form1.JPG
form2.JPG
form1.JPG (34.05 KB)
form2.JPG (43.54 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.