Leaderboard

/* Turn autocomplete off on form*/ document.getElementById("caspioform").setAttribute("autocomplete", "off"); /* Turn autocomplete off on each input text element*/ if (document.getElementsByTagName("input").length > 0) { var inputElements = document.getElementsByTagName("input"); for (i=0; i < inputElements.length ; i++) { if (inputElements[i].getAttribute("type") == "text") { var att = document.createAttribute("autocomplete"); att.value = "off"; inputElements[i].setAttributeNode(att); } } }

Hi, just to add to the previous comment above. If you have created a Trial account it will be automatically be deleted after 14 days. All the resources and objects in your Caspio Bridge account will also be deleted.

Since altering the formula may be an issue, I would like to suggest creating another formula field and copying the formula from the previous one so it gets you a fresh set of field. I am thinking that the system automatically preserves the alteration of the field to avoid failing and possible incompatibility issues.

Hello @richs, I believe you may have this problem because [@field:town] is the text value. You may get the value of the Mill_rate from your lookup table with the following formula so it will be the Number type: SELECT [@field:Mill_rate] FROM Town_lookup WHERE Town=target.[@field:Town] And then you can have another calculated value which is [@field:House_value]*[@field:Mill_rate]/1000 Just change the names of the fields to yours. Hope this helps!