I need a way automatically fill out the fields on a paper form with data from a Zoho Creator report. The goal is to auto-generate and print a completed paper form that looks exactly like the original blank paper form, but with all the fields filled in with Zoho database data which was extracted from a Zoho report screen. This is important, because many applications require the filling out of forms where you must use the exact layout of the original blank form for the completed form.

The basic steps would be:

1.       1. Create a Zoho Creator report that has all the fields which are required in the paper form. Ideally the Zoho fields will be named the same as the fields on the scanned report form.

2.       2. Scan in the paper form and save it to Zoho, somehow associating the scanned form image with the specific Zoho report screen with the same field names.

3.       3. Start a scanned form editor which will display the blank scanned form, as well as show a list of all of the fields in the associated Zoho report.

4.       4. Have a field placement mode where each of the fields from the list of fields in the Zoho report can be dragged and dropped onto the scanned form image, and then resized as needed.

5.       5. When the field placement process has been completed, the user should be able to save the final form layout with all the Zoho fields placed on the scanned form image.

6.       6. In Zoho Creator, the user can select a number of records from the Zoho database that will appear in the consolidated report, usually in multiple rows.

7.       7. If the Zoho report shows multiple records, the application should be able to print out a sequence of similar forms, with each form showing the field data from a different record in the original report.

Notes:

Zoho Creator produces browser-based reports in any browser. Ideally, this form-filler app would also be browser-based, so when the Zoho report is displayed in the browser, the form filler app could scrape the data from the Zoho data in the browser, place it on the scanned form image, and then print the final completed form. One issue is the requirement to do this automatically,multiple times with the same report but different records. Also, I don't want to have to export the forms data to a spreadsheet. The whole report/print process should be as automatic as possible.

I have several Creator apps that require the filling out of various forms with the data from lots of different records. I would be willing to fund the development of this add-on, if someone thinks they can do it.