Hi, I am trying to create a task list for each of my projects. However, the tasks are dependant on the type of project which is listed in column in the projcects table. I then have a global tasks table that houses all of the potential tasks.
I was hoping to make use of the loops funtions to loop over each task and check what type it is, if it matches the project type then it would add it to the project task list. However, I can see that loops won’t work from an app intereaction, I was hoping to trigger it from a button. I could trigger it on a scheudle, however, I wanted to ask if there was another way to do this, other than using the API which I’ve done before?
I don’t think you need an email trigger here, you need a webhook trigger.
Do a trigger webhook or call API step tied to your app-interaction button. Send over the project ID and the project “type”.
Then, in the webhook trigger, loop through your global tasks table, filter those that have the same project type as the type that is sent through webhook, and add them to your tasks table.
Yes, you are right, that is also an option. However, the API is only available on the BUSINESS plan, so I was considering using EMAIL to trigger a WEBHOOK as the best solution that would work on any paid plan.
If you have access to an email trigger, you also have access to a webhook trigger, which would be a much better option. Using an email trigger only makes sense if someone is sending an email externally to Glide and you want to do something when that email is received. A webhook trigger makes a hole lot more sense in this case.
I am looking for some additional help here if possible. I’ve now set this up and it’s working well when I have 1 channel listed. I can then loop through the items and create a task list.
However, I’m not sure how to do this when I have multiple channels in the JSON.
