News & Activity Feed

New Video: Making Reports »
Learn to create reports for your apps. We will create an order form with a matching invoice report. The report is based on a custom data controller representing order details.
Monday, November 18, 2019 9:54 PM | Aaron 'Shegs' Shegrud
"Method [company].Rules.SharedBusinessRules.UserRoles not found" when attempting to get the user role from @BusinessRules_UserRoles in an SQL Validation Rule.
Monday, November 18, 2019 2:26 PM | uremovic
Something is wrong with the user interface (see 2 pics).

What could be the problem? Something go wrong with the css?

I am using latest COT version.
Friday, November 15, 2019 6:34 PM | Aaron 'Shegs' Shegrud
I created a new app
opened Visual studio to do some work
was about to enable git when I realized it was already enabled and connected to the wrong repo...

I've been looking for how to disconnect it and create a new one, but I can't seem to find it.
Friday, November 15, 2019 2:15 PM | bp app
All of a sudden I'm getting:

Cannot insert the value NULL into column 'UserID', table 'DATABASE.dbo.Users'; column does not allow nulls. INSERT fails.
The statement has been terminated

I have tried every solution mentioned on this forum including 'Allow Null Values', check, unchecked "Values of this field cannot be edited." all in vain

Can anyone please help?

Friday, November 15, 2019 1:52 AM | altVader
Hello COT developers,

I have a simple createForm1 for anonymous users to create a record. I have a business rule in insert, execute that does a showAlert to inform the user the record was successfully saved. Works great up to this point.

In another business rule (insert, after) I have a result.navigateURL to move the user off the createForm1. Tracing, the code does get hit but it does not navigate to the target (home.aspx). I believe it's because the code runs on before the user can respond to the showAlert.

Has anyone handled this scenario in a better way? See where I'm making an error?

Thursday, November 14, 2019 2:18 AM | display operator
I recently moved my CoT app to a new webhost with a new database (same db from backup) Whenever I try to add a new record to any table, I get the error - index out of bounds of array. All of the data is loading ok. I can't add a record either for auto increment fields or fields where I am creating the key manually.

It must have something to do with the new database -db name maybe, but where can I start to look? All get is a little popup div in the browser window. No error in visual studio.

ver 8.7.14

Wednesday, November 13, 2019 9:47 PM | uremovic
I have a wizard and in one step I need to upload a photo. I have used tutorial for blob file system adapter (only using virtual fields for File, FileName, ContentType and Length because I don't need this data in database table).

After setting "Changing of the field value causes "Calculate" command to execute" for File field and creating business rule for Custom, Execute I am able to enter this method after choosing picture. BUT - in instance model there are no values for File, FileName, ContentType and Length.

How can I get these values to be able to make some checks on image (size, height, width, etc.)? Is it possible via c# business rule?

Thanks in advance!
Wednesday, November 13, 2019 8:30 PM | uremovic
What should be proper size of splash image (background)? I have tried to put several images and there are some disorders in them.
Tuesday, November 12, 2019 8:44 PM | uremovic
What would be the easiest way to validate data when user clicks "Next" button in auto generated wizard in TouchUI (
It seems that "next" and "previous" buttons are generated in runtime and I don't know how to make business rules in c# on them.

Tuesday, November 12, 2019 2:56 PM | Tom Graham
I have an app using custom membership. When clicking "My Account" the myAccountForm opens but the username and email are not populating any longer. Not sure what has changed?


Monday, November 11, 2019 9:25 AM | Benny Kurien

I am a unlimited user
I have additional field called organization name in the users table. How can I show this organization name in the application footer or header near to the username once the user signedin

I am using custom membership tables

Thank you
Monday, November 11, 2019 1:21 AM | Zack

Took me a bit to find this.
Sunday, November 10, 2019 11:07 AM | sdms
I have bit field in my database table which displays on my grid as a checkbox which is what I want it to do. I have enabled inline editing for this grid and would like to ask two questions relating to checkboxes:
1. To activate/edit the checkbox I have to double click it, is this normal functionality?
I am assuming the double click is once to select the row and the second click is to activate that field?
2. When I go to edit the checkbox it turns into a list (see below image) which I have to select Yes or No. What I would like is to simply click the checkbox and the tick would either be removed or the tick would appear i.e. no list which I have to select yes or no.

Sunday, November 10, 2019 12:09 AM | sdms
I was searching the forums and found this post from 4 years ago regarding how to only edit one field in the grid when using inline editing.

In addition to this I only wanted the users to add a new record by selecting the New Record in the action bar and not via the grid itself i.e. the plus (+) icon that displays at the bottom of the grid.

Option 1

As per the above post I made all of the columns read only with the exception of the column I wanted the user to be able to update. Then on that controller under ag1 (Grid) I changed a7 - New, grid1 to have a role of Administrators (if you don't have an administrator role then you would need to create a role that your general users wouldn't have and use that role for this).


Option 2
I also use virtualization so using the below achieves the same result and is easier to control rather than hard coding the actions under the controller (just remove the role referenced in option 1 above that you assigned to the grid under the controller TAB as it's not required for this option to work).

NodeSet().SelectActionGroups("Grid") _
.SelectAction("a7") _

(Note: the above code snippet has to be properly located in your code where you are controlling your virtualization for it to function correctly)

Hopefully these options may assist others that want to achieve the same sort of result.
Saturday, November 9, 2019 9:41 PM | Ola
It appears the instructions posted in the video FORCING USERS TO ACT -
The instruction works for SPA but not for ASPX, am I getting something wrong or that is the design?

I have an ASP project that it works for, but it is unresponsive for similar ASPX project, can somebody/COT point me in the right direction?

Many thanks.
Saturday, November 9, 2019 7:29 PM | Per Lindsø Larsen
Is it possible to disable HTML-Encoding on the Agenda-View in Calendar. If I disable encoding for the field in the controller, it works on all other views in Calendar, and it even works in the popup that is shown on mouse hover in the agenda.
Saturday, November 9, 2019 2:55 PM | bp app
Friday, November 8, 2019 11:02 PM | altVader
I'd like to enable multi-select in a grid by default. Does anyone know the tag for this (if there is one)?
Friday, November 8, 2019 9:51 PM | Tom Graham
I was experimenting with OAuth and then switched back to custom membership and role providers. The My Account link did not reappear. I have no entries in the SiteContent table and the login seems to work, just no access to the My Account link. I also have refreshed and generated the app several times.

Any ideas? Thanks!
Friday, November 8, 2019 6:55 PM | roberto.ivon
This question was posted some time ago. I wonder if it is currently possible,

Best regards,

See All Posts