All Activity

This stream auto-updates   

  1. Past hour
  2. Hi NeoJS, This can be possible using formula fields. However, the generated <img> element for the custom checkbox renders as text in tabular reports, due to an HTML encoding issue. The workaround is to use some script inside an HTML block to fix the encoding of the formula field result. The entire solution for this forum post is as follows: Create a Yes/No field in the table if there's none yet. In this example, I created a Yes/No field called Status. Create a formula field that will generate the image tag based on the checkbox value. In this example, I created a formula field called Checkbox_Image. Put this formula inside the formula field: CASE WHEN [@field:Status] = 1 THEN '<img src="FULL_URL_OF_CHECK_MARK" />' ELSE '<img src="FULL_URL_OF_X_MARK" />' END You cannot do something like <img src="[@field:My_Image_Field]"> inside the formula. That is, you cannot insert or use other fields as the image source URL. Then, on the tabular report, create an HTML block in the results page. Don't add the default Checkbox_Image field. Then, with the Source button enabled, paste this custom script there: <script> var imageLink = "[@field:Checkbox_Image]"; imageLink = imageLink.replace(new RegExp("&lt;", 'gi'), "<"); imageLink = imageLink.replace(new RegExp("&gt;", 'gi'), ">"); imageLink = imageLink.replace(new RegExp("&quot;", 'gi'), '"'); console.log(imageLink); document.write(imageLink); </script> Hope this helps.
  3. Today
  4. Hello - I have a field name with Data type Yes/No and in my tabular report, instead of displaying the value I want to show a Check mark imgae if the value is 'Yes' and an X mark if the value is NO. I was thinking of using a formula field. is this possible? Or is there any work around? Thank you.
  5. Yesterday
  6. Thank you. I changed the footer code to yours, but it doesn't seem to be working. I changed the cbVirtualParam to cbVirtualParam30, cbVirtualParam31, cbVirtualParam32, cbVirtualParam33. The button doesn't disappear when any of the radio button options are selected. Any ideas? My virtual field is 3. Thanks again for helping, Mark
  7. i want to integtrate caspio api using node js ,please guide me hot to do this...
  8. Hi VLE33, Just wondering why you would use a Submission Form for search? Are you trying to implement something like this? > http://howto.caspio.com/tech-tips-and-articles/tech-parameters/add-a-search-interface-to-results-sets-page/. If you are, you can use two virtual fields from your Submit Form as start and end value that you can pass as parameter for your Report DataPage. You can enable New criteria to add Criteria 1 and Criteria 2 for your Search Field Filter. Make sure you assign the matching parameter names for your Submit and Report DataPage.
  9. See if this helps.. <script> function HideButton(){ if (document.getElementById("cbParamVirtual10").checked) { document.getElementById("Submit").style.display = 'initial'; } else if (document.getElementById("cbParamVirtual11").checked) { document.getElementById("Submit").style.display = 'none'; } else if (document.getElementById("cbParamVirtual12").checked) { document.getElementById("Submit").style.display = 'none'; } else if (document.getElementById("cbParamVirtual13").checked) { document.getElementById("Submit").style.display = 'initial'; } else { document.getElementById("Submit").style.display = "visible"; } } document.getElementById('caspioform').onmousemove = HideButton; </script> ** cbParamVirtual10 to cbParamVirtual13 represents the id's of each radio button for Virtual1. Run inspect to see the exact ID assigned to your radio buttons.
  10. Last week
  11. New to Caspio. My questions: Can your tell me how or if their is an video or article on how I can set up some Javascript code to execute when a User clicks or double clicks on a line on a report. I need to count the line click and send the user to the hotels website that is on the line that is clicked. How will my JavaScript code in the footer be notified when there is a click on a line on the report? I appreciate any help on this.
  12. <input type="button" onclick="printDiv('caspioform')" value="Print caspioform" /> <script> function printDiv(divName) { var printContents = document.getElementById(divName).innerHTML; var originalContents = document.body.innerHTML; document.body.innerHTML = printContents; window.print(); document.body.innerHTML = originalContents; } </script> I'm trying to print out a tabular results screen using the above code. Using 'caspioform' as the variable, I seem to be pulling the URL. Anyone have any ideas on how to print out just the table of the results screen?
  13. I'm beyond embarrassed at my question now that I see how easy the answer is. I was SOOOO trying to make it more difficult than it actually was. Thank you so much for your help !!! -Jeff
  14. You may sort fields on a date field in the descending order and return only 5 records for report. You can find this setting on the Advanced tab of the results page options screen of wizard. Hope that helps
  15. How would I amend the code to do the following on a virtual field radio box, submission page. My virtual field is named Virtual3. If choice 1 is selected, hide submission button. If 2 is selected, show submission button. If 3 is selected, show submission button. If 4 is selected, hide button. Here is what I have so far...but it's not working <script> document.getElementById("InsertRecordcbParamVirtual3_0").checked = true; document.getElementById("InsertRecordcbParamVirtual3_3").checked = true; { document.getElementById("Submit").style.display = "none"; } else { document.getElementById("Submit").style.display = "visible"; } </script> Thanks! Mark
  16. This is my solution to fixed date squares for the Calendar. I find the calendar looks odd when it adjusts it's size to fit data, as many squares are different dimensions. The code is at the bottom of this post. Note: The calendar will not appear square in the preview section, you will need to save the style and apply it to a datapage. To make size edits to the code: EXPLANATION: 1. For the *-width styles, using a percentage value (1/7 = 14.28...%) will always result in fixed-proportion yet responsive widths. 2. For the *-height columns, Having a value of 180px, as obtained from the browser inspector, gives the best compromise, achieving an almost perfect square cell appearance. If making edits, you will most likely want to make edits in the every section where you see the code: min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; Copy and Paste Code under Calendar Layout Source: .cbResultSetCalendar { /*Results Page Calendar Attributes*/ border-collapse: collapse; border-spacing: 0px; width: 100%; margin: 6px; border: 1px solid #e8e8e8; -webkit-box-shadow: 0px 0px 0px 6px #f9f9f9; -moz-box-shadow: 0px 0px 0px 6px #f9f9f9; box-shadow: 0px 0px 0px 6px #f9f9f9; margin: 6px; } .cbResultSetCalendarCellspacing { border-spacing:0px; } .cbResultSetCalendarCaptionTable { /*Results Page Calendar Caption Table Attributes*/ width: 100%; margin: 6px; } .cbResultSetCalendarCaptionTableCellspacing { border-spacing:0px; } .cbResultSetCalendarCaptionCell { /*Results Page Calendar Caption Cell Attributes*/ text-align: center; vertical-align: middle; padding: 7px 10px 7px 10px; white-space: nowrap; } .cbResultSetCalendarCaption { /*Results Page Calendar Caption Attributes*/ color: #222222; font-size: 14px; font-family: Arial, sans-serif; font-style: normal; font-weight: bold; } .cbResultSetCalendarHeader { /*Results Page Calendar Header Attributes*/ background-color: #313131; } .cbResultSetCalendarHeader_hover { /*Results Page Calendar Header Hover Attributes*/ background-color: #313131; } .cbResultSetCalendarHeaderCell { /*Results Page Calendar Header Cell Attributes*/ text-align: center; vertical-align: top; padding: 10px 10px 10px 10px; white-space: normal; background: #fafafa; color: #222222; border-color: #e8e8e8; border-style: solid; border-width: 1px 0px 1px 0px; } .cbResultSetCalendarTableRow { /*Results Page Calendar Odd Rows Attributes*/ } .cbResultSetCalendarOddCell { /*Results Page Calendar Odd Cell Attributes*/ text-align: left; vertical-align: top; min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; white-space: normal; background: #ffffff; border-color: #e8e8e8; border-style: solid; border-width: 1px; padding: 0px; } .cbResultSetCalendarEvenCell { /*Results Page Calendar Even Cell Attributes*/ text-align: left; vertical-align: top; min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; white-space: normal; background: #ffffff; border-color: #e8e8e8; border-style: solid; border-width: 1px; padding: 0px; } .cbResultSetCalendarOddCell_hover { /*Results Page Calendar Odd Cell Hover Attributes*/ text-align: left; vertical-align: top; min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; white-space: normal; background: #ffffff; border-color: #e8e8e8; border-style: solid; border-width: 1px; padding: 0px; } .cbResultSetCalendarEvenCell_hover { /*Results Page Calendar Even Cell Hover Attributes*/ text-align: left; vertical-align: top; min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; white-space: normal; background: #ffffff; border-color: #e8e8e8; border-style: solid; border-width: 1px; padding: 0px; } .cbResultSetCalendarTableNowCell { /*Results Page Calendar Today Cell Attributes*/ text-align: left; vertical-align: top; min-width: 14.28%; width: 14.28%; max-width: 14.28%; min-height: 180px; height: 180px; max-height: 180px; white-space: normal; background: #F8F8F8; border-color: #e8e8e8; border-style: solid; border-width: 1px; padding: 3px; } .cbResultSetCalendarField { /*Results Page Calendar Data Attributes*/ text-align: right; padding: 0px; color: #000000; font-family: Arial; font-size: 12px; } .cbResultSetCalendarFieldInactiveDate { /*Results Page Calendar Inactive Data Attributes*/ text-align: right; padding: 0px; color: #AAAAAA; font-family: Arial; font-size: 12px; } .cbResultSetPanelBaseContainer{} .cbResultSetPanelDataContainer { padding: 10px 11px 10px; } .cbResultSetPanelCalendarRAContainer { /*Results Page Record Action Container Attributes*/ text-align: left; vertical-align: middle; white-space: nowrap; background-color: #fafafa; padding: 2px 3px; opacity: 0.8; filter:alpha(opacity=80); -moz-opacity: 0.8; -khtml-opacity: 0.8; overflow: hidden; } .cbResultSetPanelCalendarRAContainer_hover { /*Results Page Record Action Container Attributes*/ text-align: left; vertical-align: middle; white-space: nowrap; background-color: #fafafa; padding: 2px 3px; opacity: 1; filter:alpha(opacity=100); -moz-opacity: 1; -khtml-opacity: 1; overflow: hidden; }
  17. Hi Golfedad, I would suggest to use JS that redirects the user based on check performed on one of Authentication field. Below you may find sample code which I have used previously: <button onclick="myFunction()">Add Item </button> <script type="text/javascript"> function myFunction() { var cb_text = '[@authfield: Profile_Parm1]'; if (cb_text == 'Admin') { window.location = "URL_1"; } else { window.location = "URL_2"; } } </script> You may place above code in Header/Footer/HTML block of Datapage. Please make sure that you disable HTML editor.
  18. Hi blarney, This is the common problem for CMS users. If you use embed code, the datapage become a part of a webpage, hence inherits all style attributes, defined for the webpage. Is your CMS allows editing CSS code of your theme? If yes, you need to edit CSS of your CMS and delete or edit some attributes. If you can't edit CSS of the theme, overwrite elements in the header of the datapage. For example, if your CMS enforces borders, add the following code in the header of datapage: <style> #caspioform tr { border: none !important; } #caspioform td { border: none !important; } </style> Using iframe deployment eliminates style issues, however you may face problems with passing parameters. Hope that helps
  19. As far as I now, facebook ID services is not available in caspio since approx. 2014. I think that PS team can do that, this is the easiest way
  20. It appears this is happening when I embed more than one app on the same webpage. I'm attepting to have up to 6 Caspio apps running as a performance "dashboard", but they want to interfere with each other. How can I avoid this?
  21. I have an app that is built on a user-defined criteria but pre-filled to use the header/footer option. I actually have it deployed in two completely different websites - both WordPress. One works perfectly, the other continually loops. Is anyone aware of a WP setting that I might be missing that is causing it to loop in one and not the other? Or is there a fix in the footer code that I can add to treat it as being submitted?
  22. I would like to present a report that returns the 5 most recent sales entries for any user. Each sales entry is assigned an autonumber field "booking_number". For an authenticated user, I'd like the report to return the 5 most recent "booking_number" records and some of the associated fields to the report. Not catching on to JS very well, so any help is appreciated.
  23. Hi there, I think the best and easiest solution is to use drill-down reports in the Pivot Tables: http://howto.caspio.com/datapages/reports/pivot-table/ A.
  24. Hello! There are few ways to receive parameters : 1) On load 2) Filter by pre-defined criteria 3) Directly to Iframe Please take a look at this posts: http://howto.caspio.com/parameters/receiving-parameters/
  25. Hi! Maybe you can try to add cbResetParam=1 to the end of the URL of the DataPage in Iframe, like : <iframe name="Dating Messages" title="Dating Messages" src="https://c0ebl890.caspio.com/dp.asp?AppKey=52e04000b0d85d4a090241fa8928 &cbResetParam=1 ">Sorry, but your browser does not support frames.</iframe>
  26. Earlier
  27. Try this: <script> document.getElementById("caspioform").onsubmit= function (){ var str= document.getElementById("EditRecordImage_File_1").value; var pieces = str.split("\\"); var filename = pieces[pieces.length-1]; document.getElementById("EditRecordtextfield_1").value = '[@cbBridgeServer]/dpImages.aspx?appkey=APPKEY OF YOUR DETAILS PAGE HERE&file='+/filename; } </script> Change APPKEY OF YOUR DETAILS PAGE HERE with the appkey of the page you are placing this code in the Footer for. But the issue in here is that if you have the same file with the same name already, the name will get changed after submission and it is not going to be the same in URL anymore.
  28. The style sheet (css) from my webpage removes all styling from my reports and forms. I can't work with iframes, there's just too much of a struggle to refresh data with multiple iframes deployed on one page (for me at least). My question is can I get my embedded deployed code to call the css style sheet from Caspio, instead of that of the webpage??? I've tried copying all the css into the webpage's style sheet, but for some reason my tables on this website appends a number at the end of of the css selector... for example: .cbFormLabel is now .cbFormLabel_23b221101fd7e9 I have no idea if my website software (Artisteer) is appending that, or if the host is.... I know just about enough about coding, to realize I have no idea what I'm doing, any help would be very much appreciated.
  29. deployment

    I have a website where I continuously load articles into the browser as the user scrolls down the page. If the user places a Caspio embed in the first article, this will get loaded in on page load, and works great. But any articles that are dynamically created using JavaScript that try to embed Caspio within it don't populate. I am guessing this is because the script for Caspio has already run, and would need to be run again to populate the new instance. I followed the instructions to embed into articles. Is there anything in the API that can be called to refresh all Caspio instances on the page, or is this not possible?
  1. Load more activity