# Implement a restaurant management system

**URL:** <https://community.glideapps.com/t/implement-a-restaurant-management-system/40194>\
**Category:** Ask for Help\
**Created:** [March 29, 2022, 6:13am UTC](https://community.glideapps.com/t/implement-a-restaurant-management-system/40194 "2022-03-29T06:13:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\
**Post date:** [March 29, 2022, 6:13am UTC](https://community.glideapps.com/t/implement-a-restaurant-management-system/40194/1 "2022-03-29T06:13:12Z")

</div>

I want to build a restaurant management system, in that restaurant let’s say there is only **1 Manager** for now and **3 employees(i.e. A,B,C)**, are working under him. Now at the end of the day, the manager receives a total tip of let’s say **$25** from the restaurant owner, and it is to be distributed among the _3 employees_. Now the manager performs actions as follows:

1. He gives $5 to A,(Balance left= $25- $5= **$20** ).
2. He gives $10 to B,(Balance left= $20- $10= **$10** ).
3. He gives $6 to C,(Balance left= $10- $6= **$4** ).

and the manager is left with **$4** , now how to implement this logic, Can you suggest any videos or articles.

**i have implemented the same logic in glide, but the tip amount is detected from the employee account rather than the manager**.

https://player.vimeo.com/video/693413284?h=38de4bda1b&app_id=122963

---

<div class="post-metadata">

**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\
**Post date:** [March 29, 2022, 8:07am UTC](https://community.glideapps.com/t/implement-a-restaurant-management-system/40194/3 "2022-03-29T08:07:40Z")

</div>

here is the solution:

1. form a 1-many relations in the same sheet. (choose a common column, that differentiates the employees it could be company name, team name, group name etc.)
2. create a column where you can put the values to be used to subtract. (eg. $20-$10, here $10 can be used to create a separate column)
3. use the rollup and select the relation column which you want to summarize.

https://player.vimeo.com/video/693429121?h=6fef34cb84&app_id=122963

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 7, 2025, 12:05pm UTC](https://community.glideapps.com/t/implement-a-restaurant-management-system/40194/5 "2025-10-07T12:05:42Z")

</div>