Hello! I work at a restaurant. I am collecting data from each day about my coworkers and our customers.
is there a way to use 1 spreadsheet that can collect data then switch to a new day without creating another table or sheet?
i.e. 7 days of data collected and I can swap through each days worth of data represented by 1 table
i would think it might be a drop down type menu but I’m not finding g it.
thanks so much in advance
Mac Studio, macOS 14.1
Since this is on an iPad, let's make full use of it.
Set up a form with the basic information for each group of guests.
The four fields collect useful data like the current date and time, the type of meal (in a drop-down), the server (in a drop-down), and the number of guests (formatted as a stepper). Everything is set up for quick entry with no possibility of error. The date is important because it allows you to do an audit of the data collected (to reduce the likelihood of such questions like: Were there really three straight seatings with 4 people or is it a data entry mistake?)
Tap on the date field and click the "now" button to enter the date and time.
Select the meal from the popup list.
Select the server from the popup list.
Tap on + or - to adjust the number of guests.
When the four fields are filled, click the + at the top-right corner.
The next sheet collects data entered in the form.
Finally, a pivot table makes nice summaries.
If you don't want to collect data for more than a week, delete the old rows in the compilation when time comes.
Be aware that Pivot tables do not update by themselves. When you want an updated view you have to tap on the blue icon at the top-left corner and select Table Actions... / Refresh Pivot Table.
Hi Reidentski,
Do you want a table for 7 days, that will show only one chosen day at a time? A filter will work, but more information will help us to visualise what you want to do.
Please make a mock-up of the table and take a screen shot. Post the screen shot in a reply.
Regards,
Ian.
Hi Reidentski,
I am still confused about your overall aim.
Do you mean a table like this?
With a Filter to show only a specific date? We can do this!
Or perhaps a Pivot Table will work for you.
Regards,
Ian.
Hi Reidentski,
Yes, you are making sense! Thank you for the screen shots. Now I can see your aim (the result).
What is not clear is how you input the data.
It will help me and other users if you show the table(s) where you input the data. Are you are using an iPad with Forms to input data?
If so, it is best if other users who are more familiar with iOS take over from me.
Happy Numbering!
Ian.
i believe your idea is roughly what i was thinking Ian.
I want to have 1 table to represent a week of data.
Hopefully this helps. If i can even do what i'm thinking of.
Each sheet has 1-2 tables in them of similar looking data.
What i would like to have all those sheets, instead be 1 table with something like a drop down that i can keep adding to as a new day comes
Imagine 1 table like a notebook and each page of that notebook (table) is a date.
This way i can have multiple sets of data instead of having a long list of sheets.
Maybe this isn't doable, but i thought i would ask.
Thanks in advance for any help you can give!
Kinda? I do appreciate your effort to help me solve this Mr. Ian and I do apologize if I am explaining it poorly. So thanks for your patience
This is all the data I want to collect in one day
Each time a server has someone seated in their section and how many total they had seated in their section
Lastly a total of how many were seated among all servers.
I would like that represented by 1 day and if possible, one 1 table which I can do obviously
So additionally (if it's possible) I would like to be able to hit a button and move to the next day with that table emptied and ready to insert new data. and if needed, I can "flip" back to a previous date
"Brian had X people in his section on Monday"
"We had 37 people for lunch on Wednesday"
hopefully I'm making sense.
Thank you kindly sir!
Wow, this I believe is what I'm looking for! thank you so much. I'll be trying to recreate this and I will get back to you. Thank you so much for all this information!
Thank you as well Mr. Ian!
How to use 1spreadsheet represent each days data
