Just created form... Data is not being recorded to table but if I go to view data in back end...

[cheyennemtnman]

I can add data with add button and it records into table. I get a successful message on front end that record has been added yet no data is recorded.

 

[cheyennemtnman]

Created another form ... same result

 

[troester]

What do you mean with "created a form"?

Do you have a prefilter on your list and the new record doesn't match the prefilter condition?

 

[cheyennemtnman]

No prefilter except for the -1 in the form options

 

[cheyennemtnman]

Just wondering why it would record a record using the same form in the backend and not in the front end...

 

[cheyennemtnman]

Still having problem

 

[troester]

Still not clear what you are doing and what you are seeing where.

What do you mean with "created a form"?

I assume you don't mean a "form" but a new record?

Where is the data "not recorded"? Is it missing in list view? in the database table?

 

[cheyennemtnman]

Two most recent forms I have created in backend... The data is not recorded in the table when I use the form from the frontend but it is recorded when I use the add button in the view data from the backend.
When Using the Form in the frontend, it shows record added message after each time I complete and submit the form... but when I check the table only the record that I added from the backend shows in the table.
Using PHPMyadmin confirms this to be the case.

 

[troester]

And how do you add/edit a record from the frontend. Via a form menu item with option Row id=-1?
This will only ADD a record if there's no record belonging to the user. Otherwise it will EDIT the record. In both cases the message will be "added/updated"

 

[cheyennemtnman]

And how do you add/edit a record from the frontend. Via a form menu item with option Row id=-1?
This will only ADD a record if there's no record belonging to the user. Otherwise it will EDIT the record. In both cases the message will be "added/updated"

Yes Form Menu Item and yes with a -1 in form option to get the user information
Brand new forms with no records until I used the backend to test
I deleted the one record from the backend entry and tested once again
Same result.

 

[troester]

It must be your menu option (did you set the "Key name") or your form (plugins?) settings.

 

[cheyennemtnman]

View attachment 18556

It must be your menu option (did you set the "Key name") or your form (plugins?) settings.

No just a simple form... no key name / no change of settings.

 

[troester]

You can't use rowId=-1 without Key name

Column name to use with Row id, leave blank to use primary key (only set this if you know what you are doing!). If row id set to -1 then set this column to the name of the form's user id element to prepopulate forms with the users record

 

[cheyennemtnman]

You can't use rowId=-1 without Key name

Just following what was presented in the rollover help... says to leave blank and it will use row id...
Never had to set key name before...

 

[cheyennemtnman]

When I change the to the id in the form I get this error
Unknown column 'training_complete.training_complete___id' in 'where clause'

 

[cheyennemtnman]

so just the "id" is needed not the entire element name

 

[cheyennemtnman]

Thank you for your direction! Working now

 

[cheyennemtnman]

Can this be done as a link in an article? or does this require going through a menu item?

 

[troester]

so just the "id" is needed not the entire element name

No. The short element name (=column name) of your element which is storing the userId (NOT id=primary key)

 

[cheyennemtnman]

I linked to menu item name in a hidden menu and it works