[SOLVED] custom object

Hi, i need to customize object chronoform when a user click on link concact us for a courses (events) (e.g. i have a list event with code M001 and name event, the user click on M001 and in chronoform i view already object with M001 or name event). It's possibile this? Thank's

Hi Sciadini,

Yes you can use the DB Record Loader action to get the data from a database table and load the values into a form.

Bob

Thank's Bob, where can I find an example?

I find this http://www.chronoengine.com/faqs/2698-how-to-load-one-row-from-a-db-table-into-your-form.html
This means that i must have all date already in a database, right? Because I now have a article with normal table with for each row (code, name, button contact), so code e name must be in a db table.

Hi Sciadini,

Sorry but I don't understand what you are saying here, please can you give some more detail?

Bob

Hi Bob, sorry but my english it's very bad (i know). I try to write better

I have an article, in this article i have a table with

<table class="zebra" style="height: 263px; width: 668px;">
	<caption>Principali corsi dell'area</caption>
	<thead>
		<tr>
			<th>codice</th>
			<th><span style="font-size: medium; font-weight: bold; line-height: normal; text-align: center;">corsi</span>
			</th>
			<th class="center bold" style="width: 80px;">tipo</th>
			<th class="center">richiedi info</th>
		</tr>
	</thead>
	<tbody>
		<tr class="odd">
			<td class="bold">M005</td>
			<td>Marketing dei servizi: principi di customer service</td>
			<td class="center">corso base</td>
			<td class="center"><img src="images/mail.png" alt="mail" width="24" height="18" />
			</td>
		</tr>
		<tr>
			<td class="bold">M006</td>
			<td>Marketing delle organizzazioni non-profit</td>
			<td class="center">corso base</td>
			<td class="center"><img src="images/mail.png" alt="mail" width="24" height="18" />
			</td>
		</tr>
		<tr class="odd">
			<td class="bold">M007</td>
			<td>Marketing dei musei e della cultura</td>
			<td class="center">corso base</td>
			<td class="center"><img src="images/mail.png" alt="mail" width="24" height="18" />
			</td>
		</tr>
	</tbody>
</table>

Now, this information are not in a database, I have written this by hand.
So, how I do to get name from this table and put in chronoform object when i click on link?

Thank's

ok i created db with chronoconnectivity. But I can't make it work.

I insert a DB Record Loader in form-contatti (that is where it needs to insert the data)
DB_field: cd_uid
table: kqtl6_chronoforms_data_corsi_marketing
Request Param: cod

what's the link?
How I tell him: get the field name cod(from db name kqtl6_chronoforms_data_corsi_marketing) and put it in the field name oggetto in form name form-contatti?

Help me please I'm going crazy!!!!

I inserit this link

http://www.marketingcamp.it/index.php?option=com_chronoforms&view=form&Itemid=137&oggetto=cod

but in oggetto i view the word "cod" and don't M001...

Hi Sciadini,

I'm finding this hard to follow :-(

As you said your data is in an HTML table in an article, not in a database table. There are only two ways I know of of accessing this data.

a) Write some complicated JavaScript to parse the HTML and extract the data.

b) Extract the data by hand and add it to a database table.

The second is probably the simpler one to do.

In your later post you have this link

http://www.marketingcamp.it/index.php?option=com_chronoforms&view=form&Itemid=137&oggetto=cod

In here the parameter is 'oggetto' and the value is 'cod'

In the DB Record loader entries you have used 'cod as the Request Parameter - so one or the other is backwards.

Bob

OOOOOH MY GOD! I solved Thank's Bob, very very very thank's, i was also wrang the DB field (was cf_id and not cf_uid)

I write all for other people

I create a contact_form (chronoform) with field name object
I create a event_form (chronoform) with fiel name cod, name and type

Than, in contact_form I have insert (in event) DB Record Loader with
DB field cf_id
Table event_form
Request Param object

And finally I create a chronoconnectivity with event-form for view a table with all event and a link for each event that clicking fills the field object with the name of the event.

So, in frontend list settin i insert this code

HEADER

<table class="zebra" style="width: 668px;">
	<caption>Principali corsi dell'area</caption>
	<thead>
		<tr height="20">
			<th>codice</th>
			<th><span style="font-size: medium; font-weight: bold; line-height: normal; text-align: center;">corsi</span>
			</th>
			<th class="center bold" style="width: 80px;">tipo</th>
			<th class="center">richiedi info</th>
		</tr>
	</thead>

BODY

	<tbody>
		<tr>
			<td class="bold">{cod}</td>
			<td>{name}</td>
			<td class="center">{type}</td>
			<td class="center"><a href="http://www.mysite.it/index.php?option=com_chronoforms&view=form&Itemid=137&oggetto={name}"><img src="images/mail.png" alt="mail" width="24" height="18" /></a>
			</td>
		</tr>

FOOTER

	</tbody>
</table>

I hope to help someone. Thank's Bob