Invoice Template

any help please

WHat template are you using?

Have you made it yourself?

Have you copied the {$FieldNames_values} to the template?

[color="#1C2837"]

Have you copied the {$FieldNames_values} to the template?

take look screenshot

You will have to put a link to the page on the SQL query page.

Copying and pasting an event wont work

thanks but ....

can you show me how

hey dude thanks..

I figured out how to do it...
i have added table relations
thanks

On your tables page, create a custom view of the main table that contains the information regarding the job or project you want to create an invoice for.
Call this custom view Invoice for example.
Edit the SQL to display what you need it to display, values from other tables.

Once you are done, build your project.
Using a HTML editor, design your invoice page, and open the Invoice custom view, view page. You will see all your links looking like {$FieldName_value}, copy and paste these into your new HTML page you have designed.

Once you have done and are happy with the layout, copy it to the templates folder in the output dir in your project.

It will then display your page with the values.
Take a look at mine if it helps out.

You will see what I mean.

http://view4you.kguard.org/flush
You will need to register, but once you have, and have logged in, from the menu, click on jobs details and jobs database.

In the list page, click on the Invoice link for the jobs that show Job Complete, or have a play around.

It will show the invoice in a list form, then click on view and it will display it in a custom page I made using Microsoft Frontpage.
Hope that helps to clear it up a bit for you