Forums

Hi GreyHead,
I´m creating this large form to my customer, after data is input, then I must print it filling the blanks
[attachment=0]formresumido-p.jpg[/attachment]

I´m not sure if I create another table with chrono conectivity or if I add fields to user profile (using UserProfile Plugin).

I also want to use the form to edit the data, is it possible?

Best Regards

Lucas Selbach

Hi Iselbach,

I would save this in two linked tables. One for the main information and the second for the repeating rows in the center of the form. I'd link the two tables with a unique id (probably a shorter one than the CF UID).

Bob

Ok Bob,
Thanks for Replying.
I'll follow your suggestion.

What do you suggest for printing the form??
Because I need to input user fields and adjust fonts and line heights with CSS.

Thanks and Regards.
Lucas Selbach

Hi Lucas,

It depends what the user wants :-(

You can output to a print page, or a PDF (or even a Word document as HTML). Check the FAQs for more info on the first two.

Bob

OK Greyhead,
Thanks for the hint.

Cheers from Brazil.
Lucas

Greyhead, another doubt:

On the field sexo (which means gender), how do I change the result (Male/Female) for an X to fill the small box on the form?

(in other words, the data in DB is Male or Female, but I need to print an X on the left for Male or an X on the Right for female) - check printed form attached above.

Thanks and Regards
Lucas

Hi Lucas,

First off - it's usually a big mistake to try to copy a paper form in HTML. It ends up being a lot of fiddly and unnecessary work :-( Better to get the client to re-think what they actually need.

You can probably use the utf symbol ☑ if the font supports it.

Bob

It might be easier for you to have the form output something like "Gender:" then have the answer populated in word form based on the database.

EG:

Gender: Male

Hi Nuvelle,
Thanks for replying.

The question is - as Greyhead remembered me - that filling a form is a lot of work to do (and maybe unnecessary).

But my customer has more than a thousand of this printed and don´t want to get rid of it.

I tried to install an ODBC connector to retrieve data from MySQL to Excel (easier to adjust the form), but in the end just didn´t worked. I´ve sent a message to the ISP to check it out.

I also tried an extension called ART DATA from Art Etics to retrieve data and arrange it into a form, but I´m having some issues too.
http://data.artetics.com/

I´ll post my results here.

Thanks and best Regards.
Lucas

Hi Iselbach,

They want you to print the form result onto the form!! Have you thought about buying 1000 copies from them and using them as fire-lighters . . . :-(

You can use the CSV Export function to export to Excel, or you could create an HTML template that will open in MS Word.

Bob

Eheheh, that sounds great! A big camp fire in the garden!

I´m really thinking of doing this (telling to my customer that isn´t viable to fill the form).

Just doing final testes with word and ODBC.

Regards
Lucas

Hi Bob,
I just solved that matter - made a MySQL ODBC connection to Excel and used MS-Query to retrieve the data and fill up the form.
In Excel, I´ve made the columns with same size (5) and merged cells to fit the correct space.

I´m just having trouble with CHRONO CONNECTIVITY, I want to put a LINK TO EDIT DATABASE IN FRONTEND, but can´t figure out what´s wrong.

Any help??

Regards
Lucas