I thought of implementing some validation logic to my Data form and also test the new functionality.
1st rule was to tell the user that Negative values are not permitted for FY11 Sales Budget.
So I defined a rule for Column B (Sales -. Budget)
You can define rules for the entire Grid, Columns, Rows, Cells
Add a if condition saying if Column B (in the pic it is Column C….I was doing something interesting so from now read Column C as B :)) < 0…..and now add a THEN condition.
THEN condition illustration below.
You can add a Validation message to the users and can have a Back ground color also….interesting isn’t it?
When I found that I can add a background color…..I thought of adding more colors…..colors can convey a lot more than numbers….
I defined a traffic lighting in Planning DataForm…..So that the users can budget accordingly looking at the Actual Sales.
So if the Sales was <= 10000 then cell color will show RED, which means Actual Sales was less for that region
If Sales was between 10000 and 50000 then YELLOW – Sales is doing fine.
If above 50000 then GREEN – Sale is great.
For Traffic Lighting don’t add anything as Validation Message and don’t check the option of displaying the validation message.
I tired to accommodate it in a single rule….but then the coloring convention was not working…..the last color was applied to all the conditions!!!!!
Adding Formula Rows in Planning Data Form
I feel like the DataForm design has changed so much that I feel that I’m creating a report not a data form.
So I played around a little with the Formula rows….I thought why not Rank the Actual Sales.
You can see which STATE did the best selling.
So I added a Column B (and applied a formula there) Rank([A],descending) (the column representation resembles Financial Reporting formulas)
So we are all set to test the new DataForm…..and here we go.
In order to test the validation I entered -1 for Budget.
I got a RED cell and the validation message saying not to enter Negative Values.
However it allowed me to enter -1 (-1 was saved to the Database) which I didn’t like much…..ValidateData.js has options where it’ll not allow the erroneous data to enter into the system.
But hope that this will get changed in the new releases. (Coloring of the cells and Formula rows are very good)