The below Airtable script fills data to a PDF form and automatically emails the flattened PDF form, with one click. This solution is in beta. Anyone can try it now. We welcome all thoughts and suggestions. See below script, and two screenshots.
Dean Westover, President
Choices Software, Inc.
// INSTRUCTIONS
// This is a sample script that fills Airtable data to a PDF form and emails the form
// 1. create table named "Contacts"
// 2. create three columns named "Contact", "Email", and "Comments"
// 3. create fourth column of type button, named "Button" and labeled "FillinPDF"
// 4. paste this entire script as the action for the "FillinPDF" button
// 5. click "FillinPDF" button to email filled PDF form to address in the "Email" column
let table = base.getTable("Contacts");
let record = await input.recordAsync('Select a record to use', table);
let username = "choices@acords.com";let password = "7Yiz3qNu"; // do not change
let username_and_password_encoded = btoa(username + ":" + password);
let obj = {
company: "Airtable", // do not change
template: "Sample PDF Form", // do not change
mailTo: record.getCellValue("Email"), // do not change
description: "Attached is filled form", // email subject
data: { // Airtable data
Contact: record.getCellValue("Contact"),
Email: record.getCellValue("Email"),
Comments: record.getCellValue("Comments")
}
}
let url = 'https://formstable-dev.choices.servoy-cloud.eu/servoy-service/rest_ws/formsTableWS/emailNewForm'
let response = await remoteFetchAsync(url, {
headers: {
"Content-Type": "application/json",
"Authorization": "Basic " + username_and_password_encoded
},
body: JSON.stringify(obj),
method: "POST"
})
console.log(response)
