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.
Question
Question
Replies
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?
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
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:
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?
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.
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.
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.
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.
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.
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.
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.
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.
Hello,
Have you tried adding a formula in the Total field?
Thanks,
Max
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.
How do I open a support case?
Contact your VAR