# Updating next visit date in master table

**URL:** <https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407>\
**Category:** Ask for Help\
**Created:** [November 14, 2020, 6:31pm UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407 "2020-11-14T18:31:35Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [November 14, 2020, 6:31pm UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/1 "2020-11-14T18:31:35Z")

</div>

I am creating an application for the tele-caller team to call customer and update the feed backs.

1. I have master table with Customer name, Phone, address, next follow-up date etc.
2. I have a table to record Call history where there columns are Customer Name, date & time of call, who made the call, feed back and the next follow-up date.  
I have established relation between this table.  
I want to update next follow-up date in master table from the call log table as soon as an entry submitted through follow-up form.  
I tried vlookup in google, but not able to find the last row for a looked up value.

[https://go.glideapps.com/app/0y5ZG2IFHzYYlS1zlqL0](https://go.glideapps.com/app/0y5ZG2IFHzYYlS1zlqL0)

Please help to resolve this problem showing a method in google sheet / glide

---

<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:** [November 14, 2020, 6:50pm UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/2 "2020-11-14T18:50:11Z")

</div>

No need for any sheet formulas. Use the relation you already created, then a rollup to get the max date from the relation.

---

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [November 15, 2020, 1:22am UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/3 "2020-11-15T01:22:53Z")

</div>

Thanks a lot, it’s perfect solution.

---

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [November 15, 2020, 1:38am UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/4 "2020-11-15T01:38:52Z")

</div>

I want to identify whether the lead is HOT,WARM,COLD or LOST so that I can filter out the LOST data from display. This status is updated in CALL HISTORY table on each call.  
How to ROLLUP this column value from the last record ?

Thanks in advance for your valuable inputs.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [November 15, 2020, 3:03am UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/5 "2020-11-15T03:03:56Z")

</div>

You can use a single value column and return the last value from the relation.

---

<div class="post-metadata">

**Author:** ![edbs\_India](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/edbs_india/32/4055_2.png) [@edbs\_India](https://community.glideapps.com/u/edbs_India)\
**Post date:** [November 15, 2020, 4:29pm UTC](https://community.glideapps.com/t/updating-next-visit-date-in-master-table/18407/6 "2020-11-15T16:29:11Z")

</div>

Thanks a lot for the guidance.