Hello,
I would like to know if when saving form data to a custom table, it's possible to also save a custom ID instead of an au increment one. What I mean by that is could the row ID be something like <xx>-<xxxx>-<xxxxx>, where <xx> is something i would determine when the data is being saved.
Thank you for any help.
If you don't have autoincrement set on the table you should be able to insert any id you want or is it not working?
Hello Klas,
What I'm trying to do insert a calculated ID. For instance in standard PHP once the form is filled out I would query the database, in order to have the number of records, and create an ID similar to code-year-records.
- Code would be a fixed value
- Year the current year
- Records the number of lines in the table, with leading zeros.
I don't know how, using SEBLOD, I can create that kind of custom field that is dependent on other information (some of which come from a query).
I hope this brings more clarity as to what my difficulty is.
Thanks again for any help.
Hi,
I think that only way to do this is to use beforeStore code plugin- with it's help you can manipulate existing data being sent to storage and do any necessary adjustments/inserts etc.