Hello Internet,
I’m not sure how to accomplish what I want to do.
I want to create a document in Writer, that has fill-in text fields, like a client intake questionnaire e.g.
What is your name? [Fill in text field]
What is your address? [Fill in text field]
I then want to be able to save this data to a database or Calc spreadsheet. I guess with a button at the bottom of the intake questionnaire called something like “Save”, and have it perform a function like “If this is a new record, add this information to the database, if not, do nothing (and maybe show an error “This record already exists”).
I then want to create a bunch of Writer documents from templates, that will pull the data e.g. name and address from the database or spreadsheet. So, I have a bunch of templates that I create, saved someplace. Then based on the client questionnaire, I create a folder for the client, named [Client Name], put the applicable templates in there, I then want the template documents to lookup in the database the records that match the name the folder is named.
Of course I want to know how to do all this, but I guess my question is mostly a terminology question. What are all these buttons, functions and relationships called in LibreOffice, so I can effectively look up tutorials and answered questions? Are there other websites that might have this question answered? Reddit? OpenOffice Forums? Ubuntu forums? Gods forbid StackExchange? I don’t mind if you link answered questions.
I have some experience using fill-in fields in MS Word, and I have some experience with using Mail Merge, but I have never set up a database before (although I taught myself a little bit of SQL on CodeWars).
Thank you for any leads, answers, questions and discussion.