Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

535 profile views

senicholas's Achievements

  1. I have a tabular report which I added a html block with the following code from Caspio's Link Menu Generator: <a class="cbMenuItem" href="#" onclick="window.open(&quot;https://c1acu852.caspio.com/dp/c38980008b3a124afe5e462bbf5e?[@Tbl_Orders_OrderNumber]=AAAAAA&quot;,&quot;mywindow&quot;, &quot;menubar=1,resizable=1,width=500,height=600&quot;)">Modify Order</a> | It is popup form that will allow the customer to edit the order, however, the popup gives "No record found". Not sure if am not passing or receiving the parameter [@Tbl_Orders_OrderNumber]. Any ideas?
  2. I can color the background on input fields, but not having luck on calculated fields. Also want the amount in bold.
  3. I added the following script and it works great! <SCRIPT LANGUAGE="JavaScript"> function f_a(v_id) { return document.getElementById(v_id); } f_a('InsertRecordTEL').maxLength = 14; f_a('InsertRecordTEL').onkeyup = function(v_e) { v_e = v_e || window.event; if (v_e.keyCode >= 65 && v_e.keyCode <= 90){ this.value = this.value.substr(0, this.value.length - 1); return false; }else if (v_e.keyCode >= 37 && v_e.keyCode <= 40){ return true; } var v_value =(this.value.replace(/[^\d]/g, '')); if (v_value.length==7) { this.value = (v_value.substring(0,3) + "-" + v_value.substring(3,7));} else if(v_value.length==10){ this.value = ("(" + v_value.substring(0,3) + ")-" + v_value.substring(3,6) + "-" + v_value.substring(6,10)); }; } </SCRIPT>
  4. I added the following to my footer, but nothing happened: <SCRIPT LANGUAGE="JavaScript"> function tel() { var message = document.getElementById("InsertRecordTEL").value; // here you get what the end-user typed document.getElementById("InsertRecordTEL").value = (message.replace(/[^\d]/g, '')); // then you strip off all the spaces var message1 = document.getElementById("InsertRecordTEL").value; document.getElementById("InsertRecordTEL").value = ("(" + message1.substring(0,3) + ") " + message1.substring(3,6) + "-" + message1.substring(6,10)); } document.getElementById("caspioform").onsubmit=tel; </SCRIPT> What am I missing. Field name is "TEL"
  5. I have a data page, with three items I click on product, populate a field with the cost per item, add add the number of units, then have calculated field of # of units * cost per unit. It works fine, but I have another calculating field to add the 3 items for a total cost. The only time the total cost works is when I complete all three items. I assume some kind of a null value is causing the problem. Any ideas who to solve this calculation?
  6. I use many menu's through the theme Grow Pro (http://www.thinkupthemes.com/themes/grow/). I would suggest you download the following app, Pages by User Role for WordPressYou assign each page to a user group based on the login. This will enable only the menu's associated with login to appear.
  7. I have this code in the html block referring to p=2149 to popup. I wish to change the page to popup and I have forgotten where to find this reference number to popup another page.
  8. Thanks. The only problem is it refreshed the entire page losing all the entered data.
  9. Is it possible to add a button that would open a new window allowing me to add a new vendor? The submission form has drop downs, but, when the vendor is not present, you must close and open the add vendor data page, then start all over adding the transaction
  10. Ajax is turned off. Here is the url: https://b5.caspio.com/dp.asp?AppKey=9f653000e90c1f13e3f34386b118
  11. I replaced the original footer with above, unfortunately, the columns did not change background color. Thanks for your help.
  12. How do you restrict it to one field. It works, but looks at all the numbers in the report. The field if F7
  13. I have asked this before, but I just cannot get it to work. I am running a report with the first column, field name is F7. It contains a series of numbers which I which for the numbers to turn red when they exceed the number 7. Here is what I have now in the footer, but it does not work: <br /> <SCRIPT LANGUAGE="JavaScript"> var elems = document.getElementsByTagName("F7"); for (var i=0, m=elems.length; i<m; i++) { if (elems.innerHTML>7) { elems.style.color="red";} } </SCRIPT> It would be even better if I could change the background color to yellow
  14. I changed the default value to 0 on the fields I am adding and it works like a charm. Thank you very much!!!!
  • Create New...