FLOW Have you ever come across situations where you need to move
a data from one sheet to another sheet based on some
condition and you don't know how to write app script codes
for it?
We are giving you tools that will enable you to do this just by adding some simple rules. Let's dive in.
We are giving you tools that will enable you to do this just by adding some simple rules. Let's dive in.
To get started,
install
the addon from Gsuite Marketplace. It free to get started.
Suppose that you need to write a rule which work as follow.
If at column 'F' value is equal 'Approved' then Copy data from range A:F->B:G, G->A
Copies these data to sheet named 'Approved'.
Let's see how to add these conditions.
Give the rule a name
Flow in are the rule that helps to bring data from a
different spreadsheet or website
Flow out are the rules that helps to move data out
from the selected sheet. We need to move all the
appoved from one sheet to another, hence we need to
seelct flow out.
Describes when you need the rule to get executed.
Manual rules need to be run manually by the user. On
edit and On form submit will run automatically when such
an event occurs in the spreadsheet.
Select the sheet at which you need this rule to be
exucuted.
You can even add this rule to schedule, so that it can
run automatically at the given time. But, also make sure
that you have added schedules.
Give the conditions
You can add any number of conditions.
A rule will run success when all the conditions are
checked and found true
Select the action that need to be done when the
conditions are found success. It can Copy, Cut, Clear
and Delete
Give the range that need to be Copied.
Give the spreasheet id where the data need to be pasted.
Give the range to where the data need to be pasted
If you need the previous data to be kept intact, than
check the "Append"
If you have any doubt please let us know, You can reach us at [email protected]