Private database search engine

Ask the community
,
1

Context:
We are a company specialized in tailoring and i used a Google Sheet to reference all of our stock.
I was recently tasked to make a bare-codes system, surprisingly successfully, so that a client just have to scan with his phone to complete our order-sheet.

I am looking for a way to make a “secret page” on my site, only for the staff, that would search refs in a google sheet from a bare-code, then permit the modification of the sheet values… any idea how to do this?

Thanks in advance.

2

Thanks for the advice, didn’t knew we could do that, but the main problem is the search engine and linking a google sheet to a Wix site.

Beautyfull website by the way! but the AAFF part in blue on a multicolored background is difficult to read. You should add a border on the letters… that’s my 10 cents, for what they are worth.

3

See the Google Sheets NPM example to learn how to access a Google Sheet from your site.

4

@yisrael-wix Thanks!