I am creating an application for the tele-caller team to call customer and update the feed backs.
- I have master table with Customer name, Phone, address, next follow-up date etc.
- 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.
Please help to resolve this problem showing a method in google sheet / glide