Search the Community
Showing results for tags 'sort'.
Found 5 results
-
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...
-
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,
-
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!
