Hello!
Lets say I have a table of products or something like that:
| Product | Price |
|---|---|
| Butter | 2 |
| Bread | 1 |
| Milk | 1 |
I want to have a view in Workshop where a user can update inventory, changing products and process accordingly. Imagine to something like
| Product | Price |
|---|---|
| Bread | 1.5 |
| Juice | 2 |
A Action Table seems the obvious solution, but you cant really remove existing rows, so what would happen is that maybe I can edit the Bread but the output would include the Milk and Butter objects.
I thought that the solution I could do is maybe delete all existing objects and create the new ones on submission, essentially replacing the table. But sequential actions do not seem doable in workshop, or even passing an hidden object set to delete the whole thing because that would be the same object set per row and that is not allowed either.
I guess my question is: how will I handle this use case? Seems like a pretty conventional workflow, but I can’t wrap my head around how to get around the limitations in place…
I even tried a really creative workflow where I created a variable that would be calculated after form submission and it was backed by a function that just deleted the old product list (every submission would NOT edit existing products, just create a copy)…but that does not work either 