Link to home
Start Free TrialLog in
Avatar of Ted Penner
Ted PennerFlag for United States of America

asked on

Time, pay, and note tracking for contractors.

My wife and I need to be able to better keep up with what we pay contractors and keep track of their time, pay, and notes via the web.  We are looking for a free solution.  Assistance is greatly appreciated.
ASKER CERTIFIED SOLUTION
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ted Penner

ASKER

You said that there were some excellent free ones.  Are there any free ones that work with Android and iPhone?
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
the problem is that my wife uses iPhone and I use Android. we both need to be able to enter information about the same contractors and keep it all in one place without a monthly fee
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ThinkSpaceSolutions -

You touched on something that might be good for an ongoing topic.    The spreadsheet would be a PERFECT solution just that way except for a couple of things.

A couple of things spreadsheets don't do.  They don't calculate differences in time well and they don't do do notes well.

When looking through a list, I like to have each item on one line, but I also take good notes that I like to make visible when printing.
Thank you
A couple of things spreadsheets don't do.  They don't calculate differences in time well and they don't do do notes well.

If you know how to manipulate them well, they can accomplish almost anything!  Have you decided to go this route?
I have gained access to a MySQL database using phpMyAdmin but have very little knowledge about how to use it.

My statement about how spreadsheets don't do notes well is perhaps the most needed.  

The need is to have allot of notes 'available', but not constantly visible.  I don't know how to do that in a spreadsheet and am not convinced that a spreadsheet has the capacity to do that efficiently.
a SQL database connected to a web form is a great way to capture the info you need; however, even with phpMyAdmin, you will have to some knowledge about the connections or have someone do the setup for you.

With Excel, there are a multitude of solutions for your notes.

For instance, one of the easiest is to populate a main worksheet with all of the information you want to track for each contractor (i.e. time and pay information).  Using a cell within that worksheet, you would link the text to a new sheet specifically for that contractor, where you could keep notes in any format you desired, without interfering with the purpose of the main worksheet.

Just for grins, I attached a sample of what I have mentioned.  You can click on the Contractor's Name (Contractor #1) to move to his Notes.
Q-28233856.xlsx