Jump to content

All Activity

This stream auto-updates     

  1. Today
  2. Hi All I am trying to sum AND add a percentage to two separate columns in a tabular report. I can do this fine with two separate aggregates: SUM(cost_2017)*1.1 = aggregate 1 SUM(cost_2018)*1.1 = aggregate 2 But the results fall in two different rows for each aggregate. How do I just do one aggregate, but for column 2017 costs, use the cost_2017 number and for column 2018 costs, use the cost_2018 numbers for the column 2018 costs and they fall in the same row. I can select both the cost 2017 and cost 2018 numbers in the selected fields, but can only do a formula for EITHER of them... Doing a SUM this way works (I can pull over 2017 and 2018 costs, and get two different sums in one row), but this doesn't seem possible for formulae? Thanks in advance melissa Example attached
  3. Last week
  4. Id like to get a Time Picker (like the calendar date field picker but with just time). Caspio refers me to: Separate-input-fields-for-datetime-parts Possible solution but kind of honorous. I stumbled upon the newer HTML5 option: <input id="time" type="time">. Placed in an HTML box this provides exactly what I/we need - <input id="time" type="time"> How can I pass whatever is in this input field to a field in my datapage and/or database? Seems way easier than the proposed caspio method.
  5. Add a font to a DataPage

    @thirdcharm Thanks for this info. - I added the CSS in Styles / Data / .cbResultSetData class - is that generally correct? - This works on desktop, but not mobile. However, I haven't set up responsive functions yet (I would have thought that Caspo would be fully responsive OOTB). In your experience, do fonts in Caspio need to be set up : - for each Styles Element Type AND class? - separately for mobile and tablet form factors? Thanks!
  6. I tried the JS script above - it mostly works, with 2 exceptions: The field label (in General Options) works for non-custom fields, but doesn't work with custom HTML blocks (my column heading is blank for this field). text-align: center; doesn't seem to do anything - my data is left-aligned and I can't seem to change that. I realize this is an old thread...just thought I'd ask - has anyone encountered these 2 problems and know how to remedy?
  7. I have a custom HTML Block to define a report column and format. Most of the CSS format options seem to work (font-size, etc). text-align does not work. I've tried: text-align: center; text-align: middle; Does anyone know how to center align a custom HTML Block?
  8. I have a custom HTML Block to define a report column and format. However, the Label (in the General Options screen) only seems to work for non-custom fields. If I enter a value for a custom HTML Block, the column heading in the report is blank. Does anyone know how to get around this?
  9. Data Page - Change Font Size / Weight by Column

    FYI for anyone else who has this question - the following JS works, with exceptions: JS SCRIPT <div id="mydiv[@field: AAABBB]"></div> <SCRIPT LANGUAGE="JavaScript"> { document.getElementById("mydiv[@field:AAA_BBB]").innerHTML ="<span style='color: #9476c9; font-size: 24px; font-family: Arial, sans-serif; font-style: normal; font-weight: bold; text-align: center;'> [@field:AAA_CCC] </span>"; } </SCRIPT> LEGEND AAA_ Table Name (if underlying data source is a view) BBB PK Column Name CCC Column Name of the field to be displayed. EXCEPTIONS CSS text-align: center; does not work The label override (in General Options, not in the Source area) does not work.
  10. I know this is an older thread, but posting this in case it helps anyone else. I was having trouble with the above code failing when data grouping was turned on for any of the result set rows. Getting direct to the "cbResultSetDataRow" class allowed me to circumvent the grouped rows. Not the best solution if you have aggregation on, but works without it. Note: Only tested on tabular report page <SCRIPT LANGUAGE="JavaScript"> /* tableNum is the number of the table to be formatted, the first table is 0. If several DataPages are deployed on the webpage, several tables are displayed*/ var tableNum = 0; /* columnNum is the number of the column to be formatted, the first column is 0. */ var columnNum = 0; /* variables for colors. You can find names for colors in the article http://www.w3schools.com/html/html_colornames.asp */ var v_textColor = "red"; var v_backgroundColor = "yellow"; var tbl = document.getElementsByTagName("table")[tableNum]; var rows = tbl.getElementsByClassName("cbResultSetDataRow"); for (var row=0; row<rows.length;row++) { var cells = rows[row].getElementsByTagName('td'); if (cells[columnNum].innerHTML > 7) { cells[columnNum].style.color = v_textColor; cells[columnNum].style.backgroundColor = v_backgroundColor; } } </SCRIPT>
  11. Data Page - Change Font Size / Weight by Column

    @alineer Thanks for the reply...could you possibly expand on your answer? 1. On the data page elements config screen (either standard or advanced), I don't see any option to add css. - If I modify the style, then I would need a specific style for each data page. I don't think even that wouldn't work,because I plan to use data grouping. - Could you specify exactly where to add the css? Thanks!
  12. Datapages In Modal Css Framework

    This behavior is displayed in many places my web-application. Create an account here Choose a free plan so you can log in to see this and other things Caspio
  13. Man, I just cant get this to work. Question, does the script go in HTML block or header?
  14. Hi there, I have a formula that is working fine in most instances, but it falls down every once in a while. I think I've got it figured out and then it falls down again! This is my code IsNull((SELECT sum(IsNull([@field:Optimiser_RatingX],0)+IsNull([@field:QA_Tester_RatingX],0)) FROM Card_comments_and_updates WHERE User_ID=[@field:Analyst_IDX])/((SELECT COUNT(IsNull([@field:Optimiser_RatingX],0)) FROM Card_comments_and_updates WHERE IsNull([@field:Optimiser_RatingX],0) >0 AND User_ID=[@field:Analyst_IDX])+(SELECT COUNT(IsNull([@field:QA_Tester_RatingX],0)) FROM Card_comments_and_updates WHERE IsNull([@field:QA_Tester_RatingX],0) >0 AND User_ID=[@field:Analyst_IDX])),0) I want it to display zero if it can't calculate anything! Basically my datapage displays all my users along with an average of all the star ratings they have. The calculated field looks in a different table for every instance where the user ID in this table is listed in the Analyst column. Then it checks the 2 different fields where ratings are given (QA Tester Rating and Optimiser rating) for values more than 0. Adds them together and then divides them by the count, thereby giving the average. For the most part it works fine ... EXCEPT where there are fields where either the QA Tester Rating or Optimiser Rating are zero. Help! Many thanks Nikki
  15. Line Chart with multiple fields across month rollup

    … Very functional instructions thanks..!! _________________________________________________ Linens By Manchester
  16. Hi Rmohanr, If you want to hide the text from the header bar, you can try this: From MayMusic's answer, replace with: #target table:nth-of-type(2) th:nth-of-type(3) { /* Hide the text. */ text-indent: 100%; white-space: nowrap; overflow: hidden; } or for sticky headers: #target table:nth-of-type(2) th:nth-of-type(5) { /* Hide the text. */ text-indent: 100%; white-space: nowrap; overflow: hidden; } I hope this will help you.
  17. May, your code is working and is taking away my style in the header bar. See the attached image. The last "RED SQUARE" Indicates the column to be hidden. It is working fine but taking away the blue background. How do I get the missing blue background to match the blue bar length to the gray bar below? The contents of the field (Shown as BLUE BOXES) is also not hiding
  18. Convert Scientific Notation to Numeric

    I am trying to modify the formula on the table.
  19. Convert Scientific Notation to Numeric

    Just edited the original post.
  20. Convert Scientific Notation to Numeric

    What error are you getting? Are you creating a table or adding data to a table?
  21. Hi, I am new here. I would like to save the table, but it gives me an error: "Unable to save due to incompatible values in one or more formula fields." even if the formula validates OK. I have this formula: And I am trying to replace char to float to convert scientific notation to numeric.
  22. Have you tried to fire the script when the cascading element changes? $("[name='cbParamVirtual7']").change(function(){ f_copy_print_address('cbParamVirtual7', 'cke_EditRecordShipToAddress'); });
  23. Turn Off Submission Form after Specific Date

    To hide the entire form you can use the code below: <script> var date= new Date('03/04/2018'); var today = new Date('[@cbTimestamp*]'); if (date < today){ document.getElementById("caspioform").style.display = 'none'; } </script>
  24. Submit button not working

    Hi Nikki, I could think that there may be a syntax issue in the header. Anyways, if possible please share the datapage URL so we can look at it to try to determine the cause. Regards
  25. Hi Robin, That is something we would like to have, but currently caspio emails are sent upon a user action as you mentioned. However, I am working right now in a way to send notifications when certain conditions are met, without any action from the user but I am using third party services to send the email through its API and then calculated fields in a tabular report to compare todays date with all the other conditions. In your case, since you have an expiration date set, you could use a formula field and DateAdd() function https://howto.caspio.com/function-reference/ to have dates with 30 or 90 dates before the expiration date. Then you could have a tabular report and put your API code to the email delivery service you chose, (I am using MailGun), do not forget to deploy this datapage. After this, create a cronJob to open this datapage accordingly so the script runs by itself. Hopefully in the future, Caspio would create a way to do it with no hassle but at this time, this is the only way I have found. Maybe this could give you some light. Good luck!
  26. Hi there, I have records called Cards, which span 5 different stages. If the first part of the Card is completed, the user is in stage 1. If the first and second part is completed, they are in stage 2 etc etc. I'd like to automate this (currently they can choose their own stage via a dropdown), and have written the following script, but it's not working. <script> var count_Brief= ("[@field:Brief]").length; var count_AnalystNotes = ("[@field:Analyst_Notes]").length; var count_RecTest = ("[@field:Recommended_test]").length; var count_Result= ("[@field:Actual_result]").length; if (count_Brief > 1) { document.getElementById("EditRecordStage").innerHTML = "2. Brief"; } else if (count_Brief > 1 && count_AnalystNotes > 1) { document.getElementById("EditRecordStage").value = "3. Analysis"; } else if (count_Brief > 1 && count_AnalystNotes > 1 && count_RecTest > 1) { document.getElementById("EditRecordStage").value = "4. Test"; } else if (count_Brief > 1 && count_AnalystNotes > 1 && count_RecTest > 1 && count_Result > 1) { document.getElementById("EditRecordStage").value = "5. Result"; } else { document.getElementById("EditRecordStage").value = "1. Question"; } </script> Does anyone have any insight here? Many thanks Nikki
  27. Triggered Action Issue

    Awesome, MayMusic ! Thanks for the neater solution, and for explaining the logic behind.
  1. Load more activity