search

AutomaApp / automa

A browser extension for automating your browser by connecting blocks
https://www.automa.site
Other
10.73k stars 1.09k forks source link

Storage table overwrites the data in the workflow table #1693

Open dispatcher0 opened 2 months ago

dispatcher0 commented 2 months ago

Describe the bug As it was initially not possible to use the storage table and workflow table in the same workflow, I wrote another workflow and connected it to the storage table. Then in my main workflow, I used the Execute Workflow block (IMPORTANT Use all current workflow globalData & Use all current workflow variables were NOT selected). So, all the necessary data is correctly added to my main workflow table but just after running the Execute Workflow block the table data disappears and becomes overwritten by Storage table data. In the end, I have the same data both in the Storage table and workflow table from the incorporated workflow and no data from the main one. My goal: collect the necessary data in main workflow table and export it to Gsheet, some technical data I need to export to Storage table to refer it every next workflow execution and to avoid exceeding quotas from GSheets.

To Reproduce Steps to reproduce the behavior:

  1. Create new workflow (main one)

  2. Create column in workflow table

  3. Add 5 Insert data blocks with some data to the workflow table

  4. Create another workfow "2" and connect it to the storage table

  5. Create column in Storage table

  6. Add 5 Insert data blocks with some different data to the Storage table

  7. Run both workflows and see that everything works fine

  8. Add Execute Workflow block to the main workflow with the reference to workflow "2" and make the block disabled

  9. Run the main workflow and everything is ok, the inserted data from main workflow is in the table

  10. Enable Execute Workflow block and see the bug: no inserted data from main workflow in the workflow table and all data from the Storage table appears in the workflow table.

Expected behavior Execute Workflow block starts "2" workflow and all data is added only to Storage table. All data from the main workflow remains in its place

Screenshots If applicable, add screenshots to help explain your problem. image image image image

Desktop (please complete the following information):

Additional context I really do not want to use another GSheet because of reading and writing quotas. My workflows will run every minute with huge amount of data and to use Gsheet I will be forced to add delays to neglect the quotas. It will lead to execution every 3-4 minutes instead of every minute...

dispatcher0 commented 2 months ago

Solution So there is the solution I have found for myself, and it solves my tasks. Anyway, all the necessary data I will have in my GSheet but not be visible in the workflow table in the logs (again, another workflow overwrites the workflow table with the storage table). While editing the workflow it is necessary to disable the Execute Workflow block and Delete Data block and check if it runs correctly.

dispatcher0 commented 2 months ago

And one more problem. When I use the Execute Workflow block, variables from another workflow ARE VISIBLE among variables in the logs of the main workflow but cannot be used (Error Can't find "check" variable). I expect to run the small workflow within the main one but unfortunately seems like variables from it cannot be used further((( We only can use variables from the current workflow to run another one but not in the opposite way.