Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

About senicholas

  • Rank

Recent Profile Visitors

442 profile views
  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].
  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 = (
  4. This works, many thanks!
  5. 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.getE
  6. 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?
  7. Ajax is turned off. Here is the url: https://b5.caspio.com/dp.asp?AppKey=9f653000e90c1f13e3f34386b118
  8. I replaced the original footer with above, unfortunately, the columns did not change background color. Thanks for your help.
  9. How do you restrict it to one field. It works, but looks at all the numbers in the report. The field if F7
  10. 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
  11. I changed the default value to 0 on the fields I am adding and it works like a charm. Thank you very much!!!!
  12. Maybe this is my problem, I have the crate_xx_quanity fields in the form as text, but the db is number.
  13. The crate_one_Quanity fields are number fields and the ttl_crate field is a text. The url on my test page is: https://b5.caspio.com/dp.asp?AppKey=9f653000b65254d3e607447ab34e
  14. Thanks, I made the modifications, but it still does not write to the DB. Are only text fields allowed to writer to?
  15. I have been working the code below, adding 3 text fields and tying to write the total to the field TTL_Crates, but, I cannot get it to work. Any ideas? <br /> <script language="JavaScript"> function calculate() { var v_one= parseFloat (document.getElementById("InsertRecordCrate_One_Quantity").value); var v_two= parseFloat (document.getElementById("InsertRecordCrate_Two_Quantity").value); var v_three= parseFloat (document.getElementById("InsertRecordCrate_Three_Quantity").value); var v_total = (v_one + v_tw
  • Create New...