From the Home screen, users can Add a new entry. (the foster care travel reimbursement process is abysmal)
The components from ‘Date’ to ‘Round Trip?’ are filled in by the user. ‘Miles’ and ‘Claim Estimate’ are calculated in the Google Sheet.
Is there a way to use onChange() to copy down the ‘Miles’ and ‘Claim Estimate’ formulas only when a new entry is created by the user from the app?
In Google Sheet terms, when the user Adds a new entry in the app creating new travel details in a Google Sheet row (columns A-F), I’d like it to copy down the formulas in columns G &H.
Any help would be so appreciated.