I have an inventory management app that I am currently working on. Right now I have a set of workflows that trigger an email of a large spreadsheet of data once its all been 100 percent inputted. The email wont fire until all data in the appropriate columns has been entered. I have 4 tables currently, and data can be entered in 2 columns per table. Once all 8 columns of all tables have been filled it will send an email with the entered data and updated pars.
All of this is working completely fine, my issue is this. I would like to reset the data to a zero value in all 8 columns. I know I have to use actions here but if I use set the values of some columns in this row it only changes the first value to zero and none of the other row values. When i try to use, execute an action on a set of rows, and use select statements it just errors out and says its not of type list, and yes I understand its because the column is of data type Number and not list, but there must be a way to do this.
If anyone has any ideas please help because I am super frustrated.