Automatic filling of tickets with data from Excel tables in pdf and image

Databases & SQL, Desktop Apps — incorrectly specified categories?

67 USD

Project translated automatically. Log in or register, to view the original To distribute charitable children's gifts, it is necessary to create an app(script) to form gift tickets that will be sent by parents with information to receive. Since the gifts are different and the parents choose the type of gift when registering then under each type of gift you need to generate a unique number on which they will be able to get this gift. The administrator must be able through the application to enter a list of gift types (impressed in the ticket), a list of receiving cities, the address of receiving gifts, the dates and time of receiving gifts, a picture of the image under each type of gift. It also forms a register of formed tickets. with all the data listed. Each ticket must be automatically stored in a separate PDF file or image format.

Proposals 12 Discussions 1

Denis U.

3 0

Projects -
Rating -
Rating 248

Budget: 3000 UAH Deadline: 3 days

I welcome. Ready to perform your work. I propose the auto filling to be implemented using the user form, where the choice of the winner will be available (the city, address, etc. will be linked to it.), select the gift (with the display of the picture), generate the random number and save it in PDF. On the individual sheets you can fill in information about gifts, winners and it will be available in the form. Along with the preservation of the pdf file, the record is added to the winners list on a separate list.
The example
Google Drive

Viktor Biruk

72 0

Budget: 3000 UAH Deadline: 5 days

Data is a table and lists in Excel.
Templates of bills are Word or Excel.
Pictures is a folder with images files.
For the work of the administrator - the pseudoform on the Excel or UDF - the user form (this is more difficult ===> more expensive).
The processing system is VBA-Excel (Macro).
The result is a folder with pdf files; a register of tickets (in a new letter, in a new Excel book or in a pdf file); an e-mail address (the option is additional ===> more expensive)

from VBA since 2011. Let’s write and talk.

Petro Shpak

13 0

Projects 13
Rating -
Rating 419

Budget: 5000 UAH Deadline: 3 days

Welcome to!
I work with Excel and Google tables.
Ready to help with a formula or macro (scripts).
I will be happy to cooperate.

Roman Serebrak

43 0

Budget: 3000 UAH Deadline: 5 days

Good day !
I can do as an Excell macro, but, as I think, it’s better to make a script, for example, on php.
A more flexible mechanism

Artem Shuryhin

210 0

Budget: 3000 UAH Deadline: 7 days

Good day . I may be able to help you solve your task.
It would be good to see an example of an Excel input file, as well as an example of a formated tab in PDF or image format.