MySQL calculation or JS update

Any critical bugs will be fixed within 24-48 hours.
Post Reply
rmcdonald
Sponsor
Sponsor
Posts: 243
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

MySQL calculation or JS update

Post by rmcdonald »

Is there a way to force a Mysql formula or JS formula to update accross multiple records ? using with selected ? this has worked in previous versions where we make an update with selected and the system recalculates the mysql formula ?

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: MySQL calculation or JS update

Post by support »

mysql query field type recalculate values.

rmcdonald
Sponsor
Sponsor
Posts: 243
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: MySQL calculation or JS update

Post by rmcdonald »

Yes thats what I thought but they arent , they are only recalculating when I open the record ?

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: MySQL calculation or JS update

Post by support »

There is option to dynamic calculation so it will be calculate once you open item. If static, then calculation will be once you update item.

rmcdonald
Sponsor
Sponsor
Posts: 243
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: MySQL calculation or JS update

Post by rmcdonald »

Yes we have it on dynamic and it is still not updating, even when we bulk update fields across items

rmcdonald
Sponsor
Sponsor
Posts: 243
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: MySQL calculation or JS update

Post by rmcdonald »

In formula there is no option to perform dynamically the dynamic option is only in query field

User avatar
support
Site Admin
Posts: 3775
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: MySQL calculation or JS update

Post by support »

Formula always run dynamically

rmcdonald
Sponsor
Sponsor
Posts: 243
Joined: 19 Dec 2018, 02:33
Name: Robert McDonald
Location: Auckland, New Zealand
Company Name: Unicloud

Re: MySQL calculation or JS update

Post by rmcdonald »

Very strange - its not running - Same instance as I sent you login today , logbook entity total hours

Post Reply