I want to set up a registration process. User should fill in a formular with name, email, and a few other things. I set up a collection with those fields and try to set up a primary id.
As I can not prevent some user to register twice (or more), as an old DBmanager, i can not set the email field as primary. The only field that is unique is the timestamp of the transaction. So I tried to set the creationdate system field as the primary, but its unavailable (grey in the menu).
Apparently, only text fields (and only one) can be set as primary, so the solution I see is to create a text fields and fill it by code with the timestamp (correctly text formated). This solution is a little bit stupid as it just duplicate an existing information!
On another side, I tested the standard features for formulars, and the system created a collection. I had a look on that collection, and this is exactly what I wants : A field “datetime creation” has been created and is set as primary. So this seems technically possible, but not allowed!
SO another question: can I use this automatically created table with a self made formular page. If I delete the standard fomular associated tha created it, will the collection still be available?
Sorry for this long question!
Claude