Rukovoditel Support Forum

Hi, I'm using MySQL query in formula field [1052]. Formula is [1018]*[1194], which works well. entity.jpg Then I'm linking results in other entity with related items [1186] and using function {48:1186} to calculate total cost of attached items. Function doesn't work if "perform dynamically"...

If I understand correctly what you want, it's possible with additional MySQL formula field that display different fields in one listing column depending of choice: case when [radio button field] = choise1 then [show pattern1] when [radio button field] = choise2 then [show pattern2] when [radio butto...

It's possible in theory, but in general case if there is field value it will be more than zero. It guess it will be best if query returns null instead of 0 when it can't find field to select. Then maybe query field can be set to "hide if null"?

Yes, I guess that will work.

Please look what I mean: Order can have up to 4 prices for different services. But not all services are used in every order, so here there are prices only for 2 services, but query shows 0 for the missing services. I don't need to show these as they are not used in this order.

Hi, it would be nice if you can hide the result of MySQL query if query is empty, like numerical fields can be hidden. For example you have to make a query for each order, but in some orders the result will be empty and that query will not be used, it can be hidden instead of showing "0" r...

You can use font awesome icons as values, maybe you should try and see if they are visible in email too. For example this is a code for check:

Then I guess this field can't be selected or don't return correctly formatted value.

Hi, value from parent entity can't be used in formulas, that's why it don't work. You should use Select function instead.

Hi, to calculate future date you can use MySQL formula : FROM_UNIXTIME([date]+[days]*86400,'%d-%m-%Y') Here you need to replace "date" with a date field or added record date, and "days" with the period in the future that will pass. The output will be you initial date + specified ...