I'm looking for a solution to generate document (ideally docx but pdf is ok) from a database
Ex: I have a project entry (with client info, dates, information about the project, etc.) and I want to generate documents from a tender templates, containing selected entries from the database.
Here is what I tried until now :
- Custom database (tinyDB) + custom webpage form + a docx template with jinja markups served by a homemade webpage hosted on pythonanywhere (lot of work and not reliable as I'm doing everything myself)
- Nocodb form and database (no document generation yet) (self-hosted or on cloud)
- Airtable (closed source and on cloud) for forms, database and document generation
Airtable is what I'm currently trying because it's the only one that I found that have lot of support and adds on.
There are a few options on Airtable for document generation, lot of which cost around $30/month which is why I'm looking for a viable alternative. Ideally I would like to be able to upload my already made templates.
More point to the solution if it's supports geodata
I'm considering keeping airtable and using the api to generate document with the python program I used on the first point, but I'd like to know if there is more options.
EDIT2: to be concise: I'm looking for an alternative to Airtable + Make. Ideally, FOSS and self-hostable or on cloud
Edit: precision: I need to create a document that contains multiple items of the db. Ex: I need to create a resume with different experiences that are saved in the database
Here is an example of a template:
One way to do it is have a small Python (or any other scripting language really) script that performs text replacements in the Latex source file. This is much easier in Latex because it's plain text. I don't know of a solution that doesn't involve writing your own code (apart from LO/Word serial letters).