Dec 17, 2022 10:54 AM
Doing a search on "fill in PDF forms", I see that some Airtable users have asked for PDF form features beyond what Airtable currently offers. We have completed a new PDF forms only solution that may help.
Our new solution adds value to fill in PDF forms by making them easy to: upload, fill, save, duplicate, retrieve, sort, combine, email, print, and fill to other forms. It also allows you to invite someone else to help you complete any form. A log automatically keeps track of who makes what changes to each form.
If you or your users need to work with fill in PDF forms, please try our new solution at: https://fillinpdf.com
The site includes a few short videos that demonstrate how to use the software. Currently, it can be used along side Airtable. We are also open to integrating with Airtable. Please let me know your thoughts and suggestions.
Dean Westover, President
Choices Software, Inc.
Dec 18, 2022 11:34 AM
Thank you for sharing information about your product. You state that your service can be used "along side" and that you are "open to integrating with Airtable" Does that mean that currently usage is limited to manually copy/pasting data between the two programs. Do you have a means of automatically generating filled in PDF files without any manual steps, or with at most a single button click? Do you have an API? If you allow for automated document processing, are there limits on the number of documents per month?
Dec 19, 2022 08:19 AM
Kuovonne,
Thank you for your reply. There may be potential for synergism between your Prefilled Form extension and our FillinPDF solution. If interested in discussing, please click the "Contact" link at the top of our website at: https://fillinpdf.com
Dean
Jun 17, 2023 01:12 PM
Hi Kuovonne,
Below is a sample Airtable script that fills a PDF form with data from a table, with a single button click. It is very simple. It merges data based on common field names to a PDF form. The resulting flattened form is automatically emailed. We have extensive experience with PDF forms, but limited experience with Airtable. We welcome your thoughts and suggestions.
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)
Oct 04, 2023 09:29 PM
Do you have documentation on your API?
Oct 05, 2023 05:27 AM
Not at this time. However, I will be glad to attempt to answer any questions you may have.
Thank you for your inquiry.
Westy
Oct 09, 2023 08:29 PM
Thanks for the reply
How do I apply your example to a PDF I get uploaded into FillinPDF.com?
How do I get the url of the PDF?
Is there a way to get a URL of the filled PDF?
Oct 10, 2023 05:59 AM
You do not need the URL for the PDF form. The template name in the above script tells the system how to access the form template.
Alternatively, within FillinPDF.com there is an option to send anyone a link that allows them to fill in a PDF form and submit it for your review. See: https://www.youtube.com/watch?v=PX5C0pmB7s0
However, that is not required for the above script.