Insert SQL in submission form

[JulienMoulis]

Hi,

I want to create a ticketing system like caspio support.

I have two table 

T_Ticket:

--> ID_TICKET

--> Ticket Subject

--> Ticket Commentary

and

T_Detail_Ticket

--> ID_DETAIL_TICKET

--> ID_TICKET (Foreign key)

--> Commentary_DETAIL_TICKET

What I need is, when a ticket is created, create with an SQL insert the first detail_ticket commentary with the commentary_ticket

Is that possible?

[Mathilda]

Hi,

Please watch this tutorial. It describes how to build ticketing system.

Hope it helps

[JolliBeng]

Hi JulienMoulis,

You can use triggered actions and add "Insert Into"  actions.

 

-JolliBeng

[MayMusic]

You can create a triggered action on your parent table to add the row to child table on Insert. So you need to select Action = Insert and then click on the gear next to insert to select from from #inseted which is the newly added data : http://joxi.ru/L21KwNau81Db9r