# Tax Request
{% code title="tax\_request" overflow="wrap" lineNumbers="true" %}
```javascript
function sendEmail(e) {
var sheetName = e.range.getSheet().getName();
var submitterEmail = e.values[1]; // Adjust according to the actual position of the email in the form responses
if(sheetName === "Tax Request") {
var itemValues = e.namedValues;
var subject = "Faktur Pajak Request - "+ itemValues["Contact Name"]?.[0] +" - "+ itemValues["Company Name"]?.[0]; // Using optional chaining
var emailBody = `
Hi ${itemValues["Contact Name"]?.[0]},
Thank you for filling out the form. Here are the details of your inquiry:
| Field | Detail |
|---|
| Company Name | ${itemValues["Company Name"]?.[0]} |
| Company Address | ${itemValues["Company Address"]?.[0]} |
| Tax Identification Number (NPWP) | ${itemValues["Tax Identification Number (NPWP)"]?.[0]} |
| Company Phone Number | ${itemValues["Company Phone Number "]?.[0]} |
| KYZN Branch | ${itemValues["KYZN Branch"]?.[0]} |
| Invoice Number | ${itemValues["Invoice Number"]?.[0]} |
| Transaction Date | ${itemValues["Transaction Date"]?.[0]} |
| Description of Services | ${itemValues["Description of Services"]?.[0]} |
| Contact Name | ${itemValues["Contact Name"]?.[0]} |
| Position | ${itemValues["Position"]?.[0]} |
| Contact Phone Number | ${itemValues["Contact Phone Number"]?.[0]} |
Our Finance Team will review your inquiry and provide feedback within 7 business days or before the 15th of each month. If you have any questions, please contact us at +62851-7442-0088 (Whatsapp Only).
Regards,
KYZN Team
`;
// When sending the email, specify the htmlBody parameter with the content above
MailApp.sendEmail({
to: submitterEmail,
subject: subject,
cc:"hi@kyzn.life,ca@kyzn.life, fc@kyzn.life, finance@kyzn.life",
name: "KYZN Information Center",
htmlBody: emailBody, // Ensure this is used instead of body parameter for HTML content
});
}
}
function onEdit(e) {
var range = e.range;
var sheet = range.getSheet();
var sheetName = sheet.getName();
var editedRow = range.getRow();
var editedColumn = range.getColumn();
var statusColumn = 14; // Column N
var fileLinkColumn = 15; // Column O
if(sheetName === "Tax Request" && editedColumn === statusColumn) {
var status = sheet.getRange(editedRow, statusColumn).getValue();
var fileLink = sheet.getRange(editedRow, fileLinkColumn).getValue();
var submitterEmail = sheet.getRange(editedRow, 2).getValue(); // Assuming email is in Column B
var companyName = sheet.getRange(editedRow, 3).getValue(); // Adjust according to the actual position
var contactName = sheet.getRange(editedRow, 11).getValue(); // Adjust according to the actual position
if(status === "Done" && fileLink) {
var subject = "Faktur Pajak Request - "+contactName+" - "+companyName; // Using optional chaining
var emailBody = // Use the HTML content from above, replacing placeholders with actual values
`
Hi ${contactName}!,
We are pleased to inform you that your request for Faktur Pajak has been processed successfully. Thank you for your patience throughout this period.
Your Faktur Pajak is now available and can be accessed through the link below:
Access Your Faktur Pajak
Should you need any further assistance or have any questions, please feel free to get in touch with us via +62851-7442-0088 (Whatsapp Only).
We appreciate your cooperation and look forward to serving you again.
Best Regards,
KYZN Finance Team
`;
MailApp.sendEmail({
to: submitterEmail,
subject: subject,
cc:"hi@kyzn.life,ca@kyzn.life, fc@kyzn.life, finance@kyzn.life",
name: "KYZN Information Center",
htmlBody: emailBody,
});
}
}
}
```
{% endcode %}
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://work.bahrul.me/work/kyzn/sops-and-flow/tax-request.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.