No one has answers

Ask the community
, ,
1

The site is on wix and in the infancy stage. dfsassist.com

So for about a week, I have been seeking an answer to my problem. I have put my project on upworks, i have contacted numerous web designers, and still have yet to find a solution. What sounds easy in my head, has been very hard for others to realize. I know zippo about web design and all those terms that come along with it; interface, front, back, wordpress, javascript, full, HTML, Https, etc, etc.

I know the page is possible I am just not sure of what expert to ask, what the technical term(s) are for the endeavor. Is it a code writer i need?

I need a page that allows user input. I need that user input to go directly to certain cell(s) in my excel or google sheets, and from another cell a number is returned to the page. There will be multiple user inputs and returns.

1st. I have to to get the input directly into a cell. It seems attaching it to the sheet is not the problem, attaching to a specific cell is a problem.

2nd. From another cell within a sheet i need a different number to return back to the web page.

3rd. The cells are based on formulas from five different sheets in the workbook, so the sheet needs to stay my drive.

4th. This is all happening in real time. Therefore uploading/downloading, importing/exporting is not realistic into wix database.

5th. This is a site is based on sports predictions, so the cells and their meaning will change with different sports.

6th. It cannot look like a spreadsheet on the webpage.

Is Wix the wrong website for this, is this a coding issue or is this another designers issue?

2

It sounds to me you are trying to use a spreadsheet as a database. Who took this decision? Spreadsheets were not designed for this, otherwise we wouldn´t need databases. The development of an interface to do this, will cost you a bundle AND it will always be shaky: you can use a screwdriver as a hammer, but at some point, it will fail.
Your long term, best solution would be to put everything into a database and forget about spreadsheets. There is nothing that a spreadsheet can do that an application with a database cannot.
So a simple word of caution: in my decades of development experience , I did come across specs like yours, where the client, as you admit, has no great insight in the technical part of development, but does put implementation guidelines on the table that can break a project from the beginning.
Caveat.

3

Does a database act like google sheets and excel? The page does not exist without all the formulas tied to my current workbook. What specific term do i use to find a database designer…database designer :slight_smile:

4

No, a database just holds the raw, underlying data. Together with some (Wix) code, it will act like your spreadsheet (but possibly with a different interface, so not like a grid). The formulae will be lines of code.
You do not look for a database designer, you must look for an application developer, who, in his toolbox, will have a database which he can implement. There are some Wix Code developers available on fiverr.com, tiaan one of them, somebody who is on this forum regularly. Talk to them, tell them what you need, they should be able to help you.
PS I do not get kickbacks from them, am not affiliated with them in any way, just trying to point you into the right direction.

5

Giri doesn’t get kickbacks - but we like him. :smiling_face: