Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

Everything posted by senicholas

  1. I can color the background on input fields, but not having luck on calculated fields. Also want the amount in bold.
  2. 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>
  3. This works, many thanks!
  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!!!!
  15. Maybe this is my problem, I have the crate_xx_quanity fields in the form as text, but the db is number.
  16. 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
  17. Thanks, I made the modifications, but it still does not write to the DB. Are only text fields allowed to writer to?
  18. 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_two + v_three); document.getElementByID(“InsertRecordTTL_Cratesâ€).value= (v_total); } /* On submitting the webform, the function calculate is executed */ document.getElementById("InsertRecordBid_Order Web Form_1").onsubmit=calculate;
  19. I have a submission form with 4 numeric fields. I wish to add the four fields and add to by table. Any ideas?
  20. Caspio support provided me a memo providing new commands; however, it only works on fields that have been updated. The remaining unchanged fields do not get emailed.
  21. The emails will not work when using a view. I converted to using a table and the emails work.
  22. I saw your earlier discussion, but I cannot get the html block to equal the field Dwell_Day. How do you do that?
  23. I wish to have the field Dwell_Days background color change to yellow when the value exceeds 7 on my data page.
  24. Sorry, I use WordPress and use Caspio as my Database. The Access is a Wordpress add on. So, my reply above does not apply directly Caspio
  25. Look for plug in called Access. It works great and is easy to set up. You can create roles and assign menu options depending on the role of the login
  • Create New...