I am trying to limit the amount of time and file transfer size that is used in my modules. Currently each time a webhook fires, it triggers the excel module to list, which adds up on file size and time taken pretty quickly. I want a way to collect all the webhook triggers with their info that arrive within the same minute or 2 to be send through the the scenario together so as to now waste each run on searching through excel. Sometimes there will be 1 set and sometimes 10 sets of info. How can i do that?
You can do that by setting a timed interval schedule on the trigger module instead of having it set to immediately.
samliew – request private consultation
Join the unofficial Make Discord server to chat with us!
3 Likes
Thank you, i figured it out. But the one thing i cant figure out is this:
I would like to search through an excel column (lets day D) for cells that contain “Y”. Then using that row (2), take another cell from another column (lets say E) with the same row (2) that contains a key.
Then using this key, I put it through a data store search and filter by the key to find the data stored, then delete that data store.
I can figure out how to do it, but cannot figure out how to not have to iterate through every row of the excel sheet.
No problem, glad I could help!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
- others can save time when catching up with the latest activity here, and
- allows others to quickly jump to the solution if they come across the same problem
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
4. Do join the unofficial Make Discord server for live chat and video assistance
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!
1 Like