Search the Community

HI I have a large table which when displayed in a submission/report datapage takes a few seconds to process when a column is clicked to sort. I'd like to display a 'spinner' so the User knows something is going on while waiting. I can activate the spinner by placing some jQuery in the Header of the 'Configure Table Fields' page of the submission/report wizard. Problem is that when a column is clicked to sort, the spinner is not called immediately and only starts around half way through the processing time. What I don't know is where to place my spinner jQuery code so it switches on as soon as the column is clicked to sort. I tried the Header in the search page, but it doesn't get picked up from there. Is there an event listener that could be used somewhere? Many thanks

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!