Probably something simple but any assistance would be appreciated.
The code from export function button15_click(event,$w) onwards is giving me some problems and after many days trying to resolve I am at a loss.
The page is an RSVP form for a wedding. An RSVP can have up to 7 individual guests.
When an RSVP is entered the data is returned to the collection, and depending on whether they select Attending or Not Attending they are redirected to either a Thank You page which then triggers a confirmation email to the guest and an RSVP submitted email to the Bride/Groom, or a Sorry page, which provides only a close button which returns them to home page. It only requires 1 guest on the RSVP to select attending to trigger, or all guests on an RSVP to select Not Attending to trigger the respective actions.
The problem I have is if someone has already entered an RSVP with the same email address. When they click the Submit button (button15) the form should clear (this is working) and display a message with instructions on how to change RSVP (this is also working), but it should not send any emails, either confirmation to guest or RSVP submitted to bride/groom, not return the data that was entered to the collection.
It is not returning the data to the collection which is great, but for some reason it is sending both emails.
The invites are going out this weekend so I desperately need to solve this.
I have included the entire page code below for reference.
import wixlocation from 'wix-location'; import wixData from 'wix-data'; export function dropdown1_change(event){ if ($w('#dropdown1').value=== "1"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).collapse(); ($w('#group109')).collapse(); ($w('#group110')).collapse(); ($w('#group111')).collapse(); ($w('#group112')).collapse(); } else if ($w('#dropdown1').value === "2"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).expand(); ($w('#group109')).collapse(); ($w('#group110')).collapse(); ($w('#group111')).collapse(); ($w('#group112')).collapse(); } else if ($w('#dropdown1').value === "3"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).expand(); ($w('#group109')).expand(); ($w('#group110')).collapse(); ($w('#group111')).collapse(); ($w('#group112')).collapse(); } else if ($w('#dropdown1').value === "4"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).expand(); ($w('#group109')).expand(); ($w('#group110')).expand(); ($w('#group111')).collapse(); ($w('#group112')).collapse(); } else if ($w('#dropdown1').value === "5"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).expand(); ($w('#group109')).expand(); ($w('#group110')).expand(); ($w('#group111')).expand(); ($w('#group112')).collapse(); } else if ($w('#dropdown1').value === "6"){ ($w('#text80')).expand(); ($w('#group107')).expand(); ($w('#group108')).expand(); ($w('#group109')).expand(); ($w('#group110')).expand(); ($w('#group111')).expand(); ($w('#group112')).expand(); } else if ($w('#dropdown1').value==="0"){ ($w('#text80')).collapse(); ($w('#group107')).collapse(); ($w('#group108')).collapse(); ($w('#group109')).collapse(); ($w('#group110')).collapse(); ($w('#group111')).collapse(); ($w('#group112')).collapse(); } } import {sendEmail} from 'backend/email'; $w.onReady(function () { }); export function button15_click(event,$w) { wixData.query("YvonneandJosh") .eq("email", $w('#input3').value) .find() .then(res => { if (res.length > 0) { $w('#input1').value="" $w('#input2').value="" $w('#input3').value="" $w('#input4').value="" $w('#input5').value="" $w('#input6').value="" $w('#input7').value="" $w('#input8').value="" $w('#input9').value="" $w('#input10').value="" $w('#input11').value="" $w('#input12').value="" $w('#input13').value="" $w('#input14').value="" $w('#radioGroup1').value="" $w('#radioGroup8').value="" $w('#radioGroup9').value="" $w('#radioGroup10').value="" $w('#radioGroup11').value="" $w('#radioGroup12').value="" $w('#radioGroup13').value="" $w('#textBox1').value="" $w('#textBox3').value="" $w('#textBox4').value="" $w('#textBox5').value="" $w('#textBox6').value="" $w('#textBox8').value="" $w('#textBox9').value="" $w('#textBox10').value="" $w('#textBox11').value="" $w('#textBox12').value="" $w('#textBox13').value="" $w('#textBox14').value="" $w('#textBox15').value="" $w('#group106').expand() } else if ($w('#input15').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#input13').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#input11').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#input9').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#input6').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#input4').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#input1').value !== "") { $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; //use her the alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; //use her the template name you defined in emailJS let myparams = { "Email": $w('#input3').value, "Name1": $w('#input1').value, "Surname1": $w('#input2').value, "Food1": $w('#textBox1').value, "Songs1": $w('#textBox3').value, "Name2": $w('#input4').value, "Surname2": $w('#input5').value, "Food2": $w('#textBox4').value, "Songs2": $w('#textBox10').value, "Name3": $w('#input6').value, "Surname3": $w('#input7').value, "Food3": $w('#textBox5').value, "Songs3": $w('#textBox11').value, "Name4": $w('#input9').value, "Surname4": $w('#input8').value, "Food4": $w('#textBox5').value, "Songs4": $w('#textBox12').value, "Name5": $w('#input11').value, "Surname5": $w('#input10').value, "Food5": $w('#textBox7').value, "Songs5": $w('#textBox13').value, "Name6": $w('#input13').value, "Surname6": $w('#input12').value, "Food6": $w('#textBox8').value, "Songs6": $w('#textBox14').value, "Name7": $w('#input15').value, "Surname7": $w('#input14').value, "Food7": $w('#textBox9').value, "Songs7": $w('#textBox15').value, "Attending1": $w('#radioGroup1').value, "Attending2": $w('#radioGroup8').value, "Attending3": $w('#radioGroup9').value, "Attending4": $w('#radioGroup10').value, "Attending5": $w('#radioGroup11').value, "Attending6": $w('#radioGroup12').value, "Attending7": $w('#radioGroup13').value, }; sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; //use her the template name you defined in emailJS let myparams1 = { "Name1": $w('#input1').value, "Surname1": $w('#input2').value, "Food1": $w('#textBox1').value, "Songs1": $w('#textBox3').value, "Name2": $w('#input4').value, "Surname2": $w('#input5').value, "Food2": $w('#textBox4').value, "Songs2": $w('#textBox10').value, "Name3": $w('#input6').value, "Surname3": $w('#input7').value, "Food3": $w('#textBox5').value, "Songs3": $w('#textBox11').value, "Name4": $w('#input9').value, "Surname4": $w('#input8').value, "Food4": $w('#textBox5').value, "Songs4": $w('#textBox12').value, "Name5": $w('#input11').value, "Surname5": $w('#input10').value, "Food5": $w('#textBox7').value, "Songs5": $w('#textBox13').value, "Name6": $w('#input13').value, "Surname6": $w('#input12').value, "Food6": $w('#textBox8').value, "Songs6": $w('#textBox14').value, "Name7": $w('#input15').value, "Surname7": $w('#input14').value, "Food7": $w('#textBox9').value, "Songs7": $w('#textBox15').value, "Attending1": $w('#radioGroup1').value, "Attending2": $w('#radioGroup8').value, "Attending3": $w('#radioGroup9').value, "Attending4": $w('#radioGroup10').value, "Attending5": $w('#radioGroup11').value, "Attending6": $w('#radioGroup12').value, "Attending7": $w('#radioGroup13').value, "Food": $w('#textBox1').value, "Songs": $w('#textBox3').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#radioGroup1').value === "Attending") ^ ($w('#radioGroup8').value.value === "Attending") ^ ($w('#radioGroup9').value.value === "Attending") ^ ($w('#radioGroup10').value.value === "Attending") ^ ($w('#radioGroup11').value.value === "Attending") ^ ($w('#radioGroup12').value.value === "Attending") ^ ($w('#radioGroup13').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } } export function text150_click(event) { $w('#input1').value="" $w('#input2').value="" $w('#input3').value="" $w('#input4').value="" $w('#input5').value="" $w('#input6').value="" $w('#input7').value="" $w('#input8').value="" $w('#input9').value="" $w('#input10').value="" $w('#input11').value="" $w('#input12').value="" $w('#input13').value="" $w('#input14').value="" $w('#radioGroup1').value="" $w('#radioGroup8').value="" $w('#radioGroup9').value="" $w('#radioGroup10').value="" $w('#radioGroup11').value="" $w('#radioGroup12').value="" $w('#radioGroup13').value="" $w('#textBox1').value="" $w('#textBox3').value="" $w('#textBox4').value="" $w('#textBox5').value="" $w('#textBox6').value="" $w('#textBox8').value="" $w('#textBox9').value="" $w('#textBox10').value="" $w('#textBox11').value="" $w('#textBox12').value="" $w('#textBox13').value="" $w('#textBox14').value="" $w('#textBox15').value="" $w('#group106').collapse(); }
UPDATE - I had the code working (or at least I thought I did), problem is now invites have been sent and people have started to RSVP. Only due to a friend of the bride RSVP'ing this morning, which the bride told me about, did I realise there was a further problem. As it differs from the original I have a created a new post: https://www.wix.com/corvid/forum/community-discussion/code-working-but-only-intermittently-desperate-for-help
Thanks givemeawhisky, I think I need one :)
I have moved the import {sendEmail} and $w.onReady to the top, and some of the code is now working again, however, it is still triggering both the RSVP Confirmation (goes to guest) and the RSVP submitted (goes to bride/groom) emails when the email address already exists in collection.
It should only send these emails when one, or all of the up to 7 guests per RSVP, select "Attending" and the email address used on the RSVP does not already exist in collection. At all other times no emails should be triggered.
I am open to any other suggestions??
import wixlocation from 'wix-location'; import wixData from 'wix-data'; import {sendEmail} from 'backend/email';
$w.onReady(function () { });
export function NoAddGuests_change_1(event){ if ($w('#NoAddGuests').value=== "1"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "2"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "3"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "4"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "5"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "6"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).expand(); } else if ($w('#NoAddGuests').value==="0"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).collapse(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } }
export function btnSubmit_click_1(event,$w) { wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() return; // 5-24-2019 - Since e-mail address was found, they already got an RSVP (don't send another) } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { // Dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { // Dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { // Dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { // Dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { // Dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; // The alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; // The template name you defined in emailJS let myparams = { "Email": $w('#emailaddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; // The template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#Guest1Response').value === "Attending") ^ ($w('#Guest2Response').value.value === "Attending") ^ ($w('#Guest3Response').value.value === "Attending") ^ ($w('#Guest4Response').value.value === "Attending") ^ ($w('#Guest5Response').value.value === "Attending") ^ ($w('#Guest6Response').value.value === "Attending") ^ ($w('#Guest7Response').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } }
export function ClearForm_click(event) { $w('#ErrorMsgGrp').collapse() }
These lines here need to go to the top of your page, imports at the top with the onReady call afterwards.
import {sendEmail} from 'backend/email'; $w.onReady(function () {
onReady( )
Sets the function that runs when all the page elements have finished loading.
https://www.wix.com/corvid/reference/$w.html#onReady
Thanks once again, but alas still not working. It is again the whole page code that isn't working - export function NoAddGuests_change(event) is not working and export function btnSubmit_Click, isn't working either.
I have pasted entire amended page code again for ref.
Should I perhaps wait a few hours and try again?
import wixlocation from 'wix-location'; import wixData from 'wix-data'; export function NoAddGuests_change(event){ if ($w('#NoAddGuests').value=== "1"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).collapse(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "2"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "3"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "4"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "5"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "6"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value==="0"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).expand(); } } import {sendEmail} from 'backend/email'; $w.onReady(function () { });
export function btnSubmit_click(event,$w) { wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() return; // 5-24-2019 - Since e-mail address was found, they already got an RSVP (don't send another) } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { // Dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { // Dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { // Dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { // Dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { // Dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('# Dataset').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; // The alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; // The template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; // The template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#Guest1Response').value === "Attending") ^ ($w('#Guest2Response').value.value === "Attending") ^ ($w('#Guest3Response').value.value === "Attending") ^ ($w('#Guest4Response').value.value === "Attending") ^ ($w('#Guest5Response').value.value === "Attending") ^ ($w('#Guest6Response').value.value === "Attending") ^ ($w('#Guest7Response').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } }
Hi,
I realized that you didn't need that variable at all because the sending of the e-mails can be intercepted more easily:
export function btnSubmit_click(event,$w) { wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() return; // 5-24-2019 - Since e-mail address was found, they already got an RSVP (don't send another) } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { // Dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { // Dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { // Dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { // Dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { // Dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('# Dataset').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; // The alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; // The template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; // The template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); }
In addition, I cleaned up some formatting issues as well as some comments.
Let me know if the above code works for you.
abergquist, latest code below. Thanks so much for looking at this, it really is appreciated.
import wixlocation from 'wix-location'; import wixData from 'wix-data'; export function NoAddGuests_change(event){ if ($w('#NoAddGuests').value=== "1"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).collapse(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "2"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "3"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "4"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "5"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "6"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value==="0"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).expand(); } } import {sendEmail} from 'backend/email'; export function btnSubmit_click(event,$w) { var call_sendEmail = true; // 5-24-2019 wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() call_sendEmail = false; // 5-24-2019 } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { //dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { //dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { //dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { //dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { //dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); // 5-24-2019 - Start if (!call_sendEmail) { return; } // 5-24-2019 - End let myprovider = "gmail"; //use her the alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; //use her the template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, };
sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; //use her the template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#Guest1Response').value === "Attending") ^ ($w('#Guest2Response').value.value === "Attending") ^ ($w('#Guest3Response').value.value === "Attending") ^ ($w('#Guest4Response').value.value === "Attending") ^ ($w('#Guest5Response').value.value === "Attending") ^ ($w('#Guest6Response').value.value === "Attending") ^ ($w('#Guest7Response').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } }
Please post all your latest code.
Thanks.
I have changed sendEmail to call_sendEmail where you introduced it in the code, and that removed the error, however, now none of the code is working on the page at all.
The change event on the NoGuests dropdown is no longer working, and the submit button is no longer working at all either?
Of course, my bad; sendEmail is the name of the method/function so we need to use a different name.
For each occurrence where I that introduced "sendEmail" (look for "5-24-2019"), please replace that occurrence of "sendEmail" with a unique variable name (a mnemonic name would be "call_sendEmail").
Thanks once again abergquist.
I have amended my code as above, however, I am getting an error at var sendEmail = true; 'sendEmail' is already declared in the upper scope.
I have no idea what this means? I have pasted entire page code with your changes FYI. Any ideas what is happening here? I am using emailjs to send the emails and have a backend js file with an export function called sendEmail, so not sure if this is the problem.
import wixlocation from 'wix-location'; import wixData from 'wix-data'; export function NoAddGuests_change(event){ if ($w('#NoAddGuests').value=== "1"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).collapse(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "2"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "3"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "4"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "5"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "6"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value==="0"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).expand(); } } import {sendEmail} from 'backend/email'; export function btnSubmit_click(event,$w) { var sendEmail = true; // 5-24-2019 wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() sendEmail = false; // 5-24-2019 } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { //dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { //dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { //dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { //dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { //dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); // 5-24-2019 - Start if (!sendEmail) { return; } // 5-24-2019 - End let myprovider = "gmail"; //use her the alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; //use her the template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, };
sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; //use her the template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#Guest1Response').value === "Attending") ^ ($w('#Guest2Response').value.value === "Attending") ^ ($w('#Guest3Response').value.value === "Attending") ^ ($w('#Guest4Response').value.value === "Attending") ^ ($w('#Guest5Response').value.value === "Attending") ^ ($w('#Guest6Response').value.value === "Attending") ^ ($w('#Guest7Response').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } }
Hi, vivijones1.
If I'm not mistaken,then I believe that:
res.length > 0
in the following code in the btnSubmit_click function:
.eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) {
is the section where you identify that the e-mail address already exists.
If I'm correct, does replacing the btnSubmit_click function with the following code:
export function btnSubmit_click(event,$w) { var sendEmail = true; // 5-24-2019 wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() sendEmail = false; // 5-24-2019 } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { //dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { //dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { //dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { //dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { //dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; //use her the alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; //use her the template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; // 5-24-2019 - Start if (!sendEmail) { return; } // 5-24-2019 - End sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; //use her the template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); }
resolve the issue for you?
(Search on the text "5-24-2019" to see the exact changes I made to your latest code.)
Thanks abergquist.
I have amended names as suggested, amended code below, unfortunately I still cannot see why the emails are sending if the RSVP email address already exists in collection.
import wixlocation from 'wix-location'; import wixData from 'wix-data';
export function NoAddGuests_change(event){ if ($w('#NoAddGuests').value=== "1"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).collapse(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "2"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).collapse(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "3"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).collapse(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "4"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).collapse(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "5"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).collapse(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value === "6"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).collapse(); } else if ($w('#NoAddGuests').value==="0"){ ($w('#AddGuestsHead')).expand(); ($w('#Guest2Grp')).expand(); ($w('#Guest3Grp')).expand(); ($w('#Guest4Grp')).expand(); ($w('#Guest5Grp')).expand(); ($w('#Guest6Grp')).expand(); ($w('#Guest7Grp')).expand(); } } import {sendEmail} from 'backend/email'; $w.onReady(function () { }); export function btnSubmit_click(event,$w) { wixData.query("YvonneandJosh") .eq("email", $w('#emailaddr').value) .find() .then(res => { if (res.length > 0) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').expand() } else if ($w('#Guest7Name').value !== "") { //dataset 7 for Guest 7 $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") $w('#dataset7').save() console.log("Dataset7 is saving") confirmRSVP(); } else if ($w('#Guest6Name').value !== "") { //dataset 6 for Guest 6 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") $w('#dataset6').save(); console.log("Dataset6 is saving") confirmRSVP(); } else if ($w('#Guest5Name').value !== "") { //dataset 5 for Guest 5 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") $w('#dataset5').save(); console.log("Dataset5 is saving") confirmRSVP(); } else if ($w('#Guest4Name').value !== "") { //dataset 4 for Guest 4 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") $w('#dataset4').save(); console.log("Dataset4 is saving") confirmRSVP(); } else if ($w('#Guest3Name').value !== "") { //dataset 3 for Guest 3 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") $w('#dataset3').save(); console.log("Dataset3 is saving") confirmRSVP(); } else if ($w('#Guest2Name').value !== "") { //dataset 2 for Guest 2 details $w('#dataset1').save(); console.log("Dataset1 is saving") $w('#dataset2').save(); console.log("Dataset2 is saving") confirmRSVP(); } else if ($w('#Guest1Name').value !== "") { //dataset 1 for Guest 1 details $w('#dataset1').save(); console.log("Dataset1 is saving") confirmRSVP(); } }); let myprovider = "gmail"; //use her the alias you used for this service in emailJS let mytemplate = "yjrsvpconfirmation"; //use her the template name you defined in emailJS let myparams = { "Email": $w('#emailAddr').value, "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate, myparams); let mytemplate1 = "yjrsvpsubmitted"; //use her the template name you defined in emailJS let myparams1 = { "Name1": $w('#Guest1Name').value, "Surname1": $w('#Guest1Surname').value, "Food1": $w('#Guest1Food').value, "Songs1": $w('#Guest1Food').value, "Name2": $w('#Guest2Name').value, "Surname2": $w('#Guest2Surname').value, "Food2": $w('#Guest2Food').value, "Songs2": $w('#Guest2Songs').value, "Name3": $w('#Guest3Name').value, "Surname3": $w('#Guest3Surname').value, "Food3": $w('#Guest3Food').value, "Songs3": $w('#Guest3Songs').value, "Name4": $w('#Guest4Name').value, "Surname4": $w('#Guest4Surname').value, "Food4": $w('#Guest4Food').value, "Songs4": $w('#Guest4Songs').value, "Name5": $w('#Guest5Name').value, "Surname5": $w('#Guest5Surname').value, "Food5": $w('#Guest5Food').value, "Songs5": $w('#Guest5Songs').value, "Name6": $w('#Guest6Name').value, "Surname6": $w('#Guest6Surname').value, "Food6": $w('#Guest6Food').value, "Songs6": $w('#Guest6Songs').value, "Name7": $w('#Guest7Name').value, "Surname7": $w('#Guest7Surname').value, "Food7": $w('#Guest7Food').value, "Songs7": $w('#Guest7Songs').value, "Attending1": $w('#Guest1Response').value, "Attending2": $w('#Guest2Response').value, "Attending3": $w('#Guest3Response').value, "Attending4": $w('#Guest4Response').value, "Attending5": $w('#Guest5Response').value, "Attending6": $w('#Guest6Response').value, "Attending7": $w('#Guest7Response').value, }; sendEmail (myprovider, mytemplate1, myparams1); } function confirmRSVP(){ if (($w('#Guest1Response').value === "Attending") ^ ($w('#Guest2Response').value.value === "Attending") ^ ($w('#Guest3Response').value.value === "Attending") ^ ($w('#Guest4Response').value.value === "Attending") ^ ($w('#Guest5Response').value.value === "Attending") ^ ($w('#Guest6Response').value.value === "Attending") ^ ($w('#Guest7Response').value.value === "Attending")) { wixlocation.to("/yvonneandjosh-thankyou"); } else { wixlocation.to("/yvonneandjosh-sorry"); } } export function ClearForm_click(event) { $w('#emailaddr').value="" $w('#Guest1Name').value="" $w('#Guest2Name').value="" $w('#Guest3Name').value="" $w('#Guest4Name').value="" $w('#Guest5Name').value="" $w('#Guest6Name').value="" $w('#Guest7Name').value="" $w('#Guest1Surname').value="" $w('#Guest2Surname').value="" $w('#Guest3Surname').value="" $w('#Guest4Surname').value="" $w('#Guest5Surname').value="" $w('#Guest6Surname').value="" $w('#Guest7Surname').value="" $w('#Guest1Food').value="" $w('#Guest2Food').value="" $w('#Guest3Food').value="" $w('#Guest4Food').value="" $w('#Guest5Food').value="" $w('#Guest6Food').value="" $w('#Guest7Food').value="" $w('#Guest1Songs').value="" $w('#Guest2Songs').value="" $w('#Guest3Songs').value="" $w('#Guest4Songs').value="" $w('#Guest5Songs').value="" $w('#Guest6Songs').value="" $w('#Guest7Songs').value="" $w('#ErrorMsgGrp').collapse() //Add your code for this event here: }
I quickly scanned your code; my first impression is that your code would be a ton easier to read/maintain if you switched generic names like "textBox15" with mnemonic (memory-aiding) names.