Timesheet & Project Management Blog

The goal of this blog is to provide tips and ideas for improving time tracking and project managment for our customers and other interested people.

Rename Custom Database Columns

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

Custom Fields In Reports

From http://www.stdtime.com This video describes how to put custom fields onto reports. To begin you can see I have the Project Tasks tab selected and I have a couple columns here that are custom fields. You may not realize that but I’ve actually added these as custom values. I’ve entered some values and some other values are computed. If you go to the View menu and choose Columns and then click Custom Fields you can see these extra fields that I’ve added.

What I want to do is put these onto a report. These are the two fields I’ll put on the report and the first thing I’ll draw your attention to is this long, ugly number down at the bottom of this dialog box. That is the data base column that would be added to the report. You may have renamed this column but this is the default format that they come in. Write these numbers down so that you can drag and drop them onto a report. Let’s go ahead and close this.

I’m going to run a Project Tasks report, click OK. The first thing you should do is go to the File menu and choose “Save As.” Don’t change this report because you may want to go back to it as your default. Always choose File “save as” and create a completely different report. Then we’re going to go into the Design View; I’ve got a couple columns here that I’ll get rid of and we’ll put in our custom fields. This first one was the margin, so let’s rename the header and then we had CostPlus.

The next thing we’ll do is click on this tab that says Fields. And you see some of the database tables that are included in this report. Yours may look different depending on which tables are available. I’m going to open up the Project Tasks table, scroll down and we’re going to find all of the fields that I can drag and drop onto the report.

The first one, you remember, was this one. Let’s drag that onto there, these are the ones I asked you to write down. I’ll take this and right align it so that it looks real nice as a number. Go back in here and do the next thing with this one.

We’ve dragged both of those onto the report and resized them and changed the alignment so they look nicer. So we’ve Margin and CostPlus and these are the custom fields that are in the database. We’re working in the Design View; we’ll go back up to the Preview tab and click that. Then scroll down here to that project that we saw earlier. Those are the custom values that we saw earlier on the Project Tasks tab.

They show up here in the report because I dragged them from the fields over onto the detail section of the report. Of course you can drop that into any section that you would like but we happen to be working on the detail section so I dragged them there and that is how they show up. You’ll want to choose File, Save As but in my case I’m going to close the report and not save and here are the values again on the Project Tasks tab. Hope this tutorial helped!

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
iOS App ► http://itunes.apple.com/us/app/standard-time/id818412788
YouTube Subscribe ► http://www.youtube.com/subscription_center?add_user=scoutwestinc

Manufacturing Productivity

Contact the manufacturing productivity experts for project scheduling, barcode scanning, collecting actual work and inventory usage.

Standard Time® Graphical Timesheet

From http://www.stdtime.com Here’s a quick video showing how to use the graphical timesheet in Standard Time®. You’ll notice seven tabs along the top. I have the Timesheet tab selected; then click this little gray triangle over to the left, choose Graphical Timesheet. You’ll also notice there is an expense sheet for entering materials and expenses. And there are some other options here for the regular timesheet.

Let’s choose Graphical Timesheet and there are already some entries in here. You can double click on them to enter notes and other choices. But if you want to enter a new selection simply drag, drop and enter your notes here. Click save and close, in this case it wants me to choose a project for the job that I’m doing. And probably is going to want me to choose a task. Once I’ve done that click save and close.

I now have that entry. I can drag and drop to change the times or duration. Or again double click on it to put in more notes or choose other options. That’s how it works. You can switch back and forth between the graphical timesheet and the normal calendar timesheet to see your time log entries. Hope it 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
Google+ ► http://plus.google.com/114409741935383434971
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
iOS App ► http://itunes.apple.com/us/app/standard-time/id818412788
YouTube Subscribe ► http://www.youtube.com/subscription_center?add_user=scoutwestinc

Tablets on the Mfg Shop Floor

Here's a quick way to get actual employee hours on the shop floor: use a cheap tablet with a barcode scanner. Scan jobs, tasks, and materials. Now you know exactly what jobs are in progress, and what materials are being used. See more at https://www.stdtime.com/barcode.htm

Use barcodes for task status on the shop floor

 

Get task status on the shop floor by scanning barcodes. In fact, just look up on the big screen for a Work In Progress display. The last task status is display in WIP. Employees start and stop timers, record task and project status, and record materials used -- all from barcodes.

Update Your MFG with Barcode Time Tracking

 

Consider updating your mfg shop with barcode time tracking. Scan work orders and tasks at each stage of the manufacturing process. Now you know who worked on the job last, what stage it is in, and the estimated completion time.
 
 
 

Mfg software

 

Track manufacturing hours using barcodes.
 
 

Shop Floor Barcode Scanning

Hi everyone, Ray White from Mfg Projects I’m here to introduce you to barcode time tracking on the manufacturing floor. There are a lot of advantages to tracking time right on the shop floor with barcode scanners. Consider these three to start:

1. First, you’ve got work orders or manufacturing projects, but how do you get actual work hours from employees that don’t use computers? Or don’t sit in front of a workstation? The answer is, with barcode scanners. That’s advantage number one, and it’s a big one.

2. Number two; barcode scans are the most accurate way to track projects. No more fat finger, mouse, clicking, fake time entries, trying to remember what you did last Tuesday, or last week. You just scan… bleep, bleep, bleep, and a timer starts. Bleep, bleep again, and it stops. That’s real data; nothing fake about that.

3. Number three; you collect a lot of extra information in just a few scans. The work order, the client, the employee, department, task, phase, status, kind of work, percent complete, not to mention actual start and stop times. This is a river of data coming off the shop floor.

That was just three. There are others you’ll see in these videos.
So, if you want to track actuals on the shop floor verses estimates, barcode scanners are the way to go.

Hey, I’m Ray White.
Good luck on your manufacturing projects!

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