Add record to 2 table in the same time

[socheaofficial]

I want to create purchase record the same time into two table (purchase and transaction ), so when I create a purchase record and it will be create a transaction record also that related filed,

[LooToS]

Use AppSheet Automation:

• Create a Bot in AppSheet's Automation feature.
• The Bot should be triggered whenever a new record is added to the 'Purchase' table (i.e., when the Purchase form is submitted).
• Within this Bot, create a data action that adds a new record to the 'Transaction' table. The process will take the relevant data from the newly added 'Purchase' record and use it to create a corresponding 'Transaction' record. You can use an AppSheet expression to map fields from the Purchase record to the Transaction record.
  
  
  I used my own GPT for this https://chat.openai.com/share/8c35cdcf-7842-43ac-99b3-6a640ee198f8
  Here is the original Post if you are interested.