Forums

hi i'm just happy to show data from a databank from a from that i build with chronoforms...

But when an enduser tries to edit an record (i have one table with 5 fields) he sees the fieled that i allowed him to see.. this is very good...

PROBLEM

but when he wants to edit (just one field) he has to fill all field out to edit this record like he is some that wants to save the whole form...

perhaps i can't explain... in my form all fields are required to fill in something..
but when another user wants to update one field..
he has to fill out everything and that is wrong because he isn't allowed to and edit the other field...

is this a bug or did i do something wrong..

please need help

i found out a lot about sql,php chronoforms,joomla and so on, but every new problem costs about an week and i'm about to explode

thanks😶

Hi azadistan,

The usual way of doing this is to set the values of the form fields from the existing record, then those values can stay unchanged.

The Profile plugin may help with this.

Bob

thanks..

i didnt understand much but i look after this profile thing in my form...

so the record stay and the user can update just one field without being oppressed to fill an field out that he should't see..

but how can i do this with the profile page in my form?

example my table name is "Unternehmensform" and it has 5 fields (datum,unternehmen,jobtitel,name,vorname)

with the edit form the end user can should change "datum" and nothing else but the other field are required but it's none of his business?ß

ok i think i understand.. i have to build another form,
after that, i can link to it with the profile page to my old form ..

then the edit of the old form is done over the new form and the link with the profile page ?
am i right...

i think this would also help some other guys so i write every thing down..

Hi Azadistan,

You don't need to show the other fields if only one needs to be edited. But for this to work you *must* include the database table primary key in the form - usually as a hidden value. If the primary key value already exists then ChronoForms will update the record, otherwise it will create a new one.

Bob

hm...
ich updated nmy old form with a hidden field and inserted the cf_id as value...

in my new form ich tried to build a connection with the profile page from one field (old form) to the new one) but when i trei to edit in the new form thee no value for the field...
so there no editing the form is empty...

i didn't understand the primary key thing..
perhaps i can post some screenshots so we can look where the problem is...

Hi azadistan,

Please do post code or images. For images - use the 'upload attachment' tab under the 'Post a Reply' editor.

Bob

Hi here some pictures...

and here the failure post.. after filling put the form and submitting


Fatal error: Call to a member function bind() on a non-object in /mnt/web5/31/77/52164177/htdocs/components/com_chronocontact/libraries/customcode.php(71) : eval()'d code on line 13

some more
[attachment=2]ChronoForms PDL form2.jpg[/attachment]
[attachment=1]ChronoForms Unternehmensform1.jpg[/attachment]
[attachment=0]ChronoForms Unternehmensform2.jpg[/attachment]

does someone has an idea?

if someone could help out with the profile page it would help out..

before it worked... editing and so one but it didnt update the field..

now eveythings messed up

Hi AZADISTAN,

Some of your images are just too big for the forum here and that makes them quite hard to view.

I may not have helped you by writing too quickly.

The hidden field must have the 'name' of the primary key column of your database table (if ChronoForms creates the table this will be 'cf_id' but in your case it is not); and the field 'value' must be a valid key from the table for the record to be updated.

The profile plugin needs to be provided with a primary key value so that it can get the necessary information from the table.

Bob

Hi,
I have to say that i needed just 2 hours to create the screenshots and writing down the text was also about 1-2 hours.. with that i wanted that everyone can understand what the problem is...

But i dont understand your reply.. it could be because i speak german or that i may be a litte bit nervous because of the fact that it cant get throught this stuff...

Can please someone explain me what "primary key " is.. where the hell can i get this value ??

and if normaly the primary key name of my table should be cf_id but in my case not...
what coloumn is it in MY CASE?
it did the whole form with the "Chrono Forms Wizard" an nothing else..

Where is "primary key value" to get the necessary information ?

Hi Azadistan,

Ein Primärschlüssel ist ein eindeutiger Index, bei dem alle Schlüsselspalten als NOT NULL definiert sein müssen. Wenn sie nicht explizit als NOT NULL deklariert sind, holt MySQL dies implizit (und stillschweigend) nach. Eine Tabelle darf nur einen Primärschlüssel enthalten. Wenn Sie keinen Primärschlüssel haben und eine Anwendung nach dem Primärschlüssel in Ihren Tabellen fragt, gibt MySQL als Primärschlüssel den ersten eindeutigen Index zurück, der keine NULL-Spalten verwendet.

In der erstellten Tabelle wird der Primärschlüssel an die erste Position gesetzt, gefolgt von allen eindeutigen Indizes und nachfolgend den nichteindeutigen Indizes. Dies erleichtert dem MySQL-Optimierer die Priorisierung der zu verwendenden Indizes und die schnelle Erkennung von Dubletten bei den UNIQUE-Schlüsseln.

Ein Primärschlüssel kann ein mehrspaltiger Index sein. Sie können allerdings keinen mehrspaltigen Index mithilfe des Schlüsselattributs PRIMARY KEY in einer Spaltendefinition erstellen. Wenn Sie dies tun, wird nur diese eine Spalte als Primärschlüssel gekennzeichnet. Sie müssen hierzu eine separate PRIMARY KEY(index_col_name, ...)-Klausel verwenden.

Wenn ein Primärschlüssel oder ein eindeutiger Index aus nur einer Spalte eines Integer-Typs bestehen, können Sie die Spalte auch in SELECT-Anweisungen als _rowid referenzieren.

von http://dev.mysql.com/doc/refman/5.1/de/create-table.html

Bob

i think i have to try a lot around..

How can I insert a ChronoForms form in an article on Joomla?

Hi nilly55,

Use the ChronoForms plugin.

Bob