Timesheet & Project Management Blog

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

LET'S CONNECT!
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

FREE TRIAL


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
E-mail
Invalid email address.
Number of Employees
How many employees will use this?
Enter the text below
Enter the text below
Please enter the text above