Add record to 2 table in the same time

AppSheet AppSheet Q&A
1

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,

2

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.