Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Storage table overwrites the data in the workflow table #1693

Open
dispatcher0 opened this issue Apr 8, 2024 · 2 comments
Open

Storage table overwrites the data in the workflow table #1693

dispatcher0 opened this issue Apr 8, 2024 · 2 comments

Comments

@dispatcher0
Copy link

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):

  • OS: Windows 10
  • Browser: Chrome
  • Extension Version: 1.28.27

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
Copy link
Author

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
Copy link
Author

dispatcher0 commented Apr 14, 2024

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant