Lookup not removing rows

asked on February 10, 2020

Sorry, this may be long

I have a forms that is doing finance distributions. It's not really possible to do in Forms so I am doing the calculations in SQL/Workflow and then displaying them on the form.

I have two tables on a Form. One is for distributions, the other is for normal line item entry. If they don't have distributions they click a radio and start keying.

If they want to do distributions, they click a radio and enter into the below table. Users can add as many distributions as they want (just two in this example).

So distribute 100 to FDM Janitor and 100 to FDM BLDG Supply. Then there is a Submit

Workflow does queries and calculations and then writes them to a SQL table. The same line item table above has a lookup rule to that temp table and shows the items. The next form loads and shows them the below table. This is a different form but the same table variable.

They have the ability to send it back in case they want to redo the distributions or change their mind and not do distributions. If they choose to send it back, I have a workflow cleaning the temp database for that invoice, bringing them back to the original form. However, the lookup info is still showing in the table despite the temp table being cleared. If I re-trigger the lookup (that's another problem from this one is to trigger the lookup again on form load) on the form the table clears (as it should since the temp table is empty) but it is leaving the rows...

The table setting is for "Append rows to the rows populated by a data source" with a 0-100 min/max as the users need to add line rows even with distributions.

Whats odd is that I can simply Preview the form, key in my lookup criteria, and watch the table populate and de-populate (rows removing). However if the form as been in a process it seems to leave the empty rows and I am not certain how to get it work.

I'd appreciate any insight if anyone can offer it. I know the table is showing the old data since I have not re-triggered the lookup. However, when I do re-trigger it is seems to leave the rows.

Thanks,

Chris

0 0

replied on March 11, 2021

I'm hoping you found an answer to this question.

I have something sort of similar. When you choose a value from a dropdown it displays rows in a table that correspond to the dropdown. I choose a value, a lookup is triggered and its 5 corresponding rows of data show in a table. I choose a different value from the dropdown and it shows 2 rows of data and 3 rows of fields without data (5 total from the previous 5 rows of data).

I'd like to find a way to remove the rows that do not have data.

0 0

replied on March 15, 2021

I don't have access to the process anymore but because Forms cant handle it all of the removal and items had to be triggered and updated with javascript unfortunately.

0 0

Question

Question

Replies

Sign in to reply to this post.