Jump to content


Caspio Rockstar
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by TellMeWhy

  1. If it helps, Caspio is using AWS for its infrastracture https://www.caspio.com/caspio-recognized-amazon-web-services-partner-network-advanced-technology-partner/ https://partners.amazonaws.com/partners/001E000000Rp5PmIAJ/Caspio}
  2. What's the use for Two Views? If you want to submit on both, you can use Trigger, otherwise, best option would be to combine all in one View instead.
  3. What does your Look Up Table look like? I believe it should be Wrench - 14 - Description A Wrench - 14 - Description B Wrench - 14 - Description Z So basically, all combinations, you have to input in your Lookup Table, you will then be able to see A B Z when Wrench and 14 is selected
  4. That's strange, you are receiving it by adding InsertRecord on the Field name correct?
  5. I believe this is exactly what you're looking for? https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/ Instead of a Dropdown, you can use Calculated Value that gets the value of your dropdown instead and use CASE WHEN
  6. Remove the comments, the ones with '//' it seems it's interfering with the code. Also, for width, it seems you can do padding 0 is for the top and bottom, 50px is for the left and right, you can even specify it more like (0 50px 0 50px) I believe that's top left bottom right.
  7. What does your CSS code look like now, have you used all the lines for each browser in my previous response (-webkit, -moz, etc.)? It's easier to directly check the page, can you give the link? Perhaps duplicate your DataPage and filter it with a test record so no real data will be public
  8. ah no, have you tried target? just 'target', like the one I've sent, not the table name.
  9. Really difficult to understand the workflow as is, but, what I understood is you're just having difficulty with the ig1q value because it adds instead of replace. I believe you should reiterate or re-initialize the values AFTER change and not just add to the variables that's already set
  10. Not sure what the RIGHT is for, you can try this CASE WHEN isNumeric(FIELD) = 1 THEN CONVERT(INT, ROUND(FIELD,0)) ELSE 0 END it checks if it's numeric (numeric may be INT, Float, etc) if it is (equal to 1) Then Round the Field to 0 decimal (because INT has no decimal) and convert it to INT(can be omitted, but, just to be sure) to avoid incompatible values when the field's value is in decimal Else, 0 or any number you want
  11. What DataPage is this? try using WHERE Job_ID = target.[@field:Job_ID]
  12. Truncation is only for display. Why do you need to truncate the characters? You can set the max length for input, they can't add any more if the data already exceeds the max length, they can only erase the data and then input up to the max length you set
  13. should be something to do with overflow of the container, this one hides it, if you want the scrollbar, just use 'scroll' instead of 'hidden' https://stackoverflow.com/a/63554236
  14. Adding to Meekeee's answer, note that this is also applicable for Views I believe you can also export view, and it will be accessible in Excel. Can also be useful when you're using Scheduled Task to export
  15. Yeah, it's pretty risky, but, maybe you can require an email address on the payment form? You can also make the receiving field required and hide it This will prevent the form from being submitted if nothing is passed. Also, if you haven't checked this out for your workflow https://howto.caspio.com/tech-tips-and-articles/common-customizations/dynamic-redirects-after-form-submission/
  16. Here;s an updated code Virtual 2 is my dropdown You can put the dispatch event after the if elses instead so you'll have shorter code 2nd script tag is what I added <script type="text/javascript"> document.getElementById("EditRecordyess").addEventListener('change', function(event) { if (document.getElementById("EditRecordyess").checked==true){ document.getElementById("cbParamVirtual2").value='Online'; } else if (document.getElementById("EditRecordyess").checked==false){ document.getElementById("cbParamVirtual2").value='Off'; } document.getElementById('cbParamVirtual2').dispatchEvent(new Event('change')); }); </script> <script type="text/javascript"> document.getElementById('cbParamVirtual2').addEventListener('change', function(event) { if (document.getElementById('cbParamVirtual2').value=='Online'){ document.getElementById("EditRecordyess").checked=true; } else if (document.getElementById('cbParamVirtual2').value=='Off'){ document.getElementById("EditRecordyess").checked=false; } document.getElementById("EditRecordyess").dispatchEvent(new Event('change')); }); </script> <script type="text/javascript"> document.getElementById("cbParamVirtual2").addEventListener('change', function myFunction(event) { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); }); </script> No Update and Submit works as "Submit Form" tabular reports is MUCH harder to do custom coding on
  17. what field is that dropdown? Is it the status location or an entirely different one not used in the script? 2. No, it ALWAYS refreshed upon submission of form. It's an HTML thing.
  18. Ah I know it now. changing the values on JS will not trigger the eventlistener, you need to explicitly dispatch that event once the value changes. Use this on both the if and else document.getElementById('EditRecordStatusLocation').dispatchEvent(new Event('change')); Here's my script <script type="text/javascript"> document.getElementById("EditRecordyess").addEventListener('change', function(event) { if (document.getElementById("EditRecordyess").checked==true){ document.getElementById("cbParamVirtual1").value='Online'; document.getElementById('cbParamVirtual1').dispatchEvent(new Event('change')); } else if (document.getElementById("EditRecordyess").checked==false){ document.getElementById("cbParamVirtual1").value='Off'; document.getElementById('cbParamVirtual1').dispatchEvent(new Event('change')); } }); </script> <script type="text/javascript"> document.getElementById("cbParamVirtual1").addEventListener('change', function myFunction(event) { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); }); </script> This submits mine upon checking or unchecking
  19. Can you try this for the auto submit script? <script type="text/javascript"> document.getElementById("EditRecordStatusLocation").addEventListener('change', function myFunction(event) { // submit the form if an value is selected setTimeout('document.forms["caspioform"].submit()',1000); }); </script>
  20. '*F' + CONVERT(Varchar,[drop_id]) + '*'
  21. That should work, maybe try using columnName in the View(it might be different name as Caspio appends table name on the column name sometime) instead of inserting it via Field Picker (DISTINCT ClientID)
  22. seems like you're missing var elems = isi.parentNode.parentNode.querySelectorAll("td"); it's set just above the for loop
  23. Are you using Inline Edit and Inline Insert? If so, this will not work, because Results page is an entirely different behavior
  • Create New...