EFG and Catalog not working together ?

[septentrio]

Hello,

In my project i want every internet user to be able to post classified advertisements.

I created a form using efg, feeding a table created using the catalog module.
So every form entry has a corresponding table entry (variable name = column name)

Despite all of this, the form doesn't record the data in the table.

Did i miss something ?

Thanks

[MacKP]

Yes, sounds like you missed something.
Maybe the ID ore PID ore tstamp ore ore...
So you must look at the table in the DB and you musst fill every Column.

regards

[septentrio]

thank you MacKP,

Effectively, to make it work i needed to set an hidden field with the value of the PID. It works fine. Thanks

You are talking about timestamp, this is also interesting for me ; how can i record the timestamp when a user submits a form ? I tried to put a calculation field in my catalog with the sql statement CURRENT_TIMESTAMP () but it doesn't work fine as it updates the timestamp every time i open a catalog item.

[MacKP]

Hi septentrio,
normaly a 0 in an Date Field sets the current Date. I don't know what the efg is making with it. So try it ;-)

When you don't get it with the efg than you can try the Fronetend-Editing in the catalog. There it will work.

regards