Invoice Generator - Quote Builder (Excel Exporter)

Show us your works in progress and request feedback

Post » Sat Aug 19, 2017 10:09 am

I've been working on this on and off for quite some time now and have bugged quite a few people along the way for help with bits / pieces. It took a lot of trial and error but finally got to a place happy to share progress to date :)

Thanks @MadSpy, @rexrainbow, @R0J0hound, @Ratmaster, @SoldjahBoy for your time / patience with my questions.

https://www.youtube.com/watch?v=JkiBavLaGaM

Image

It's current and working features:
- Build quotes or invoices using drop box lists
- Items, units and rates are generated from text files. Update the text files to change items / rates etc...
- Add custom items and rates by selecting 'TBC' from drop down lists. Item them added to the list
- Add pictures to quotes
- Save and load quotes to computers / share between computers
- Build in user manual (pdf)
- Live summary breakdown on the right hand side
- Function to duplicate a line down to save time with entry
- Export quote / invoice as a full Excel file (xlsx)

Pluggins used:
NWJS - Save and load quotes to local directory, download photo / excel files
Paster - Load photo and for downloading
Date - Generate today's date in the invoice / quote

The rest is then made from text boxes and a macro excel file to do the final build of the excel file. It allows saving to any location with any file name.
B
38
S
11
G
1
Posts: 204
Reputation: 4,477

Post » Mon Aug 21, 2017 12:53 am

Great stuff! Glad you got it all working in the end :D

I'll check out the youtube vid at lunchtime ;)

~Sol
Tired of crappy file hosts that are crappy? Get DROPBOX - https://db.tt/uwjysXJF
Moderator
B
84
S
34
G
40
Posts: 3,032
Reputation: 30,499

Post » Mon Aug 21, 2017 4:29 pm

Nice work ;-)
Hello !



I'm Steven, a 24 years old French graphic designer and programmer, and it's been 4 years since I started using Construct 2.
B
15
S
6
G
3
Posts: 70
Reputation: 2,573

Post » Tue Aug 22, 2017 11:10 am

Just looked at the YT video - looks nice!
Cool to see something a bit different made in C2 :)
B
12
S
2
G
1
Posts: 39
Reputation: 892

Post » Tue Aug 22, 2017 7:51 pm

Laura_D wrote:Just looked at the YT video - looks nice!
Cool to see something a bit different made in C2 :)


Thanks for the feedback. Yes, not your average game that is made with C2 and shows how it can be used differently. It has made it more 'challenging' but no problem that cannot be worked around :) I moved to C2 to test if I could make something like this as I was using an excel macro sheet before with forms and VB. With newer updates on office over the years it gave lots of errors. Plus this just feels more of a professional package once exported as an .exe file
B
38
S
11
G
1
Posts: 204
Reputation: 4,477

Post » Wed Aug 23, 2017 5:18 am

Hey I finally got around to having a look at the video. Very nice indeed.

Reminds me quite a bit of how I made my POS software... proof that C2 isn't just for games at all really!

~Sol
Tired of crappy file hosts that are crappy? Get DROPBOX - https://db.tt/uwjysXJF
Moderator
B
84
S
34
G
40
Posts: 3,032
Reputation: 30,499


Return to Works in Progress/Feedback Requests

Who is online

Users browsing this forum: No registered users and 5 guests

cron