Approval workflow

Berta

Hello!

I need to create an approval workflow with these conditions. Please also find below the problems I'm encountering:

• 当一行添加、改变或删除。(问题#1: I don't manage to set this up for rows that have been deleted.)
• Whenanyaction above is performedonly by specific email addresses. (Problem #2: I've not been able to set up the workflow so that it allows me to add those email addresses directly to it.)

Thank you in advance for your help,

Berta

Andrée Starå

Hi@Berta

I hope you're well and safe!

Can you describe your process in more detailand maybe share the sheet(s)/copies of the sheet(s) or somescreenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅我的帖子(s)他吗lp or answer your question or solve your problem? Please support the Community bymarking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

Hi@Berta

You won't be able to set up an Approval workflow when a row is deleted because it will no longer exist in the sheet to be approved, does that make sense? There's an Alert workflow we can build to notify you if something was removed. You can thencheck the Activity Logfor more details (if your plan has access to it).

In regards to specifying if the change has happened by one person, you will want to set up aModified Bysystem created column in your sheet (see:Use a System Column to Automatically Add Information to a Row).

Then you can use this in a Condition block! (See:Condition Blocks: Filter What Your Automated Workflows Send)

Let me know if you still want help building this out. If so, I agree with@Andrée Staråthat it would be useful to see screen captures, but please block out sensitive data.

Cheers,

Genevieve

Berta

Hello@Andrée Starå, hello@Genevieve P.,

Thank you very much for your comments above. They helped me set up what I needed.

Regards,

Berta

Andrée Starå

@Berta

Excellent!

Happy to help!

Berta

Hello again@Genevieve Evansand@Andrée Starå,

I've created a weekly alert for rows that are added or changed by certain people (thanks for your advice!), but I cannot set the day of the week and the time to receive these alerts. How can I customize this?

I'd also need your help to create an alert workflow for removed rows, as you suggested above, please.

Last but not least, I'd like to move rows whose status is changed to "Closed" to a subsection in the same sheet. However, the only option I've found allows me to move it to a different sheet.

Thank you very much in advance,

Berta

Genevieve P.

Hi@Berta

1) Weekly Workflow:

Weekly workflows will run between the first Friday at12:00 AMand11:59 PMthe following Thursday, and messages will be delivered between12:00 AMand4:00 AM在第二个星期五。

See:Trigger Frequent, Change-Based Automations in Batches

The alternate way to set this up would be to have thetriggerset as a date, with theconditionbe the change that happened. See:Create a Time-Based Automated Workflow

2) Deleted Row Alert

Go to Automation > Manage Workflows > click the dropdown to create a workflow >Basic Workflow

at the bottom:

Then you can select "Alert someone when a row is deleted":

3) Hierarchy and Workflows

There currently isn't a way to automatically move a row to be under a specific Parent row. Please submit your suggestion and feedback to our Product teamthrough this form, here!

Cheers,

Genevieve

Berta

Thank you very much,@Genevieve P.This is very helpful. I'll fill in the form for the third point.

I've set up the basic workflow for the deleted rows, but the email I receive doesn't specify which rows were deleted:

Is there any way the message body can be customized?

Regards,

Berta

Genevieve P.

Hi@Berta

No, since the row has been deleted there is no information about the row that the alert can specify. You will need to access the sheet's Activity Log (if your plan has access to this) in order to see the history and content of that deleted row. See:Track the History of Changes with Activity Log

Berta

I understand. Thank you very much,@Genevieve P.