Search the Community
Showing results for tags 'field type'.
-
I have a table field AGE set as an integer. I need the form to disallow alpha characters in that field when exiting that field. Cant get ti to work. I still have submissions allowing "approx. 50" and I need to limit them to discrete numbers only. I added this script in footer, which helps, but its only on submit. Isnt the fact that the field type is INTEGER mean it wont accept letters by default? <script>function isNumberKey(evt){ var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 || charCode > 57)) return false; retu
-
A newbie here trying to create a database view of track and field results by 1) Field Events and 2) Track Events. Data for both types are stored in a result field in excel that I have defined in the Caspio table as a text field. Sort works great for the Track side of data but when I get to the Field side for the discus event I'm having a problem. Example of data being imported is 102' 11.5" for one record, and let's say 99' 03" for the next record. Since I have the field defined as text the sort put's the 99' 03" first. Any solutions without putting a leading 0 in front of the 99'?
-
Hello All; I am working through optimizing my app and step one is to ensure I'm using the proper field types. Is there an article that describes how much data is used per record per field type? Specifically: General Number Integer Number Currency Number Yes/No Text(255) Text(64000) I have a pretty good guess on how these rank, but more detailed information on exact data used will help greatly. Thanks CHAD
- 3 replies
-
- table
- field type
- (and 8 more)