on click script in stateless form returns an error
Hello,
I am developing two stateless forms to insert data into a main form. All I have is an insert code, an alert, a sendmail, and a reload. When I test the form I get the following error.
Error details: Error occured while executing on click script. Error occured. (this is what I get when I'm logged in as admin)
If I'm logged out, I get 'A problem has occurred, contact the administrator'
The form I'm referring to here is "Group Registration S", which inserts into "ROOT Registration Form".
I have tried using both the submit button and custom button, I tried removing everything but the insert code, and I still get this error. My app is shared to support, I would greatly appreciate some assistance with this, thanks.
Why does Zoho Creator automatically keep adding this, Added_User = zoho.loginuser, into my insert code? This form is public, so there is no adding of any users, nor is the person submitting a logged in user. I have already tried changing loginuser to adminuser and nothing, I still get the error. I'm thinking this is the cause. If I delete it and save the script, it reappears.
My on click action script is as follows:
- insert into registration
[
Added_User = zoho.loginuser
Address = input.Address
City = input.City
City2 = input.City2
ContactEmail = input.ContactEmail
ContactPerson = input.ContactPerson
ContactPerson2 = input.ContactPerson2
ContactPhones = input.ContactPhones
Country2 = input.Country2
Date_field = input.Date_field
DayTime = input.DayTime
Do_Not_Publish = input.Do_Not_Publish
email = input.email
ExistID = input.ExistID
format = input.format
GroupCountry = input.GroupCountry
GroupName = input.GroupName
IntergroupSelect = input.IntergroupSelect
IntergroupStatus = input.IntergroupStatus
Languages2 = input.Languages2
Location = input.Location
MeetingDay = input.MeetingDay
PhoneNumbers = input.PhoneNumbers
PhoneNumbers2 = input.PhoneNumbers2
PostalCode = input.PostalCode
PostalCode2 = input.PostalCode2
PrimaryEmail = input.PrimaryEmail
PrimaryEmail2 = input.PrimaryEmail2
RegStatus = input.RegStatus
StateProvince = input.StateProvince
StateProvince2 = input.StateProvince2
StateSelect = input.StateSelect
StreetAddressPOBox2 = input.StreetAddressPOBox2
verify = input.verify
WebsiteAddresses = input.WebsiteAddresses
]
sendmail
(
To : input.email
From : zoho.adminuserid
BCC : "register@slaafws.org"
Subject : "S.L.A.A. Group Registration Received"
Message : "Hello " + input.GroupName + ",<br />\n<br />\nWe have received your S.L.A.A. Group Registration Form. Your information will be processed and you will receive another confirmation email containing your Registration ID number. <br />\n<br />\nThank you for your service,<br />\nS.L.A.A. Fellowship-Wide Services<br />\n<br />\n<b>Submitted Data:</b><br />\n<br />\n<b>Meeting Information and Location</b><br />\nGroup Name: " + input.GroupName + "<br />\nMeeting Day: " + input.MeetingDay + "<br />\nMeeting Time: " + input.DayTime + "<br />\nMeeting Format: " + input.format + "<br />\nLanguage: " + input.Languages2 + "<br />\n<br />\n<b>Group Contacts</b><br />\nContact Email: " + input.ContactEmail + "<br />\nContact Phone: " + input.ContactPhones + "<br />\nWebsite: " + input.WebsiteAddresses + "<br />\nIntergroup Membership: " + input.IntergroupStatus + "<br />\nYour Intergroup (if any): " + input.IntergroupSelect + "<br />\n<br />\n<b>Group Location</b> <strong>Information</strong><br />\nGroup Location: " + input.Location + "<br />\nAddress: " + input.Address + "<br />\nCity: " + input.City + "<br />\nState/Province (other): " + input.StateProvince + "<br />\nState/Province: " + input.StateSelect + "<br />\nPostal Code: " + input.PostalCode + "<br />\nCountry: " + input.GroupCountry + "<br />\n<br />\n<b>Group Contact Person</b> (Confidential)<br />\nContact Name: " + input.ContactPerson + "<br />\nEmail: " + input.PrimaryEmail + "<br />\nPhone: " + input.PhoneNumbers + "<br />\nStreet Address: " + input.StreetAddressPOBox2 + "<br />\nCity: " + input.City2 + "<br />\nState/Province: " + input.StateProvince2 + "<br />\nPostal Code: " + input.PostalCode2 + "<br />\nCountry: " + input.Country2 + "<br />\nDo Not Publish: " + input.Do_Not_Publish + "<br />\n<br />\n<b>Alternate Contact Person</b> (Confidential)<br />\nAlternate Contact Name: " + input.ContactPerson2 + "<br />\nAlternate Email: " + input.PrimaryEmail2 + "<br />\nGAlternate Phone: " + input.PhoneNumbers2 + "<br />\n<br />\nGroup Start Date: " + input.Date_field + "<br />\nExisting Registration ID (if any): " + input.ExistID + "<br />\nConfirmation Email Address: " + input.email + "<br />\nShould we have any questions, we will contact you at this address."
)
alert("Group Registration Successful!");
reload;