Hello, i`m a designer and producer of small furniture and i am trying to create a tool, in Numbers, to easily make offers.
I have some sheets that i would like to use as databases :
* Materials:
Name; Type; Length ; Width; Thickness ; Price / Square meter; Price / Sheet
* Services:
Service; Price/Hour
So basically i want to create a sheet in which i would like to add(type) in a list, materials and services, (preferably having the type suggest function from my materials and services databases).
After adding all the informations i would like to have a nice list with all the needs, and a total value calculated from items in my databases.
I saw some videos that you already made but they don’t actually solve my need. Having a pop-up Menu with items from my databases is not so efficient because the list of materials is long and i lose time scrolling to reach the needed material.
I want to add that i am willing to share the tool in the end, being very useful !
—–
Crisan Catalin
I think the video I have that is closest to what you want is this one:
https://macmost.com/creating-a-billing-and-invoicing-system-in-numbers.html
If using pop-up menus to much, then just do without it. Instead type or copy-and-paste the value you want into the box.
But other than that it sounds like you want something very specific and I'm not going to be able to understand what you need exactly with just the short description. You're going to have to work at it. Instead of asking "how do I build this entire thing" which is hard to answer, perhaps try asking (here in the comments) about individual aspects of what you are trying to do. Pieces, not the entire project.
Hello Gary, Thanks you for the answer,
Is there a way to type into a cell and while typing to have suggestions from another sheet or list of items ?
Crisan: Not easily, no. You have to populate the pop-up type cell manually.
I've been using the search function, as you presented in another video, and i managed to sort my database of materials gradually by typing the type of the material and thickness. Now, with the result displayed, how can i move/copy the row to my offer list of needs ?
I am planing to use a sheet with materials as a database and to populate other sheet "the offer list" with results gradually added from my searches.
Do you think is a good ideea or manageable ?
Thanks Gary for your patience !
Catalin: Really hard for me to say if this is the best way to do it. I'd have to see it all in action and understand more about what you are trying to do. Even then, I'm not the one doing it so I may not be the best to judge.
Not sure what you mean by "how can I move/copy the row" -- how is what you want to do different than what you get when you just copy and paste?