Jump to content

iren

Caspio Ninja
  • Posts

    78
  • Joined

  • Last visited

  • Days Won

    6

Everything posted by iren

  1. Hello ccarls3, You can try to use next formula: SELECT COUNT(Q) FROM Audit_Master_Database WHERE Format=target.[@field:Format] AND AuditType=target.[@field:AuditType] AND Q = target.[@field:Y] Does it work for you?
  2. Hello Cameron, Please change the 'appkey_number' value to the number of your DataPage AppKey. Does it work for you?
  3. Hi Cameron, You can paste the respective snippet inside the HTML Header and HTML Footer section. Header: <h1 id="loadingTitle" style="display: none">Loading...</h1> Footer: <script> var v_appkey = 'appkey_number', v_appkeyInputs = document.getElementsByName('AppKey'), v_appKeyInput = null; for(var v_i = 0; v_i < v_appkeyInputs.length; v_i++){ if(v_appkeyInputs[v_i].value == v_appkey){ v_appKeyInput = v_appkeyInputs[v_i]; break; } } if(v_appKeyInput){ var v_formNode = null, v_tempNode = v_appKeyInput.parentNode; do{ v_formNode = v_tempNode; v_tempNode = v_tempNode.parentNode; }while(v_formNode && v_formNode.nodeName.toLowerCase() != 'form'); if(v_formNode){ v_formNode.onsubmit = function(){ var v_title = document.getElementById('loadingTitle'); if(v_title){ v_title.style.display = ''; } }; } }</script> Hope it helps.
  4. iren

    Sort Radio Buttons

    Hello Chad, How do you sort by? Display or value?
  5. Hello Cameron, You can create the lookup table with the field with 'Autonumber' DataType. On the 'Configure Search Fields' select 'Dropdown' form element, 'Greater Than' comparison type, the 'lookup table' source, sort by Z->A for the fieldwith 'Autonumber' DataType. Than to add the next code in the Header: <div align="center"> <p>Processing...</p> <img src="images/progress_bar.gif" alt="Progress Bar" width="200" height="15" /> </div> and to add the next code in the HTML block: <script type="text/javascript"> function my_funct() { document.getElementById("Value1_1").options[20].selected = true; } if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('my_funct()',500); setTimeout('document.forms["caspioform"].submit()',1000); } </script> Hope it helps.
  6. Hello Liz, I am afraid the file with JavaScript is not attached. Could you please post the script to look at it?
  7. iren

    Hiding the header

    To hide the header, follow the following steps: 1) Edit Localization, customize the HTML text in the Custom Text by adding div tag: <div id="norecord"><h1>No records found.</h1></div> 2) Edit DataPage. Go to the 'Configure Results Page Fields'. Inser Header&Footer. 3) Paste the code in the 'Header' field: <span id="HideHeader"><h1>Text</h1></span> Enter your header text instead of Text. 4) Paste the code in the 'Footer' field: <script>function func_NoRec_Header() { if (document.getElementById("norecord")) document.getElementById("HideHeader").style.display = "none"; } window.onload=func_NoRec_Header; </script> Hope it helps.
  8. You can use the 'Filter data based on pre-defined criteria' option, to insert new criteria and enter conditions for range. Does it work for you?
  9. Hello Cameron, You can insert new criteria in your Report DataPage to filter the field by two boundaries. For a Date field you can have two Criteria, FROM and TO so you can search for records that fall within a specific date range. Hope it helps.
  10. Hello GoomAla, Welcome to Caspio forum! As fas as I know, information is updated after any actions on the page (refresh, click on the link etc). Hope it helps.
  11. iren

    Unique Records Check

    Hello ccarls, You can check the ‘Unique’ option in Table Design to enforce the uniqueness of values entered in the field meaning that no two records can have the same value for the field. Hope it helps.
  12. Hello cogclou3, There is a post which discuss the similar scenario: http://forums.caspio.com/index.php/topic/4997-concatenation-does-not-work-in-update-forms/#entry15681. Hope it helps.
  13. Hello cogclou3, I would recommend to change document.getElementById('Submit').onmouseover to document.getElementById('Mod0EditRecord').onmouseover and document.getElementById('InsertRecordActual_DateTime') to document.getElementById('EditRecordActual_DateTime'). Hope it helps.
  14. Hi Accountability, Select the Results Page - List/Gallery Layout DataPage Element, select the Data Cells Element Type and change border size. Also you can change values of 'border-width' in '.cbResultSetListViewTableOddCell' and '.cbResultSetListViewTableEvenCell' classes on the Results Page - Data DataPage Element, the Source tab. Please note, that changes will be applied to all DataPages that are assigned with the Style. So you can copy your style and work with the copy. Hope it helps.
  15. Hi ScottDube, You can insert new criteria in your Report DataPage to filter the field by two boundaries. For example for a Date field you can have two Criteria, FROM and TO so you can search for records that fall within a specific date range. Hope it helps.
  16. Hi Parma2015, You can insert new criteria in your Report DataPage to filter the field by two boundaries. For example for a Date field you can have two Criteria, FROM and TO so you can search for records that fall within a specific date range. Hope it helps.
  17. Hi bookish, You can add HTML block on the Result page and use following code: <SCRIPT LANGUAGE="JavaScript"> var test='<a href="URL&amount='; var countr = '[@field:country]'; if ((countr !="country1")&&(countr !="country2")) { if('[@field:activity]'=="activity1") {test=test+'[@field:amount1]';} else { if('[@field:activity]'=="activity2") {test=test+'[@field:amount2]';} else {test=test+'[@field:amount]';} } } else { test=test+'[@field:amount]'; }; test=test+'">the link</a>'; document.write(test); </SCRIPT> Please change URL to your. Hope it helps.
  18. Hello landap, Welcome to Caspio forum! When to set a field as a parent of a Cascading DropDown, the ID of this parent field becomes dynamic. There is a post which discuss the similar scenario: http://forums.caspio.com/index.php/topic/4292-total-field-in-a-submission-form/#entry13553 Hope it helps.
  19. Hello Jan, To create the 'Next' button instead of arrows in the 'Details' report, you can use next script in footer: <a id='next'> <img src='button_image.gif'> </a> <script> var linktonext=document.getElementsByName("JumpToNext"), navBar = document.getElementsByClassName("cbFormNavigationTable")[0], nextButton = document.getElementById("next"); navBar.style.display='none'; if(linktonext.length){ nextButton.href= linktonext[0]; }else{ nextButton.style.display = 'none'; } </script> Note: The "Navigate to next/previous records" option should be selected for the 'Details' report. Hope it helps.
  20. Hi Elena, Tell me please, the code does not work or 'Error' message still appears?
  21. Hello Paul, Welcome to Caspio Forum! Maybe, this article can help.
  22. Hello Molly, Welcome to Caspio Forum! Do you import excel file or archive with excel file into caspio? What format this file have? Could you please provide this file for investigation?
  23. Hello Elena, You can use following code in the calculate field: SELECT SUM([@calcfield:1]+[@field:Experience_Min]+[@field:Education_Min]+[@field:ConsequencesErrorsNew]+[@field:Work_Delegation]+[@calcfield:29]+[@calcfield:28]+[@calcfield:36]) FROM SJECS WHERE [@field:Last_Name]>[@LName] Hope it helps.
×
×
  • Create New...