compare with another form and delete the row if criteria Matched
Hi,
I have two form
FormA and
FormB , There are two common fields between two forms. Below is the screenshot of the two Forms,
FormA:
Note:
TV station : Look up field of
station Name of
Station Form
Network -01 ; look up field of
Network name of
Network Form
Network -02 ; look up field of
Network name of
Network Form
Network -03 ; look up field of
Network name of
Network Form
Network -04 ; look up field of
Network name of
Network Form
FormB:
Note:
TV station : Look up field of
station Name of
Station Form
Network : look up field of
Network name of
Network Form
what I am trying to do is that --
In the
FormA when I update any network name like
Network-01: ABC to something else like Bounce TV then A script will delete the row of corresponding TV station and Network in the
FormB.
For instance here it should delete the first row of the
FormB .
Since it is matched with the T
V station name
and
Network
Name of the
FormA.
So After deletion the row then the FormB looks like below
can anyone please help me.