Let's see:
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNF8WhWMH8D0510Y-oCH5k3NizpIgQ6bWuZ17cajXhGyCX-lSqbBbWhrKPDU9YXNREKleMLr4UkBKKarn4gv6UgsgNdirRprioMSeJ9sNfyPYRJgDS9E17QLDHNZ3599p5TCdFEXjP77rK/s400/gyro1.png)
New formulas, a lot easier to use:
QueryDB("select sum(`product`.`price`) from product inner join `rel_order_products` on `id_product`=`id` where `id_order`=$id") * (100-Discount)/100 + Shipping_fees
As you can see, it is a combined formula, using both a query and Concept computations (in red).
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqlMESo7kUSXF8AX0fC7wokCrDXLKS_JCG92zWcYXWJQkE7K4nc2xhoojvvoXdYryZi5jQFCjVEUz7nApIol3SiR8fXmV7rrinmU9gurdFKRGrBrILz-HLt-TZ1e2KdvvSw9oA-pcBlQ2F/s400/gyro2.png)
[A-Za-z0-9_\.\-]+\@[A-Za-z0-9_\.\-]+\.[A-Za-z0-9_\.\-]+
it validates an email address.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfPn6bEMdAUzD7bTg9EG_xighhR2R7Rg3iHulZ-jUP0eYYh_QUuFSNTBBhuu6An-5HvGJUY-BX_Z-FtesHWAz1ZiLZ9-mC4X2thNlOmmNnnqFUd9-bTkj_CTp27ZvzWnSzk8HoPPzTDfW9/s400/gyro3.png)
User defined functions can be now defined directly from GyroGears, without any need to open CIDE (see the button).
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi8brIjqMus7UDbd3qaNZyxldA6j71SGvN8LOrNxjyTgpdj5NeDbYBOstEV1mLMjG1_SC5EfyC7hp4AMARd4PCjtnHbx1OFHtNcwXxWv6hvfGpUqv5v8-7G4_2pEgoD04oo0gEcDDk633J3/s400/gyro4.png)
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKjMmr-xsaAiVq-GdepHWrX6XJGuLn9mx-m9Uv-zRGX8Sli-DJeIW_9CAbCjE_obAwUE4KXchTXq6bI5NYmSrRYcUd4vh1Y0ioD6bFQmJ885c9WcVQ08W0PY3k7WtS3qxQ48FUwKQf8Nhu/s400/gyro5.png)
A reference relation is a virtual relation to a member in a related entity. Then, that object will be mapped in the referring object. Look at the next screenshot to see exactly how it works.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6lG_SSNneZo-ZAHII6UuJRHLMyGDRnGtnh4z4KhLTVvMSkHb-QHW8Z9GGxU1GvM_Ut0_0uGgonXmcwTZjP0kC6t1-s89r2ur9ndZEj1SkAMx84jF8hfPINtEqjTxbGQsSTB7vvvNh0Jps/s400/gyro6.png)
For example, a blog post has comments and images. Each image has its own comments. So, you can add a reference to Image/Comments in the Post entity. This way, the end-user can see all the comments for all the images for a specific post.
A lots of bug were fixes in various areas (especially in reporting and web sources).