bahar_vm

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>

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

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

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?

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

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

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

kandersen, Caspio Cloud Database is now public and you can see it in Zapier's app directory.

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

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

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

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

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

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>

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>