Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by ezIQchad

  1. I asked Caspio about this about a year ago. They said they had no plans to allow dynamic data sources for DataPages.
  2. I think you'll need to cycle through the records and delete them one at a time. You can build an auto deleting details DataPage that will do this for you. based on-> http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage/ with some changes <script type="text/javascript"> if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.getElementById('Mod0DeleteRecord').click()',300); } </script> Destination after record update "Go to the next record"
  3. What code are you using for this? What is the address of this page; if I can see the source code I can help you figure it out
  4. This is probably a workaround, but if it works it's very easy... CSS in the header of your DataPage maybe? <style> label { margin: top right bottom left; padding: top right bottom left; width: 80px; etc. } </style>
  5. document.getElementById('elementID').value; "value" comes after the element is identified value, innerHTML, style, onchange, etc. all come after the element is identified EDIT: I can't tell if you need javascript or not. If not... <b>Case Manager: [@cbParamVirtual1]</p> <b>Emergency Contact: [@cbParamVirtual2]</p> If it's the same page obviously you know you need it, if it's two pages this example should work.
  6. Are you trying to combine the fields? Like with a space between the values? If what you need is a concatenated parameter, use an additional Virtual combined with some js to concatenate the values. var vP3 = document.getElementById('cbParamVirtual3'); var vP5 = document.getElementById('cbParamVirtual5'); var vP6 = document.getElementById('cbParamVirtual6'); vP3.onchange = function(){ vP6.value = vP3.value + " " + vP5.value } vP5.onchange = function(){ vP6.value = vP3.value + " " + vP5.value }
  7. Try @ where the @ would go. @ is the HTML / ASCII code for @ double posting
  8. On the last page of the Data Page editor (Destination and Emails), choose to "Display a Message", and put your code in that message. If you use the built in redirect "Go to new page" or "Go to DataPage" that is often selected in place of "Display a Message", you'll need to build some code for the redirect. window.location.href='some-file.html';
  9. What do you mean by membership type? I hear AuthTable, but makes me think otherwise. Is membership something you select on the fly?... like by checking checkbox A or B. Or is it in the AuthTable? If it's an AuthTable scenario see... http://forums.caspio.com/index.php/topic/5501-conditional-formatting-trick/ Add AuthTable Parameters to the Class or ID and use CSS to do whatever you want with each element. If it's something you select on the fly, use Rules Tab in the Caspio DP builder to hide or show sections.
  10. I would suggest using two search sets found ->>http://howto.caspio.com/tech-tips-and-articles/parameters/add-a-search-interface-to-results-sets-page/ Two Sets - School One & School Two (for a total of four data pages)
  11. A work around. Setup: Create a Locked Record field to your table. 1. User clicks edit 2. Update Data Page with the Auto-Submit script found ->> http://forums.caspio.com/index.php/topic/4314-js-auto-submit-a-datapage 2. a. If "Locked Record" = "Yes" then display a message and abort the edit. 2. b. Use this to change your new Locked Record field to locked. 3. Redirect to the main edit Data Page. 3. a . Include a hidden field that will turn the "Locked Record" back to unlocked.
  12. Use a virtual field that passes a parameter; perhaps [@searchCriteria] Follow that with a dropdown and pass this parameter; maybe [@searchType] Then include [@searchType] in the path for where to go after a search. [@searchType].html?searchCriteria=[@searchCriteria]
  13. When you load a script into the header, is runs before the data loads. So if your script does anything with the data that loads, it must be in the footer. If you want something to appear in the header, you could create an Element in the Header and use JS from the footer to populate that element.
  14. In working to reduce my data usage I learned that filtering at the Data Page also reduces data usage
  15. Aren't you already doing that? Use the "record count" number from the list report
  16. You use one view, not views. (if that's a language thing, pardon me) Create one view that joins multiple tables. Make sure the tables you are using in the view contain a unique field that the authentication will use to identify a specific user.
  17. Hello, Another formatting trick! I previously had challenges getting Caspio Forms to scroll properly. Then I learned about viewport in CSS -> https://web-design-weekly.com/2014/11/18/viewport-units-vw-vh-vmin-vmax/ #caspioform { overflow: auto; height: calc(100vh - 96px); } I use calc() to take into account the header. If you use calc the spaces between the values and the operator(-,+,*,/) is required.
  18. Email clients don't allow <style> .xyz{ style: value;} </style>, so this answer is wrong. Correct answer below You could add a style section to the email and use the examples from http://forums.caspio.com/index.php/topic/5501-conditional-formatting-trick/ <div class="some[@field:some]"></div> .some { display: none;} When field_some is blank .some will render the div not displayed
  19. Javascript is way more powerful, but... Too much Javascript can hinder performance
  20. You could pass that as a parameter to an "Update Data Page" that auto-submits, but DON'T DO THIS This is poor database design. Use a view to count the records on display.
  21. Notifications can go to many emails addresses. Acknowledgements go to only one.
  22. It looks like you have an extra closed bracket, but also try... 1. Drop dropping in some alerts throughout to see where it's breaking. 2. I recommend style.display = 'none' over style.visibility = 'hidden' <SCRIPT LANGUAGE="JavaScript"> alert('Hi - test1'); var eigenaar='[@s_id]'; alert(eigenaar); var aanmaker='[@authfield:user_tabel_user_id]'; alert(aanmaker); } if (eigenaar!=aanmaker) { alert('Not equal!'); document.getElementById("Voeg_toe").style.visibility = 'hidden'; alert('Visibility set to hidden. Is it hidden?'); } </script>
  • Create New...