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.
It's easy to write rules.
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 G->A, F->B, A:E->C:G
Copies these data to sheet named 'Approved'.
Add these data the last row of the sheet.
Let's see how to add these conditions.
   Give the rule a name
   Select the rule type as 'Simple'.
   The other types of rules are 'On Edit', 'On Form Submit', and 'Time Driven'
   Add the conditions
   You can use a variety of check cases such as 'Is equal', 'Is not equal' 'Is less than', 'Is less than or equal', 'Is greater than', 'Is greater than or equal', 'Contains', 'Does not contains'
   And for date based checks you can use the following, 'Date is equal', 'Date is not equal', 'Date is less than', 'Date is less than or equal', 'Date is greater than', 'Date is greater than or equal'
   Tell what to do when the conditions are met
   You can Copy, Cut, or Clear the range or even delete the row that matches the conditions described earlier.
   You can even move the data to a sheet in a different spreadsheet.
   This tells whether the same row need to be checked for the next rule, This is very important and very powerful
   If there is a situtaion that all 'Approved' need to be moved to 'Approved' sheet, also in the same row, if the date is today then move to 'New Cases', then you can use this option. Just check 'Continue to next rule' as 'Yes'.
   Program will keep on checking for the next rules.
Now you know about the very basic working of FLOW. You can add any number of conditions and any number of rules. We will get into more complex rules later. Let now look at triggers.
Triggers
Another best part of FLOW is the availability of triggers. There are three types of triggers.
   On Edit
Runs a set of rules when a user edits a cell. These rules only on a the sheet sprcified in the rule. Any edits happens of sheet other than the one specified will be discarded.
   On Form Sumbit
Runs when the spreadsheet receives a form submission. You can have any number of forms linked to the spreadsheet. These rules are very useful when you have a situation where a set data need to moved when ever a there is a new form response.
   Time Driven
Runs set of rules at the a given time or on specific time intervals. Very useful if you want to run a set of rules every day/week/month. The smallest interval that you can choose is every hour.
Now lets write some rule with some real data. You can get these data from this spreadsheet. The data consist of list of orders that an organisation has got. Let first write rules which will move "Desk" and "Binder" to a sheet named "Desk/Binder". To do this we will have to write two rules, one which checks for Desk and another which checks for Binder.
The below rule will move all items which has 'Desk' in column D to the sheet named Desk/Binder
Next set of rules that I need to write is for "Pen" and "Pencil". Since both the words contains "Pen", I can use the check "Contains". But the end result what I need is as follows, If the item is Pen/Pencil then move row to sheet named "Pen/Pencil". Also do another check on the same row and if the order date is less than 01/05/2018 (MM/DD/YYYY) then move the data to "Old Orders". Here we need to run two rules on the same rows, to achieve this we set the keyword called "Continue to next rule" as "Yes".
Rule 1, to move pen and pencil
Rule 2, to move old orders
We are stoping here for now, but this is not the end, we will be soon posting videos turorial, please watch this space for the same.
If you have any doubt please let us know, You can reach us at addon@elifent.tech