i was wondering if someone could provide some insite.
im currenly developing a iform to use in our education system to try and cut down work load on admins by having forms injected into our sql.
to do this im using zapier to add a new row into the sql.
one of the problems ive run into is the primary key on our database.
this is used by concating 2 fields which isnt a problem but then it uses a sequential key on top of that,
so as an example the primary key for a form submission would be something like 02950001(sequentialkeyhere)2958568598 where the sequential key would be the next available number in the database.
how or what could i do to make sure that the ID of that form gets inputted into the database correctly ie pickup the next available key.
ive got in touch with zapier aswell to see if if this is something that they may know also.
Please sign in to leave a comment.