Jump to content
  • 0

Insert Date From another table




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)


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,


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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.



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...