I keep running my head into a wall working on a project and I am hoping you guys can help me. I have created a database that contains the addresses of contacts. What I need to accomplish is generating paper reports of these addresses. So, for example, I may have 25 addresses on one report related by some other data point. I figured that I should easily be able to pull info from my database and fill a PDF template with it that I could then print out, but this has proven harder than expected.
So far, I've tried airtable and notion (I know, but I was temporarily having server issues and I need to get this project done) I've also tried baserow and nocodb, and yet I can't seem to figure out how to generate printable reports from my data.
Does anyone else know of an option? I've seen a recommendation for creating a spreadsheet or word document as a template that you then copy/paste your data into, but that feels... inelegant? Would something like appsmith or budibase be capable of this? Or is there some other (preferably self-hosted) software to accomplish this? I appreciate any help you can give me.
Edit: Sorry everyone, I guess I didn't make it very clear. First off, I've been using the programs above to make my dB's. So for instance, my nocodb is set up to use mysql. I didn't generate the dB on my own, and admittedly, I've never interacted with a db directly using SQL markup before.I was hoping my goal could be accomplished with a low/no-code option as my coding skills are rudimentary right now.
As someone asked, for a printable-report, yes PDF is an option. As would a word document or spreadsheet, for that matter, just so long as I can get it into a nice, print-friendly format.
I do appreciate all the suggestions so far, and will look into them. Thanks!
You may want to look up Variable Data Printing (VDP) software, there's plenty out there