Я пытаюсь получить свою пользовательскую форму, чтобы добавить отправленные данные в лист Google, а также отправить подтверждение отправителю и уведомление для себя. Я понимаю, что Forsubmit имеет возможность сделать это, но у меня отключен _captcha для моей формы, потому что этот тип проверки очень недоступен, и мои пользователи отключены визуально или слепые. Поэтому, поскольку у меня отключена безопасность, я не могу использовать их услугу для отправки подтверждения обратно в отправку. PrettyPrint-Override ">function doPost(e) { var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Services");
var data = e.parameter;
var emailAddress = data["Email Address"];
var subject = "Confirmation: Your Request has been Received";
var message = "Hello " + firstName + ",\n\nThank you for submitting a service request. We have received your request and will get back to you shortly.\n\nBest regards,\niAccessAbility";
// Send confirmation email to the user
if (emailAddress) {
try {
MailApp.sendEmail(emailAddress, subject, message);
Logger.log("Email sent to: " + emailAddress);
} catch (error) {
Logger.log("Email sending error: " + error.message);
}
} else {
Logger.log("No email address provided.");
}
// Append form data to submissions sheet
sheet.appendRow([data.Date, data["First Name"], data["Last Name"], data["Phone Number"], data["Email Address"], data.Communication, data.Service]);
// Return success message
return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT);
}< /code>
< /div>
< /div>
< /p>
ниже приведен HTML пользовательская страница формы < /p>
Get to know Leah Dykema, the owner behind iAccessAbility: About Leah Dykema >
Frequently Asked Questions
What services do you provide?
iAccessAbility offers tech support, one-on-one training, and a personalized consultant service keeping in mind your budget and needs. Learn more >
When are you open?
You can contact us at any time and I will get back to you as soon as we can; however, calls are accepted and returned between 10:00 AM and 6:00 PM on weekdays and Saturdays.
How much do you charge for services?
At this time, iAccessAbility services are free since I am a student still learning; however, a set fee will be eventually calculated and posted on the services page.
Я пытаюсь получить свою пользовательскую форму, чтобы добавить отправленные данные в лист Google, а также отправить подтверждение отправителю и уведомление для себя. Я понимаю, что Forsubmit имеет возможность сделать это, но у меня отключен _captcha для моей формы, потому что этот тип проверки очень недоступен, и мои пользователи отключены визуально или слепые. Поэтому, поскольку у меня отключена безопасность, я не могу использовать их услугу для отправки подтверждения обратно в отправку. PrettyPrint-Override ">function doPost(e) {[b] var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Services"); var data = e.parameter;
var emailAddress = data["Email Address"]; var subject = "Confirmation: Your Request has been Received"; var message = "Hello " + firstName + ",\n\nThank you for submitting a service request. We have received your request and will get back to you shortly.\n\nBest regards,\niAccessAbility";
// Send confirmation email to the user if (emailAddress) { try { MailApp.sendEmail(emailAddress, subject, message); Logger.log("Email sent to: " + emailAddress); } catch (error) { Logger.log("Email sending error: " + error.message); } } else { Logger.log("No email address provided."); }
// Append form data to submissions sheet sheet.appendRow([data.Date, data["First Name"], data["Last Name"], data["Phone Number"], data["Email Address"], data.Communication, data.Service]); // Return success message return ContentService.createTextOutput("Success").setMimeType(ContentService.MimeType.TEXT); }< /code> < /div> < /div> < /p> ниже приведен HTML пользовательская страница формы < /p>
Get to Know the Site! Checkout some of the iAccessAbility's other pages: News and Events[/b][b]
Stay up to date with what iAccessAbility is doing! [url=html/news.html]Events and News Updates >[/url] Recommendations[/b][b]
Get links to apps, services , and products I use: [url=html/recommendations.html]Recommendations - iAccessAbility >[/url] Behind the Vision[/b][b]
Get to know Leah Dykema, the owner behind iAccessAbility: [url=html/about.html]About Leah Dykema >[/url]
Frequently Asked Questions
What services do you provide?[/b][b]
iAccessAbility offers tech support, one-on-one training, and a personalized consultant service keeping in mind your budget and needs. [url=html/service.html]Learn more >[/url]
When are you open?[/b][b]
You can contact us at any time and I will get back to you as soon as we can; however, calls are accepted and returned between 10:00 AM and 6:00 PM on weekdays and Saturdays.
How much do you charge for services?[/b]
At this time, iAccessAbility services are free since I am a student still learning; however, a set fee will be eventually calculated and posted on the services page.
Мобильная версия
