This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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,
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.