Greetings,
I'm using DBMan SQL to run an online ordering service for Mortgage Location Surveys. Everything is working well, but now I have a problem. I've built two custom templates. One is an invoice, and the other is a cover sheet. Both are setup to plug in information from the database.
What I want to do is make them available in the Admin area only, as only the admin should be able to create an invoice and cover sheet for each record.
So my question is, how do I access those templates so that a specific record is loaded. In other words, I want the my client to be able to search for a record in the admin, find the one they want, and then be able to click a link that takes them to the invoice template, with that records data filled in. Then they can just print it out. Ditto with the cover sheet.
I envision this being two links off of the Modify Record template, but I don't know how to write the URL.
Suggestions?
I'm using DBMan SQL to run an online ordering service for Mortgage Location Surveys. Everything is working well, but now I have a problem. I've built two custom templates. One is an invoice, and the other is a cover sheet. Both are setup to plug in information from the database.
What I want to do is make them available in the Admin area only, as only the admin should be able to create an invoice and cover sheet for each record.
So my question is, how do I access those templates so that a specific record is loaded. In other words, I want the my client to be able to search for a record in the admin, find the one they want, and then be able to click a link that takes them to the invoice template, with that records data filled in. Then they can just print it out. Ditto with the cover sheet.
I envision this being two links off of the Modify Record template, but I don't know how to write the URL.
Suggestions?
Accessing a specific record in the admin via custom template.