Hashing Password On Form When Not Blank
In the Process Record Values event of the Edit page (Add page not necessary because the field will already be blank). Then in the Before Record Added/Updated events on the add and edit pages.
Change column display value in List
This is how you can display a different value in a list than what is stored in the database. In this example I stored “0” in the timecard table for Clock In and “1” for Clock Out.
Use codes for Checkbox and static radio buttons/droplists
In the “Before record added” event for both the Add page and Edit Page, use the following code to convert the value in the database to what is expected on the page. Then in the “Before record added” event of the Add page and the “Before record updated” event of the Edit page, use the
Read More »
Default Values for Search Fields
In the “After table initialized” event for the table, add the following code. Note, this code is for a DateTime column and sets it to a BETWEEN search type for the current day.
Pre-Populate Fields on Add from Search
To pre-populate fields from extended search parameters when adding a new record, use the following code in the row_rendering event. If the field is a table lookup: If the field is a regular edit field:
Server Variables in ASP.Net Core
var username = Microsoft.AspNetCore.Http.HttpContextServerVariableExtensions.GetServerVariable(HttpContext, "eduPersonPrincipalName");if (!string.IsNullOrWhiteSpace(username))username = username.Split('@')[0];
Remove the Time from a DateTime column
DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
Select All Checkbox Jquery
This jQuery script will allow a select all checkbox in the header to toggle the check boxes in an editable grid. Rename NotifySelectAll to the toggle checkbox id and NotifyChk to the id of the check boxes in the grid. Note: the jQuery select is looking for ID’s that end with specified id. So if there
Read More »
Using Menu Builder with Designs
I like using table (Data Source) generated menus in my CCS apps but they don’t work when using Artisteer designs. So I’ve come up with a workaround so the CCS menu builder control will display properly with Artisteer designs. I’m using the ASP.Net VB InMotion templates and don’t know if it will work with any other templates. Also, my
Read More »