I need a spreadsheet like data grid web application that i can use for custom needs when working with my data. I need it to work fast and fluid and be installed on my web server with php 5+. Also i am not working on that data alone and therefore i need to to be accessible by several people at the same time from different locations using a secured access.
Currently for that purpose we are using google docs spreadsheets but it lacks some of the features that we need to make it a more enjoyable experience and save time on processing data.
Here i have written the most sought after features - some of them are available in google docs, some are not. there are a few more that we can discuss in a later conversation.
1. App - sheet like web application (google docs spreadsheet, [url removed, login to view], soho) data grid using database (mysql ?) and script (php ?) that can be hosted on a web server and accessed using user id and password.
2. multiple users and permissions - ability to create new users that can view/edit data. also for each user select which columns are visible and which are editable. By default new user can only view data. when permission changed to edit by default all columns are editable. if new column is added to the sheet all users by default have permission to edit it.
3. Automatic id (not row number) - when adding a new row id number is assigned to it and when sorting data or moving from one sheet to another it stays the same FOREVER to make it possible to track it.
4. Automatic dates - for creation and for last status change
5. Inline edit & autosave - possibility to edit rows inline, without clicking to EDIT button first and saving the changes automatically (Ajax ?).
6. Change log and revert - possibility to view which user has changed what data and revert if necessary.
7. Drop-down selections - f.e. column status with possible values (new, in progress, completed etc) - to choose the status of that current record. If a column is set to have this kind of data admin (me) must be able to create as many as needed possible selections. In google docs this function hides under Data validation.
8. Multi Drop-down filter (like google docs) for each column choosing from all possible inputs
f.e. if in the column are 20 filled rows with 5 different values then using the filter user can choose to display rows with selected content.
9. Multi column filtering - apply filters on several columns for better filtering option.
10. If several users are working on the table they must be able to filter data for they needs and it does not change the display of data for other users (f.e. in google docs if one user filters the column all other users that work on the same file get their data filtered as well.
11. Several "sheets" - like in a spreadsheet - f.e. sheets New, Completed, Delivered and ability to add or delete them.
12. Move row to another sheet - f.e. set the rule that if a row status is set to Completed it is automaticlly moved to sheet Completed. If it is later on changed to Delivered it is moved to sheet Delivered and so on.
13. Built in search - that can search in all the records and all the fields - just like google docs
14. When several users work on the same sheet cells they are currently editing (or have selected) are visible to other users in a way that signals that some other person is editing the cell (and if possible shows which user is that) - to protect from editing same cell at the same time.
15. Users online - Show (for admin) which users are currently online
16. Further development - Ability to further develop the app if/when necessary
17. I am only interested in a quality solution that will actually save our time while working with it!
Hope to hear from some experienced developers that can help me with this project.
9 freelance ont fait une offre moyenne de 706 $ pour ce travail
Hi, we can build the requested solution. we are 106 projects old and have expertise in creating PHP/Mysql web applications and solutions. Request you to refer your private message board for further details.