Display records

Hello,

I have a question because i don't know if this can be done...
Can i display in the frontpage the list with the records from a form as they are in the admin page?

For example can i show this list?
[attachment=0]records.png[/attachment]

Thanks,
Kimos

Hi Kimos,

Yes, You can create a simple listing using a ChronoForm with a DB Read action in the On Load event (use the Multi option) and PHP in a Custom Element element to display the results.

Or you can create a much more complex and flexible listing using ChronoConnectivity.

Bob

Hi Bob,

To create a simple listing with db read I have to create a form on designer or i have to create only a db read in the setup that it will be connected with the database?

Thanks,
Kimos

Hi Kimos,

This goes in the Designer tab "PHP in a Custom Element element to display the results."

Bob

Hi Bob,

And what code must contain the Custom Element to display the results?Can you give me an example so as to understand it?

Thanks,
Kimos

Hi Kimos,

How do you want them displayed?

Bob

Hi Bob,

I want the records to be displayed as they are in the admin page.
If i can do that without ChronoConnectivity, i prefer it.

Thanks,
Kimos

Thank you very much Max!

Hi,

As i said the display of the records works fine.Now i want to edit a specific field per record when they are displayed.How can i do that?

Thanks,
Kimos

Please check the CCv5 section under the FAQs, it explains how to have an edit form, or edit the list on the fly!

Regards,
Max

Hi Max,

I checked the CCv5 to the FAQ section and i tried to do it to my form...
The result was to be able to edit only the record that was made by the user that he can see the listing.If i press to another record to edit from a different user it opens to edit the record from the user that can see the listing.I know that it sounds complicated so i will try to explain it with the photos below...

Here is the listing:
[attachment=0]edit1.png[/attachment]

If i press the edit either to the first record or to the second it opens the same record:
[attachment=1]edit2.png[/attachment]

I don't know what i am doing wrong...Please help!

Thanks,
Kimos

What do you have in the columns list box ? how did you create the edit link ? and do you have any code in the conditions box under the models tab ?

Hi Max,

I followed the steps from this link: http://www.chronoengine.com/faqs/72-ccv5/5208-connectivity-edit-with-chronoforms.html
The column list is:
[attachment=0]cl.png[/attachment]

And no i don't have any code in the condition box under the models tab...

Thanks,
Kimos

Can you help me please?

I have no idea why would it edit the same record then, what's the primary key in your table ?

When you put your mouse over the edit links, are they the same or do they have any differences ?

Hi Max,

The primary key is the "id" and when i press to the edit links it show the same record to the form...

But first let me explain you what i'm trying to achieve:

I have a form where logged in users can sumbit the form and i have connected the form with a db read so as to see his submited data.(that is the first part that it works fine)

The second part (where i have the problem) is that i want the manager of the site to see all the records from anyone user and edit any field he want.

I'm using ChronoConnectivity so as to display the list with the records and the only thing i want now is to edit the fields i want...

Here is the setup from my form
[attachment=0]setup2.png[/attachment]

I hope you understand what is my problem...

Thanks,
Kimos

Hi Kimos,

The form event used for connectivity edit should NOT have a "db read", and the event used for CC save should NOT have a "db save", that's something done by CC for you!

Please remove those 2 actions and try again!

Regards,
Max

Hi Max,

Ok as you said i delete the db_save and db_read and now i have only the authenticator,the html reader and the connection action.

Now when i press the edit from the displayed list it opens the form without reading any record...
And if try to fill the fields and press submit it says that it saved but it doesn't...

Any ideas??

Thanks,
Kimos

Your form fields names should have the model id, e.g:

Testt[text1]

Hi Max,

Thank you very much it works fine!

Regards,
Kimos