I'm looking for a way to allow users to trigger an automated update request from a sheet for rows that are assigned to them in a contact list column. The sheet tracks all transactions that we use for billing our projects. Each row is a specific transaction (Vendor, invoice number, billing code, etc.). We have automations set up to send out update requests on a date an time based intervals but would like to give users the ability to trigger an update request without being shared to the sheet. I tried using a simple form that adds a row to the sheet with a trigger cell but it doesn't work. I don't want to use an on demand report since that would require sharing the sheet to the users. I'm restricting the input from users to web-form only.
Ia it possible to create a helper sheet that gets inputs from users via a form and somehow trigger the automations on my transaction sheet from data in the helper sheet? The goal here is to create "on demand" update requests.
