two tables Insert Date From another table

[billid]

Hello,

I am new to Caspio, I encounter a problem here.

I have two Tables

Table#1: Investment(Investment_ID, Client_ID, Latest Transaction date, BookValue, MarketValue)

e.g.

Invest001|Nov 1, 2018|500|1000

Invest001|July 1, 2018|800|2000

       

Table#2: Investment Transaction(Investment_ID, BookValue, MarketValue, Transaction_Date)

e.g in Table #1 I have following records,

Invest001|100|100|Oct 1, 2018

Invest002|800|2000|July 1, 2018

Invest001|100|200|Oct 10, 2018

Invest001|100|300|Oct 15, 2018

Invest001|200|500| Sep 1, 2018

Invest001|500|1000|Nov 1, 2018

Here I would like to make the following action execute whenever I update the table.

Latest Transaction Date =  Table#2:Latest Investment Transaction：Transaction_Date

BookValue = Table#2:Latest Investment Transaction: BookValue

MarketValue = Table#2:Latest Investment Transaction: MarketValue

 

What can I do to make this happen?

Any help will be appreciated,

Thank you very much in advance,

 

[Vitalikssssss]

Hi @billid,

I would suggest taking a look at Triggered Action feature of Caspio.

Triggered Actions allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface.

They will be executed on specified events to perform actions on data in your tables. Changes in one table can affect data in other tables.

Regards,

vitalikssssss