Jump to content


Caspio Moderator
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by bahar_vm

  1. Hi Master! To get the value of the selected radio button, you can use the 'checked' property in JavaScript. Here is a good reference in w3schools which explains it: http://www.w3schools.com/jsref/prop_radio_checked.asp Example: loop through the radio button options and get the value of the selected option. The following code works in a Submission form. For Update form or Details page, replace InsertRecord with EditRecord. FIELDNAME should be replaced with your field name (the radio button field). <script> var radios = document.getElementsByName("InsertRecordFIELDNAME"); for(i = 0; i < radios.length; i++) { if(radios[i].checked) { var selectedvalue = radios[i].value; } } </script>
  2. Maybe instead of the long code above, you can try putting the following line of code in the header of your second DataPage which refreshes the DataPage every X seconds (5 in this case). If this works for you, it's a much easier solution. <meta http-equiv="refresh" content="5" > Best, Emma
  3. Hi Sergio, This is in the roadmap, you can vote for it here: http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/3067411-pivot-table-datapage or http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/5281459-calculation-and-aggregation-summary-reports Best, Emma
  4. Can you clarify what you mean by "Return"? If you are referring to submit the form without entering the required fields then why making them "required" first place?
  5. Hi Elena, When data in actual fields are updated through details or results page, the page shows the updated data, if the actual fields are included in the page and the report filtering configuration is not filtering the record out. Not sure why you weren't seeing the updated data, if data is not sensitive you can provide the URL of your original report where I can see the issue. Best, Emma
  6. Hi, To add to your comment, use the script provided here: http://forums.caspio.com/index.php/topic/3148-js-select-multiple-values-from-a-listbox-in-a-webform/ if you want to enable multi-select in Submission form. For Update form you can use the one that you posted above. Best, Emma
  7. bahar_vm

    Expired Record

    This article can help: http://howto.caspio.com/faq/reports-datapages/how-to-filter-reports-based-on-an-expiration-date/
  8. bahar_vm


    kandersen, Caspio Cloud Database is now public and you can see it in Zapier's app directory.
  9. Hi, How about making the username field in the table unique so each user can only submit once? Or to limit submissoin based on email address or any other unique info which is collected during submission. There is not a rule to set up on individual field to remove an item from the list if it's once selected. ~Emma
  10. Hello, Calculated fields currently are only available in Report and Details DataPages. They are not available on the table or view. If you need the calculated values to be stored in the table upon submission or update, you can use JavaScript. See an example here http://forums.caspio.com/index.php/topic/3149-js-perform-a-calculation-on-values-entered-in-a-webform/ Hope this helps. ~Emma
  11. Heatmap is not available at this time. If you are a programmer, you can integrate Caspio report DataPage with a third-party heatmap. Depending on how the heatmap collects and reads data, you may need to use WS API and/or JavaScript to integrate your Caspio database with the heatmap. Feel free to suggest the feature in http://ideabox.caspio.com/. ~Emma
  12. Hi Staci, To look up the company id from your users table you can use a field parameter in the following format: [@authfield:FIELDNAME] You can place this in header/footer, HTML blocks of your DataPages. ~Emma
  13. David, it may have caused by a new release. Please check it out as we've already fixed it and patched it out. Best, Emma
  14. Place the script below in the Footer of your details/update page. Status is my checkbox field. Change Status in the code to your field name. Time_status_edited is a hidden field to store the timestamp. Change Time_status_edited to your field name. --------------------------------------------------------------- function getT() { var prevValue='[@field:Status]'; if(((prevValue!= 'Yes') && (document.getElementById("EditRecordStatus").checked)) || ((prevValue== 'Yes') && (!document.getElementById("EditRecordStatus").checked))) { document.getElementById("EditRecordTime_status_edited").value = '[@cb:Timestamp]'; } } document.getElementById("caspioform").onsubmit = getT; </script>
  15. The script below records date/time (timestamps) when a specific field (in my case Status field) is updated. You don't need any virtual field. Place the script in the Footer of your details/update page. Status is my dropdown field (it could be a text field as well). Time_status_edited is a hidden field to store the timestamp upon updating the Status field. <script type= "text/javascript"> function getT() { var prevValue='[@field:Status]'; if(document.getElementById("EditRecordStatus").value != prevValue) { document.getElementById("EditRecordTime_status_edited").value = '[@cb:Timestamp]'; } } document.getElementById("caspioform").onsubmit = getT; </script>
  16. There is an article about how to accomplish keyword search in a report, visit the article here: http://howto.caspio.com/faq/reports-datapages/how-to-do-keyword-search-across-multiple-fields/.
  17. Calculated field in results page is generated on the fly each time results page is loaded. It cannot be saved into the table. Calculated field in web form can be saved into the table after submission by using JavaScript. In details page, you can create another field and make it hidden, then select "DataSource Fields" from "On load assign" dropdown and select your calculated field from the list. This enables passing the calculated field as parameter into the new field. Make sure passing parameter in your DataPage is enabled from the second wizard screen.
  18. Hi, User logs feature has been built in the product long time ago. Find more information about it here: http://howto.caspio.com/authentications-and-connections/users-log/ Best, Emma
  19. Hi Matthew, I recommend creating a Trial account and initiate engagement with Caspio Professional Services team. The consultations are free, they collect your requirements and provide you a quote and timeline accordingly. You'll decide should you want to proceed. Another approach is to build it yourself if you have the time and technical knowledge based on complexity of your application. Third approach is to refer to developers listed here https://www.odesk.com/groups/caspio on the right hand side you will see a list of Caspio freelancers. My recommendation is to go with Caspio Professional Services for the higher quality, maintenance and support. Best, Emma
  20. Hi Mike, To clarify, this is a known issue since Notification/Acknowledgement emails in a submission form only have access to the values that were actually inserted and they do not have access to the other values via view. We suggest using Details DataPage, which you already did:), where emails have access to all fields of the current record. If it has to be a submission form based on multi-table view, then a workaround is to redirect to a Details DP which sends the email and auto-submit using JS. ~ Emma
  21. Vote for this feature at http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/3140597-create-a-field-that-will-accept-a-signature. Or submit new feature request. Product team reviews the feature requests list periodically and implement them into the product based on priority, popularity, and a few other factors.
  22. Hi, to display the parameter you can input the parameter in the Header/Footer or HTML block which repeats for each record. For example if the parameter passed from submission/search is called [@state] you can receive it in the HTML block same [@state]. Does this help?
  23. Hi Dominique, Caspio authentication requires logging in for the first time. But I understand the use-case of auto-login capability. You can add this request to the ideabox http://ideabox.caspio.com. Caspio product team review the requests and prioritize them for future releases. Best, Emma
  24. Hi Elena, this video shows what you're looking for: http://howto.caspio.com/getting-started/filter-data-results-on-a-single-web-page/. Instead of a tabular report you have a chart report but the solution is the same. Best, Emma
  25. The solution provided above calculates the average properly however since it uses calculated field the average is displayed on each record which I don't think is desired. Here is another approach: 1) Add two Calculated Fields: Sum and Count 2) In the Sum Calculated Field enter the formula: IsNull([@field:field1],0)+IsNull([@field:field2],0)+ ... +IsNull([@field:fieldn],0) 3) In the Count Calculated Field enter the formula: (IsNumeric([@field:field1])+IsNumeric([@field:field2])+ ... +IsNumeric([@field:fieldn])) This formula allows you to calculate the number of non blank values. 4) Add a Totals & Aggregation element, select both Calculated Fields: Sum and Count, use the function SUM. 5) Add the Header & Footer element and in the Footer enter the JavaScript code below: <SCRIPT LANGUAGE="JavaScript"> var sum = document.getElementsByClassName("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate")[0].innerHTML; var number = document.getElementsByClassName("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate")[1].innerHTML; var avg=sum/number; document.getElementsByClassName("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate")[0].innerHTML=avg.toFixed(2); document.getElementsByClassName("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate")[1].innerHTML=""; </SCRIPT> Notes: The JavaScript does the final calculation and write the final value into the aggregation row and blank out the count cell. avg.toFixed(2) rounds the number to 2 numbers after decimal point. You can adjust it as desired. document.getElementsByClassName("cbResultSetTotalsData cbResultSetTotalsDataCellNumberDate")[0] ... 0 refers to the first data cell in totals and aggregation row and 1 refers to the second data cell and so on... Use F12 in browser to open developer tool where you can inspect page elements and find their id, class, ....to adjust your scripts when needed.
  • Create New...