-
Sending report link as automated alert
Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom that says 18 more rows not shown. Is there anyway to include all rows in the report in the email,…
-
Approval workflow validation
Is there an easy way to validate that a request for approval submitted via a form is not approved by the person who created the request? My sheet contains a Contact List column from which approvers are selected. I have tried to validate this entry against the 'Created By' column but this does not match as the contact list…
-
Is there a "run now" option that will initiate a Workflow?
If I am setting up a Workflow that depends on a specific action, date, time, etc., and I want to see the results now to correct any missteps, is there a "run now" option that will initiate the workflow? I'm trying to avoid having to set the Workflow with a temprary trigger, watch the outcome, and if it works, go back and…
-
Is there a way to send an alert based on a non-contact list field?
I am trying to create an application in which users make a request of their supervisor and the supervisor approves or denies the request. I created a sheet with "employee name" as a contact list and "supervisor name" as a contact list. When I fill out the form and enter names in those fields, SS doesn't pick up that they…
-
Can you submit a document from a form and place the new row based on sheet heirarchy?
I have several vendors working on the same project. Each has a set of required deliverables that have to be submitted at regular intervals (weekly, twice monthly, monthly) during different project phases (concept, design, installation). I would like to use a sheet to track the submissions and create a form for them to use…
-
Move or copy row workflow results in empty rows in destination sheet
I have set up a few workflows that copy rows from an interim calculation sheet into a destination sheet for history/time series purposes. Whenever I set this up, I run a few test cases to make sure it working okay before I let the scheduled workflow take care of this automatically. This means, I have a few test rows that I…
-
Send a workflow alert to a specific person based off a form drop down question
Hi, I have a form where the user can select between a few people as the person they who is in charge of their project. I then made a workflow that says Trigger: When rows are added or changed When: "the form question" changes to Any Value Run workflow when triggered I then made several conditions side by side, 1 for each…
-
How can alerts show everyone who is copied on it?
Hi there, We are using the alert workflow for our invoicing process. In our process, we don't have any one who has to actively approve anything, so that's why we don't use the approval workflow. However, certain people need to be copied on the invoice requests to AP. I've set up the alerts, but unfortunately no one can see…
-
Move Row w/ Formulas
I have 3 sheets that are being used in tandem: Sheet 1 Registration Data Sheet 2 Travel Requests Sheet 3 Cancelled Registrations Sheet #1 has a "registration status" field (dropdown). This field is being pulled into Sheet #2 by using an Index/Match formula. If the registration status (on sheet 1) changes to cancelled, I…
-
Workflow Trigger Timing?
Does the workflow trigger activate when the sheet is saved (manual or auto) or is it when the actual change to the trigger field occurs? I am presuming the sheet has to actually be saved for the trigger to activate. Appreciate your feedback.