Search the Community

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,

We need to create a manual sort in a pivot table on a data page. We want to have size (XS,S,M,L,XL,2XL) appear in order on the rows rather than alphabetical. How can you do this? Thanks...

Is it possible to change the sort order of a Y Axis of a chart (combination, bar etc) where one could use a Title field for display, but use the Date field for sort order? Thanks! Clint

I have created a page submission form with Estimated Value & Estimated Value 2 which displays like this on the details page: Estimated Value: $10,000.00 to $20,000.00. However to get both numbers to display in the table without being next to each other and making the table huge I have created an HTML block like this: [@Estimated Value] [@EstimatedValue2] The problem with that is then I can no longer sort the results table by estimated value. Is there any way to have the numbers display as $10K and $20K or something similar so the table doesn't end up so long? In addition I need to be able to search the table by Estimated Value so people still need to be able to search by $10,000.00. I currently have the search set to just search [@EstimatedValue] using the criteria options. Thanks for your help!