My problem is that the code sends emails to the first email in the table, not all emails
export function button11_click(event) {
let rows=$w("#table1").rows;
let i=0;
rows.forEach(function(item,index,rows){
if(item.name){i++;
console.log(item.name+"-"+item.courseName+"-"+item.startDate);
wixData.query("Members/PrivateMembersData")
.eq("loginEmail",item.email)
.find()
.then((results) => {
if(results.length > 0){
let user=results.items[0];
let id=user._id;
triggeredEmails.emailMember("T0Rthcz", id, {
"variables": {
"name": item.name,
"courseName":item.courseName,
"startDate":item.startDate
}
})
.then(() => {
$w("#msg").text="تم ارسال الشهادات بنجاح";
$w("#msg").expand();
$w("#text74").show();
console.log("تم ارسال الشهادات بنجاح");
})
.catch((err) => {
$w("#msg").text="لم يتم ارسال الشهادات "+err+"";
$w("#msg").expand();
$w("#text75").text=err;
$w("#text75").show();
console.log("لم يتم ارسال الشهادات");
});
}
})
.catch((err) => {
console.log(err);
});
}
});
console.log(i);
}
Any help