Updating next visit date in master table

Ask for Help
1

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

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

2

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

2 Likes
3

Thanks a lot, it’s perfect solution.

1 Like
4

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.

5

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

1 Like
6

Thanks a lot for the guidance.

1 Like