Changes made in Code On Time

In order to preserve the promise of transparency and open communication, the change log records changes to topics made by both customers and employees. Anyone can dispute a change by clicking the "Dispute" link and entering additional details.


  • December 03, 2019 19:20
    Ossama, the poster:
    Reason: removed by the poster
  • December 01, 2019 23:32
    sdms
    Changed reply in topic of Filter based on page by sdms to Hopefully I have understood what you are trying to do. If you have created several copies of grid1 as different pages you can set the fields you don’t want visible for each of the grid views to hidden using the hidden property for that field on that grid. The same should also be possible using dynamic access control rules providing each of your grids are defined in your dynamic access control rules. Will have a look when I get home this evening for a code snippet I can post for something similar I do on one of my other form views. .
  • November 27, 2019 04:48
    sdms
    Changed reply in topic of recommended hostings for codeontime apps by sdms to I have one hosted in Microsoft Azure at the moment, early days but so far so good. Publishing it straight from the COT interface to Azure was so easy once you have everything set up. All I do now is press my publish menu and it’s done in a matter of seconds .
  • November 25, 2019 15:15
    tim cullis, the poster:
    Reason: removed by the poster
  • November 25, 2019 07:23
    sdms
    Changed reply in topic of Filter region based on users by sdms to Hi, as Tim suggested look at dynamic access control rules. I use them to filter data based on what school the user belongs to. As long as there is a relationship between your users and your regions in the database it should all work. The relationship also needs to be in the tables that you want to be able to filter on in this way. For example if you want users to only see records based on the region they are authorised to see in a table that has sales data in it you would need to record the region name against each record in the sales table..
  • November 25, 2019 07:22
    sdms
    Changed reply in topic of Filter region based on users by sdms to Hi, as Tim suggested look at dynamic access control rules. I use them to filter data based on what school the user belongs to. As long as there is a relationship between your users and your regions in the database it should all work. The relationship also needs to be in the tables that you want to be able to filter on in this way. For example if you want users to only see records based on the region they are authorised to see in a table that has sales data in it you would need to record the region name against each recordsin the sales table. .
  • November 25, 2019 05:21
    Ho Chung Shun
    Changed description of I want to do a filtering function which will automatically filter the region based on the users. For example, if the users are assigned to region "London", they can view data that has assigned with region "London" or when users are assigned to region "San Francisco", they can only view data that has assigned with region "San Francisco". Please assist. by Ho Chung Shun to I want to do a filtering function which will automatically filter the region based on the users. For example, if the users are assigned to region "London", they can view data that has assigned with region "London" or when users are assigned to region "San Francisco", they can only view data that has assigned with region "San Francisco". Please assist as I just started using Code On Time. Thank you..
  • November 23, 2019 18:15
    tim cullis
    Changed reply in topic of Announcing Offline Sync Add-On by tim cullis to Hi. For what I believe COT has explained is that you would create a view for the 75 users would need. This view you would protect with a role, offline-role. That way only the 75 offline users would have the. Offline ability and be within the license..
  • November 20, 2019 14:21
    bp app, the poster:
    Reason: removed by the poster
  • November 20, 2019 07:36
    sdms
    Changed reply in topic of Different createForm1 for dataview vs grid1 by sdms to Not sure if I have interpreted your question correctly but If you are going to create a record using the All Customers Visit create1 page you will need that look up on the create page in order to relate the visit to the parent record. You could just remove that look up field from grid1 and the edit page or mark it as hidden if you didn’t want to see it. If I have misunderstood my apology maybe if you post a screenshot.
  • November 20, 2019 07:35
    sdms
    Changed reply in topic of Different createForm1 for dataview vs grid1 by sdms to Not sure if I have interpreted your question correctly but If you are going to create a record using the All Customers Visit create1 page you will need that look up on the create page in order to relate the visit to the parent record. You could just remove that look up field from grid1 and the edit page or mark it as hidden if you didn’t want to see it. If I have misunderstood my apology maybe if you post screenshot.
  • November 18, 2019 22:31
    tim cullis
    Changed reply in topic of Method [company].Rules.SharedBusinessRules.UserRoles not found by tim cullis to Hi. Does this snippet from support help ? <br /><br /> TESTING ROLES IN SQL BUSINESS RULES <br /><br /> Developers can now access parameter @BusinessRules_UserRoles in the code of SQL Business Rules and test user roles for conditional processing. <br /><br /> For example, create a Transact-SQL business rule in Products data controller may look as follows: <br /><br /> if @UnitPrice &gt; 30 AND CHARINDEX('Administrators', @BusinessRules_UserRoles) = 0 <br /> set @Result_Error = 'Only admin can set a high price!' <br /> Set Command Name of the rule to Insert|Update and Phase to Before. Run the app, login with a non-administrative account, and try to update a product with a price higher than $30. <br /><br /> SQL business rules tests user Roles to prevent data input in an app created with Code On Time app generator. <br /><br /> Use the corresponding “contains” function and parameter marker in front of “BusinessRules_UserRoles” when working with the database engines other than Microsoft SQL Server.. Also ... Customer Service, Company Admin 7267 Posts 438 Reply Likes Parameter @BusinessRules_UserName returns the value of the property BusinessRules.UserName. This is the implementation of it: public static string UserName { \ get { return System.Web.HttpContext.Current.User.Identity.Name; \ } } .
  • November 18, 2019 22:21
    sdms
    Changed reply in topic of How to write business rule for image/picture/blob check controls before saving image? by sdms to Hi Uremovic, i store the values in my table but as long as you have the calculated values available at the time of doing the checking I would think you would be able to get this to work. I will post the code I am using when I get home In about 12 hours. You should be able to adapt it for your scenario. The code will be in VB. I check for file size and stop the image from being saved and display a message to the user. The more I think about it it might be JavaScript I am running , will know when I get home.
  • November 18, 2019 07:09
    sdms
    Changed reply in topic of A replacement for captcha? by sdms to It would be nice John if you could just add a tag to any of your create pages ... captcha-type1-enable or captcha-type2-enable and it added in the captcha you needed (text or pictures) depending on the tag type. I am thinking of doing a one page app with single user details and getting my prospective clients to sign in with generic credentials so they can then access my registration page but not sure if I it’s the correct path to take .
  • November 15, 2019 07:28
    Ho Chung Shun, the poster:
    Reason: removed by the poster
  • November 13, 2019 13:20
    Tom Graham, the poster:
    Reason: removed by the poster
  • November 13, 2019 13:20
    Tom Graham, the poster:
    Reason: removed by the poster
  • November 08, 2019 20:00
    altVader, the poster:
    Reason: removed by the poster
  • November 08, 2019 00:57
    altVader, the poster:
    Reason: removed by the poster
  • November 06, 2019 17:56
    Aaron 'Shegs' Shegrud, the poster:
    Reason: removed by the poster
next » « previous