Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by Aurora

  1. Hi all, Does anyone know how to make image responsive? There is a responsive code for image, but it doesn't work on datapage when you have an image. Thanks
  2. 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.
  3. 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/
  4. 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>
  5. Hi all ! Does anyone has a solution for this? I need to hide some text on the details page, when AuthField' value is not equal value from the Field#2. Merci!
  6. Try this one: <SCRIPT LANGUAGE="JavaScript"> document.getElementById("Mod0DeleteRecord").style.display = 'none'; function MyFunction() { var stat=document.getElementById('cbParamVirtual1').value; var del = "Delete"; if(stat==del) { document.getElementById("Mod0DeleteRecord").style.display = 'initial'; } else {document.getElementById("Mod0DeleteRecord").style.display = 'none'; } } document.getElementById('cbParamVirtual1').onchange=MyFunction; </SCRIPT>
  7. Hi Mylene, That's easy. You should add Virtual Field, where users will type "Delete". Use the following code: <SCRIPT LANGUAGE="JavaScript"> var stat=document.getElementById('cbParamVirtual1').value; if (stat ==!'Delete') { document.getElementById("Mod0DeleteRecord").style.visibility = 'hidden'; } </script> Happy Holidays
  8. Hi Satch, You can take a Virtual Field by ID as well : document.getElementById("cbParamVirtual1"). There is a similar script here: http://forums.caspio.com/index.php?/topic/3149-js-perform-a-calculation-on-values-entered-in-a-webform/
  9. Hi Rentosa, Could you please clarify the name of parameter that you send, like.... &street=[@field:location] and the name of parameter you receive. Aurora
  10. Hello Gregstand, Yes it is possible to pass and receive parameters in Iframe: Aurora
  11. Hi there. If you open the localization , you can change " no record found" message there. http://howto.caspio.com/localizations/modifying-a-localization-object/ A.
  12. Hi Robert, You can use dropdown with Custom values and LookUp Table and use RLS there. On load you can receive external parameters of the auth field. In this case default value will be the one that you receive as parameter. A.
  13. Hi zalipresents, What is this? If I understand correctly, you use Cascading Field as a trigger for calculation? If yes, then I am afraid It is not possible. Perhaps, it is possible for .onsubmit action. ( Not sure). Aurora
  14. HI zalipresents, Please take a look at this post. After a Form has been submitted, you can send send parameters to two DataPages sourced on different Tables and submit both at once: Since one Form will be deployed as an Iframe in the Footer of another DataPage, you will need to use this approach to receive parameters in Iframe: I hope this help! A.
  15. Hi Mylene, As far as I know it is impossible to mass input data to the Table. But it is possible to submit record one by one. I have a Tabular report and every record has the "Add" button. On click, the New Form opens that receives parameters and auto-submit data to another table. Basically, this is invisible for my Users. To this, please do the following: 1) Create a Submission Form based on the second Table where all fields receive parameters on load. Click Finish->Deploy-> URL method->copy the URL 2) In the Tabular Report add a HTML block. 3) Create the "Add button" using Link Generator or simple code to create Pop-Up window: <a class='cbMenuItem' href='#' onclick='window.open("http://URL_OF_SUBMISSION_FORM.com&parameter=[@field:your_field]","mywindow", "menubar=1,resizable=1,width=500,height=500")'>ADD</a> | where URL_OF_SUBMISSION_FORM- is URL of the Submission form from step 2 and parameter- is a parameter that you want to pass on exit and receive on load in Submission Form. You should send parameters of all fields. 4) Go to Submission Form and in the Footer of it insert a auto-submit code from here: Every time User clicks Add, there will be invisible auto-submit Form, that will send information from selected fields to another Table. Hope this helps! Cheers Aurora
  16. Hi Mylene, You should have 2 tables ( and one with User Table) : Items Orders After user logs in and opens a page with Items, we use a submission form with auto-submission script and submit a new record with userID (taken from authentication fields) and orderID (auto number) to the “User-Order” table. We will create a unique Order_ID for each order on this step. Then we pass Order_ID as a parameter and user will be redirected to the results page with items. You may add a button like “Add this item” for each record on the results page. When user clicks on a button, we will call a popup with a submission form, using an auto-submission script and a new row will be added to the “Orders” table. We will pass item and Order_ID, which was passed from the previous step. Please find useful links below: How to create a popup window with a submission form: http://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-generate-link-menus-and-popup-windows/ JS solution about creating auto-submission datapage: http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage/ An article about passing parameters: http://howto.caspio.com/parameters/passing-parameters/
  17. Hi Mylene, There is a way how this can be done, but you will need to create a Table for storing updated information. How it works: There will be 2 Forms, one for updating current information and one for storing old information to another table. Let’s say you have 2 Tables: Table 1 with all current information and Table 2-for changed information. So steps to do: 1) Create Single Record Update DataPage based on Table 1 , and add Virtual Fields. You should have the same numbers of Virtual Fields as the original fields. ( Like “First name”. “ Last Name”," Age" etc) This is the Form where users will update/change their information. All Virtual Fields will be Hidden and will receive and pass external parameters of all original fields on exit: http://howto.caspio.com/parameters/receiving-parameters/ http://howto.caspio.com/parameters/passing-parameters/ 2) Create Submission Form based on Table 2. All fields will receive parameters of virtual fields on load. 3) Add Header/Footer element and insert the following script there: http://forums.caspio.com/index.php?/topic/4314-js-auto-submit-a-datapage/ The script submit the page automatically, so this DataPage will be hidden. 7) On the destination page of the Single Record Update page, select "Go to the new DataPage" and select Submission Form from the list. I hope it's not too complicated and makes sense. Aurora
  18. Hello oksigendigital! I don't think it is possible! 10 DataPages on 1 web page is quite a lot !
  19. Hello Simong, As far as I know, Caspio doesn't allow to send emails to more than one Customer to prevent spamming. Aurora
  20. Hi Mylene, I could do this before and even posted a topic here, on Forum. But somehow it stopped to work and I've found a workaround. So, I created two Submit Forms and put AUTOSUBMIT code in the Footer of each DataPage. I deployed second DataPage as Iframe into a HTML block of the first DataPage. I hope this solution helps. Aurora!
  21. Hi Mylene, In my case I have deployed Iframe of the Details Page into the HTML block of the Submission Form. I modified a URL of the Iframe deploy code so it looks like this now: <iframe name="AutoSubmit2_1" title="AutoSubmit2_1" src="https://c0ebl890.caspio.com/dp.asp?AppKey=52e04000sdfsdfsdgdg29a&ID=[@field:ID]">Sorry, but your browser does not support frames.</iframe> I added parameters at the end of the AppKey string. Hope it helps Salut! Aurora
  22. Hi Matilda, I hide a button of the First Form and use this script on the Second one: <script> function submitallforms() { setTimeout('document.forms[0].submit()',100); setTimeout('document.forms[1].submit()',200); } document.forms[1].onsubmit=submitallforms; </script> I hope this helps. Best, Aurora
  23. Hi Michelle ! I think I have some similar code. In my case there are 3 values - Done is # 1 in dropdown , which equals [0] in the script, Pending-#2 in dropdown and equals [1] in script, and Canceled- #3 in dropdown, [2] in script. Here is the code: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var dropdown =(document.getElementsByName("EditRecordYour_Field1")[0]); var date1 = new Date(document.getElementById("EditRecordDate_Field").value); var date2 =new Date(document.getElementById("EditRecordDate_Field2").value); if (date1>date2) { dropdown.options[2].selected=true; } if (date1<date2) { dropdown.options[0].selected=true; } if (date1.getTime()===date2.getTime()) { dropdown.options[1].selected=true; } } document.getElementById("EditRecordDate_Field2").onchange=calculate; </SCRIPT> The script works when you change second Date field. Good luck, Aurora
  24. Hi George, If I understand you right and you use update button, you use Details Page. There is an option to count visits: http://howto.caspio.com/faq/reports-datapages/how-to-count-the-number-of-times-a-record-has-been-viewed/ A.
  • Create New...