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

Question

Question

deleted rows in table in form 1 showing on the table on form 2

asked on November 12, 2019

Why the rows deleted in form 1 showing in the table in form 2? I have 2 forms that uses the same table variables. When I deleted rows from the form 1 it will shows in table in form 2.

0 0

Replies

replied on November 13, 2019

1 0
replied on November 12, 2019

Can you provide more information about what you are doing? Possibly include some screenshots of what's happening using fake data. 

How is the table populated? If it's populated by a lookup, is the lookup running again on the second form? 

6.3.6
0 0
replied on November 14, 2019

No lookup use here

0 0
replied on November 12, 2019

Form 1 Review. 3 rows

Form 2.  I Remove 2 rows to only have 1 row

Form 3 Final Review. The 2 rows from form 1 is now back on this form

 

0 0
replied on November 18, 2019

Hi Maxwell,

    I created a similar process based on the screenshots attached, to reproduce the issue, I need to have different number of columns in the table on form 1, form 2 and form 3:  there are more columns in table on form 1 than form 2, for example, 3 columns on form 1, then 2 columns on form 2 when rows are deleted, then on form 3, it will show the rows deleted in form 2 as the columns not displayed on form 2 still have values. 

   Please confirm whether your process have same situation: the table in Form 1 has more columns than table in Form 2, you can change Form 1 and Form 2 to have same columns in the table to avoid this issue, you can add column from the variable to add the missing columns on Form 2:

0 0
replied on November 18, 2019

What we think is happening is you are filling out many columns in the first form, then only showing a few of those columns in form 2. When you are deleting rows in form 2, it's only deleting the visible data (the rest of the columns that aren't showing up still have their data). Then in form 3, the rows are added back because there is still data from those hidden columns. 

Can you confirm that's the case? 

0 0
replied on November 18, 2019

I added the columns to match the column between forms (1,2 and 3) to have the same columns. But I still get the same result. 

0 0
replied on November 18, 2019 Show version history

So all the columns show up on the first form and the second form? You fill out 3 rows of the table on form 1, you delete some of those rows in form 2, and they STILL show up as blank on form 3? 

If the table you're deleting from on form 2 has all the columns, it should be removing those rows for good. We recreated the issue in the case where form 1 shows many columns, but form 2 has fewer columns. 

We are planning to fix this issue by removing the whole the row in form 2 even if not all the columns are showing. 

0 0
replied on November 18, 2019

So I made the table on all forms to have the same columns. First form is the entry form where you can add multiple items(rows). Second Form is the review form where items(rows) can be deleted. Third Form is the final review Form where it shows the items(rows) from the First Form even if the items(rows) was deleted in the Second Form.

 

0 0
replied on November 18, 2019

Are all the variables inside the table added to all the three forms? Can you open one instance that you got same result after add the columns to match between the forms and check the variables values for the columns, we need you to confirm whether there is a column in the table that have more sets of value than other columns as following.

If you still can reproduce the issue with all forms to have same columns, please open a support case with your VAR and provide following information:

1. exported process

2. video to demonstrate the issue

3. screenshots for the variables values in the table for an instance that reproduce this issue.

 

0 0
replied on November 20, 2019

All Forms do have the same number of column and same variables. but I forgot to mention that the 1st and 2nd forms are coming from a sub process and I'm not sure if this makes a difference.

0 0
replied on December 1, 2019

Hi Maxwell, 

    I checked with the 1st and 2nd forms from a sub process, I can't reproduce if they have same number of columns and variables. Can you please open a support case with the information I requested as the workaround not work for you? We want to check with your process to see whether there are other settings caused the issue.

0 0
replied on December 2, 2019

Hello, I think the issue is something to do with the dollar amount defaulting to "0.00". I do have a work around on this issue. I am now saving the data to a SQL database from the 2nd form and then read the data on to the 3rd form.

0 0
replied on December 5, 2019

Hi Maxwell,

     I tried to mimic the situation to set the default value of the currency fields with default value "0.00" and used similar fields as your screenshots, but I still can't reproduce it, it will be great if you can open a support case with your process and we will figure out the root cause and fix it in the product. 

0 0
replied on December 5, 2019

Hello,

Have you tried adding a formula in the Total field?

 

Thanks,

Max

0 0
replied on December 9, 2019

I tried set the formula for the Total field in the three form to "=SUM(INDEX(Table.Sub_Tot,ROW()),INDEX(Table.Tax,ROW()),INDEX(Table.Shipping,ROW()))", but I still can't reproduce it. It will be great if you can open a support case with your VAR and provide the exported process that can reproduce this issue, we will check the root cause. 

0 0
replied on December 9, 2019

How do I open a support case?

0 0
replied on December 9, 2019

Contact your VAR

0 0
replied on November 12, 2019

What version of Forms are you on so we can test it? 

6.3.6
0 0
replied on November 14, 2019

10.3.1.533

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

Sign in to reply to this post.