BijanBorazjani
New Member
- Joined
- Oct 22, 2021
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
I am using JotForms for data collection of names addresses and a short response. I am able to export those responses to a CSV or XLSX. I need to be able to take the responses exported and import it to a Fillable PDF form that was created. I was thinking the only way to do this easily is using an XML import/Export. The main issue i am having is that the number of responses will vary depending on each event. I need a way to be able to populate the PDF continuously and create a new sheet until all entries are in the PDF. I have attached the PDF Form, the XML, and the XLSX Export from Jot Forms. Any help would be greatly appreciated.
General_Inquiry_Contact_Form2024-01-08_10_36_38.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | First Name | Last Name | Street Address | City | State / Province | Postal / Zip Code | Condolence Message | |||
2 | Tim | Smith | 123 Sesame Street | New York City | NY | 12345 | Tim.Smith@Gmail.com | Im Sorry | ||
3 | Doug | Manning | 234 Ask Blvd | Beverly Hills | CA | 90210 | Amy@gmail.com | Hkajehjr | ||
4 | Crisp E | Bacon | 456 Pickup Ln | Lafayette | LA | 70518 | Amy@gmail.com | We're so sorry to hear about Crisp | ||
5 | Seymour | Butts | ||||||||
6 | Phil | McCrevas | philcrev@gmail.com | So sorry from the McCrevas family | ||||||
7 | Bijan | Borazjani | bijan@gmail.com | test | ||||||
8 | John | Smith | James.Gunn@gmail.com | TESTING !@# | ||||||
9 | Amy | Borazjani | Amy@gmail.com | This is so sad | ||||||
10 | Bijan | Borazjani | bijan@gmail.com | Test 2 | ||||||
11 | textbox_sample0 | textbox_sample1 | john@example.com | Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean mollis ultricies interdum. Nullam pharetra vitae lectus eget volutpat. Integer in sodales ligula. Vestibulum pellentesque arcu in est aliquam rhoncus. Curabitur et dui quis arcu scelerisque congue. Pellentesque libero ligula, sagittis a tempus quis, finibus eget erat. Nunc sed tempor nunc. Mauris tempor odio id lorem commodo dapibus. Nulla viverra mi in magna imperdiet volutpat. | ||||||
12 | Bijan | Borazjani | bijan@gmail.com | test | ||||||
13 | Bijan | Borazjani | bijan@gmail.com | Sorry for your loss | ||||||
Sheet1 |