News & Activity Feed

Monday, December 17, 2018 2:54 PM | Emilia
I have created custom form template following COTs video tutorial about forms. I have added buttons next to one field and would like those buttons to either add or remove 0.5 from that field's value

Here's my code in createform1 view template:

When exploring Chrome developer tools it seems to add the value to the correct field but when I save the record this value doesn't get saved to database. If I don't use these buttons but write the value to that field it works without problems. How can I pass this value that I edit using these buttons to database when user presses "Save"?
Sunday, December 16, 2018 6:12 AM | xh

Is there any way to refresh the master view in editForm view when its been child view data edited or updated?

Thank you.
Saturday, December 15, 2018 5:49 PM | Paul
I verified that this does not pass the value of a context field. The other end of the lookup ALWAYS evaluates to NULL.



The filter logic should NOT return anything because the context field is NOT NULL but the lookup returns ALL rows.

***Using PostgreSQL but that should not matter
Saturday, December 15, 2018 2:49 PM | BEN
I have a calculated field named [userRole] that contains the value @BusinessRules_UserRoles computed at run time by SQL expression.

The calculated field [userRole] displays properly the current user role in the grid but
the grid is broken and it's unable to open the form that contain the different categories with conditional display based on the current user role.

On the other hand the conditional display of a category works properly with a database fields in the JavaScript expression entered in "Visible When" in the Designer but it doesn't work with a calculated field [userRole].

Please help.

Thank you.
Saturday, December 15, 2018 2:13 PM | xh

If I want to search for value, for example, tax rate from a table that is not connected as the default value for a PO and later the user can change the value. How can I do it in COT context?

Friday, December 14, 2018 11:34 PM | Tom Kustura
Is it possible to display a grid on desktop screens and list on mobile screens (tablets and phones) for the same page/view? If not, is it possible do display a different grid for different screen size?

Reason for this is that grid works well on large screens but when the user switches to a mobile device then it becomes cumbersome to scroll left-right to see all the data. Also, it is not reasonable to ask users to switch view based on the device that they are using, this should be built into the app.
Friday, December 14, 2018 3:54 PM | AdamW
Today i purchased an upgrade from premium to unlimited for some required features.

My code still says i have the premium version and has not been updated.

Has any else had to wait a certain amount of time before COT decided to upgrade it so you can get on with using it?

I have wrote to support but had no answer and been waiting all day for this.

Took the money quick enough!
Friday, December 14, 2018 3:21 PM | Jesse Sasso
What stylesheets need to be altered to change the checkbox toggle 'on' color? I've modified touch-theme.css, but the value still seems to be overridden by another setting.

Friday, December 14, 2018 10:44 AM | Moh Fajrin
Hi CoT team,

I’d like to add an icon in main menu not in child menu. Is this possible to achieve?
If possible kindly need your guide here.

Thank you

COT 8.7.6 mysql win 10
Thursday, December 13, 2018 8:44 AM | xh

I tried to import around 4K rows of data into the Product table.
But import performance was really slow, took around 20 minutes to complete
I have the import-duplicate-test on barcode field and import-duplicate-accept on the cost price and sell price field.

What is the best practice here? Thanks.
Wednesday, December 12, 2018 10:53 PM | allen
I just noticed this, after upgrading to 8.7.6, the My Account link is missing from Touch UI. Users can no longer change their password. This is another deal breaker for 8.7.6.
Wednesday, December 12, 2018 10:31 PM | allen
Using 8.7.6, when I regenerate the app it deletes my ApplicationServices.Custom.cs file. This is a deal breaker for 8.7.6.
Wednesday, December 12, 2018 10:16 AM | Deepak Arya
Hi,Any One Share with me latest COT with $150 ThanksDA
Wednesday, December 12, 2018 10:11 AM | Deepak Arya
Hi,Any One Share with me latest COT with $150 ThanksDA
Wednesday, December 12, 2018 7:40 AM | Nahuel Gonzalez
I happen to have a pie chart where the categories are fixed (OK, Warning, Error, etc). The colors are chosen automatically and they do not fit correctly with the labels; say, Error is shown in green and OK in orange. Is there a way to set a certain color to a category in a pie chart?
Wednesday, December 12, 2018 7:37 AM | Customer Service

Create complex multi-tenant applications with data segregation by user identity. It takes only a few lines of code placed in shared business rules.

It easy to keep track of user activities and to associate the current user with the new data their create. Learn to write a universal handler for SQL INSERT commands that were successfully completed.
Tuesday, December 11, 2018 10:15 PM | Brent Higgs
Okay I have searched the forum and online to see if I could come up with a solution to this.

I have a couple of charts that are displaying counts per month and year a variety of different data fields.

These fields charts use the standard Calendar of January to December, where for business fiscal year is December to November

I would prefer this to be a global rule across all controllers. This could also be a feature that is implemented in the COT Project Settings
Tuesday, December 11, 2018 7:52 PM | Chuck
How can you add or modify static dropdown items using a Javascript business rule?
Tuesday, December 11, 2018 4:33 PM | John Willems
I finally upgraded to v.8.7.6. When I browse my app I now get this error. Nothing changed in the app. The only difference is COT versions.


Tuesday, December 11, 2018 9:48 AM | xh
Hi COT, I have the formula below in SQL Formula, is there anyway to check if the SellPrice is zero before the calculation to prevent the divide zero error?

(Products.SellPrice - Products.CostPrice) / Products.SellPrice

Thank you.
See All Posts