Hi @LeventK thank you for this. I had to restructure my data to be able to pull things from tables. And I have actually learned some limitation of the < < Start > > like the formula is only working horizontally. My question though is why does it erase data from the table where I pull in data from when I delete the key, which is my entry, in “Application” table. Here’s how the structure looks like.
The above is my application table where I choose “Client Id” and serves as the key as well.
The above is the table where I pull data from.
The data in the “Business” table gets erased when I delete an an entry in my “Application” table.
This workflow works like the below:
- Choose Client Id from the list in “Application” table
- Data is fetched from “Business” table
- Send email to appmaker
Any help will be appreciated. Thanks.