Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


carlJS last won the day on November 4

carlJS had the most liked content!

About carlJS

  • Rank

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello y'all, This solution is great. I have tested it. However, on my use case, I had dropdowns and textareas which were not affected by the reset. I just wanted to share an updated code that will affect such. <button type="button" onclick="resetForm()">Clear Form</button> <script> function resetForm() { var myForm = document.querySelector('form[action*="[@cbAppKey]"]').querySelectorAll('input:not([type=submit]):not([type=hidden]), textarea, select'); myForm.forEach(function(elem) { elem.value=""; }); } </script> [src="carl.js"]
  2. Hello Mikey, The DataPages deployed on the same pages should automatically be updated with records when an action is done on one of your DataPages. This feature is called AJAX Loading and is enabled by default. You may check on this article for more information: https://howto.caspio.com/datapages/ajax-loading/ Let me know if this is not what you're looking for. [src="carl,js"]
  3. Hello, This also works by using 1/0. I prefer to use this one as Calculated Values in Yes/No fields only accepts these values.
  4. You may check this article for 3rd party apps that offer the scrolling screen capture functionality. Snagit does this. https://www.guidingtech.com/scrolling-screenshots-windows-10/ https://support.techsmith.com/hc/en-us/articles/203731528-Snagit-Windows-Custom-Scroll-in-Snagit-12 Hope this helps [src="carl.js"]
  5. Hello, You may also want to use Calculated Values for this. Below is the syntax I used in one of my workflows. CASE WHEN DATALENGTH('[@field:Cancel_Notification_Date]') > 0 AND [@field:Auction_Status] = 'Cancelled' THEN '[@field:Cancel_Notification_Date]' ELSE CAST( '[@cbTimestamp~]' as DATETIME ) END I hope this helps [src="carl.js"]
  6. Hello, You may also want to check on this thread It shows how to prevent form submissions using Caspio Standard Features. With regards to showing an error message, you may show/hide and HTML Block using rules. Hope this helps. [src="carl.js"]
  7. Hi, I believe you can put a literal line break in Calculated Fields. As shown in the screenshot below, I've tested it and it works. [src="carl.js"]
  8. Hello guys, Try using this line of code. var chart = Highcharts.charts[+document.querySelector('[action*="[@cbAppKey]"] .highcharts-container').id.replace('highcharts-', '')] Works on my end. Hope this works on yours too. [src="carl.js"]
  9. This line of code of yours should work. window.opener.location.href = "url popup window"; Do note that the value is interpreted as a relative path so you may want to specify a scheme/protocol if you want it to be an absolute URL e.g. https://www.mysite.com [src="carl.js"]
  10. Hi @NeoInJS, You may try pasting the code snippet provided in an HTML Block. (Note: Disable the HTML Editor from the Advanced tab, and move the HTML Block to the very bottom). Note that we can add/remove items in the fields array. We can add DataSource fields as well. Just duplicate field lines as needed and put cbParamVirtualn, or the name of your DataSource field. <script> var fields = [ 'cbParamVirtual1', 'cbParamVirtual2', 'cbParamVirtual3', 'cbParamVirtual4', ]; /* * * Do not modify code from beyond this point */ fields = fields.map( function(elem) { return document.querySelector('[action*="[@cbAppKey]"] [id*='+ elem + ']'); }); function changer(ev) { fields.forEach(function(field) { if (ev.target.value != '' && ev.target != field) field.value = ''; }); } fields.forEach(function(fff) { fff.addEventListener('change', changer); }); </script> [src="carl.js"]
  11. Hi @TroubleShooter, You may use the syntax below on a Calculated Value to get the First Sunday of the Month. Virtual 1 represents numeric month Virtual 2 represents numeric year DATEADD ( day, (( 8 - DATEPART(weekday, CAST('[@cbParamVirtual1]/1/[@cbParamVirtual3]' as DATE) )) % 7 ), CAST('[@cbParamVirtual1]/1/[@cbParamVirtual3]' as DATE) )
  • Create New...