Trying to adapt my ongoing equipment rental project for which I use Google Spreadsheets. The biggest challenge I face now is the inability (or is it so?) for CODA to have frozen rows/columns. Maybe there is a clever way to overcome that?
The idea is the following:
- I have a complex table where I record all the key requirements (date, place, contact info etc) by the clients - one column per event. I also track the status client order in the same column (ex pending, confirmed, contract signed). All this info is in the first ten or so rows and is frozen from scrolling. Then I have a section on equipment - and I place a number which reflects how many pieces of equipment are reserved. An example of such excel is here (Dropbox link)..
- I also use some complimentary tables to enhance the quality of the table: list of locations for the events with Google Maps hyperlinks and travel time needed; Crew list - used for OPS Planning Sheet and Loading Sheet. All that is visible in the example.
This work requires a lot manual copy paste and I am very keen to built an automated solution. The idea would be that I enter information only once and for the rest of time it is prefilled automatically or uses lists to be selectable. Coda.io is potentially a right tool to solve that.
Any help to make a breakthrough here would be greatly appreciated. The final results would allow me to build a nice ERM (enterprise resource management) solution that suits event equipment rental businesses.