Google spreadsheet. How to set up for repair shop, communication salon?

Question

CRM

Good day! Please help me with the program. Repair shop and a small communication salon.

I have a primitive Google spreadsheet with a list of clients, as well as various kinds of inventory, spare parts and other goods.

1. It is necessary to make it so that when I open it (and often I go from the phone) it gets to the last filled line;

2. We need at least some primitive sorting, classification by type, type of goods, and I want it to be universal - to store absolutely everything that is in the workshop, at home, in general, everything that is subject to fixation, with separation n
And so that the desired values ​​​​are applied both to the whole price list and to a specific group specifically
(drop-down list, and all the chips possible on this topic)

3. You need to somehow fix the photo, if necessary, opposite the designation of any product (if as a hyperlink, how is it implemented and where will it be referred to? Then I suspect I will have to somehow use the cloud service. But the question is that the photos will somehow be 4. Protect

information Service worker has access to the database and fills it in as needed on request during the day How to protect the contents of the lines, information from deletion or changes later after filling (so that neither tomorrow nor the day after tomorrow can change)

5. Desirable - CRM functions with the ability to log in via phone.

Perhaps someone has a ready-made similar table. Thanks from me!

Answer 1

Just nothing for free. HelloClient and... It's just very easy to find.