- Category: Blog
- Published: Monday, 17 June 2019 14:45
- Written by Ray White
From http://www.stdtime.com It is possible in Standard Time® to create custom fields for user definable input and display those columns in views like this. This video will show how to rename the underlying database column name so that it could be used in calculations in scripts and reports. Now this is an advanced video that only applies to those people who have created custom columns.
I’m going to go to the View menu to get started; choose Columns then click Custom Fields. Here you can see a few custom fields that I’ve created and down below you see the column name in the database. Now that’s a pretty ugly name, long name, that you get by default when you click the Add Field button. I want to rename that so it has a more human readable name that I can use in scripts and calculations. To do that I’ll start by clicking the Column Name button. This warning is telling me that all the other Standard Time clients must be closed before proceeding. That is because they will get an error when the database column name changes. I’ll go ahead and click yes; this gives me a suggestion, I can go ahead and change that if I want, click OK.
It was renamed successfully; it is again telling me that all the other clients must be closed and reopened or they might get an error. Now you see the new name down below. If I click on the other one you see the ugly name that was there by default and back to this one you have a nice beautiful name that can be used in SQL scripts or reporting. Hope that helps!
See more at: http://www.stdtime.com
Standard Time ► http://www.stdtime.com
Twitter ► http://twitter.com/ScoutwestInc
Facebook ► http://www.facebook.com/timesheetsoftware
Linkedin ► http://www.linkedin.com/company/scoutwestinc
Pinterest ► http://www.pinterest.com/scoutwestinc
Android App ► http://play.google.com/store/apps/details?id=com.scoutwest.standardtime