When a student enrolls in our program, we need to collect demographic data from them. We then need to enter this data into a fillable PDF. Is there a way to automate this process?
I was able to create a workflow that uses a Google Doc template to automatically generate a PDF with all the necessary information when a student completes the AppSheet form, which is great. But I’m told we need to provide a PDF that is formatted in a very specific way. It’s not enough to have all of the right info.
Is there a way I can use a fillable PDF file as a template? AppSheet does let me upload the fillable pdf as the template file. But when it generates the PDF, it’s just the blank copy. I’m wondering if I can somehow go into the fillable PDF and tell it what columns to pull from.
I was considering just using an image of the fillable form as a background in the Google Doc and trying that. But the form has a lot of checkboxes, and I don’t know how (or if it’s even possible) to tell AppSheet what box to check.
Thank you!