Hi Eric,
Writing my own is beyond my capabilities.

I spent a few hours yesterday looking for alternative forms but nothing really leapt out that I would like to try.
I'm going to have another go at editing coffeecup php files.

I just try change every variation of 'rowid' to 'id'.
I basically just opened every php file in Notepad++ & did a search for 'rowid', as they were found I changed them.
I find instances of rowid in these forms;

dataaccessreporter
datasave
datasavemysql
formpage

(i ignored the sqllite php files)

Unfortunately it did not succeed, I get this error:

'Your form could not be submitted for the following reason(s):
Failed to store the data.'

Then, in the error log I get this error:

'Failed to insert data in from table: [0] 42S22 [1] 1054 [2] Unknown column '_submitted_' in 'field list' '


I am assuming the unknown column must be the newly renamed column 'id'.

Do you have a column _submitted_ in your table?

Yes there is, but I believe this is auto generated as none are my fields are called that.
It is a 'datetime' field type.

Could it be that there is a mismatch between this field & what is in the MySql table?

I bet your alterations messed the variable up some how. Maybe go back and do a search and see if you did something to it by accident.

Eric........You are very observant - You cracked it mate

I removed this from line from line 109 on formpage.cls

$this->post[ '_submitted_' ] = date('Y-m-d H:i:s');

And it all synched together.

I was focusing too much on the primary field id that I failed to notice _submitted_ was an actual field column

fyi.........

I was trying to integrate CoffeeCup formbuilder into MIGX on a Modx site under development.

I nearly gave up & sought another solution but I'm glad I did not because this is my preferred form builder by a long long way.

So a special thanks to you Eric for your support