Jump to content

roattw

Caspio Guru
  • Content Count

    192
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by roattw

  1. I want to include an HTML reminder text on a form when a specific field on a form is a certain value. Hint/Tip not what I want since its hidden unless licked. I want some RED text to appear is form field = X. I can get the text to display on form with HTML block. But using Rule Conditions I cant choose to hide the HTML block, only actual fields. Way to apply rule/condition to an HTML block?
  2. YES! I knew there was some simple method I used i the past, just couldnt recall it. Thanks Vitalik.
  3. Hiding Multiple Login Forms: http://howto.caspio.com/tech-tips-and-articles/common-customizations/hiding-multiple-login-forms/?_ga=2.107921729.2102379586.1507150279-2116692682.1507150279 Guide says to this in the HEADER of the Authentication: <div name="cb-auth-box"> And this in the Footer: </div> The problem is that in SOURCE view to enter <div name="cb-auth-box"> the second you switch out of SOURCE view or SAVE it adds the closing </div>. So when you got bak it shows <div name="cb-auth-box"></div> For the Footer </div> it simply removes it altogether, presumably adding it to the footer to close that <div> tag.
  4. Or maybe I could alter the approach/question. If you had only one group of users that self register, then login to enter weekly form data that appends to thier account as a new row of form data, and users could only see their data, how best to set it up?
  5. I have a basic app with only one group of authenticated users (no roles) achieved thru registration. User registers, logs in, then can enter some data using a basic form. OVer time they will add more records via the form and only see their records.Only two tables: Registered users and a Form Data. One authentication. No authentication table.Im trying to combine two datapages emdeded on one webpage - one form and one report so that on one page the user could see the summary report of their current data and also submit another entry. See below:Works well, but because they are both set for record level access when I choose LOGOUT both sections show a login box. Would like logoff to go to one page to log back in. tried to create a static Login Page with redirect but it wouldnt work. I tried a View but couldn't get it to work. Followed many of the how to's but since this one is simple (no roles) none of the examples quite apply. All input welcome.
  6. Hoping you can point me in right direction. Im struggling on something simple. Need users to register. Once registered they make an ENTRY to their profile/account: CMEType: multiple choice | CMEHours: number | Upload: upload file | SUBMIT They can enter as many submissions as they wish which will build in a table. Im having trouble getting a logged in user to see only their entries once logged in and for the main table to distinguish between users. Table1: RecordID: autonumber/unique Name Email: username Password: Password \Registration works fine but having trouble tying a new submission to thier account.
  7. Hopefully I can explain this. Three Fields: A= Yes/No B= Dropdown choice with an "other" option C = Other field if OTHER chosen in dropdown B. If A = No, hide B and C Having trouble getting B and C to appear/hide based on values because I think you can only use a rule on one field at a time. Example: A = Male? (Y/N) , if Yes show B, keep C hidden still. B = Dropdown with "other" option. If other chosen, then show C, the other text field. But the rule stating to hide B and C does not allow me to apply another Rule for C. I can get B and C hidden or shown at same time only. Hope that makes sense. Way around this?
  8. roattw

    Reports Dashboard

    I might be over thinking this, as usual. I would like to create a dashboard page where the user can click a button and run a static commonly requested report, This page would contain 10 or so of the most commonly requested on reports. People would just visit the page, click a report icon, be shown the results, and be done - without having to search, sort, or use other results page functions. Is this a built in option, or is really just a graphic button hyperlinked to a webpage that contains the embedded Caspio report datapage code? Is there a better cooler way? ;^)
  9. Thats beautifully simple! I need it to the minute so one big table, but nice elegant solution.
  10. Mylene. This is working with one exception. Works great but wont work on two other text fields setup the same way. The only thing different is that the two fields where it doesn't work are fields that Show/Hide based on a Rule. Wondering if that Rule status is preventing the field name to be recognized by the script?<script>function isNumberKey(evt){var charCode = (evt.which) ? evt.which : event.keyCodeif (charCode > 31 && (charCode < 48 || charCode > 57))return false;return true;}document.getElementById('InsertDTN_time').onkeypress =isNumberKey;</script>
  11. I have a script to limit field characters to numbers only. Works great on computer/html but not on Smartphones. <script> function isNumberKey(evt){ var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 || charCode > 57)) return false; return true; } document.getElementById('InsertRecordTIME2').onkeypress =isNumberKey; </script> Do smart phones use an entirely different set of event handlers or script? Is it the .onkeypress or something more intense?
  12. I have a script forcing numeric characters only in a couple fields (thanks May Music). <script> function isNumberKey(evt){ var charCode = (evt.which) ? evt.which : event.keyCode if (charCode > 31 && (charCode < 48 || charCode > 57)) return false; return true; } document.getElementById('InsertRecordFIELD1').onkeypress =isNumberKey; </script> I had several fields like this so I cheated and created one script for each FIELDNAME (I know, I know, Im still learning :^). How could I combine all fields into that one script above? I tried this but it didnt work: document.getElementById('InsertRecordFIELD1','InsertRecordFIELD2','InsertRecordFIELD3')
  13. Thanks Mylene. I was able to get this to work. But I think the onkeypress handler only works on web. Does not restrict letters on smartphones,. Any idea how to apply to mobile?
  14. Thanks for the reply Mathilda My issue is I don't need a time stamp or current time. I need to have the user pick a time of day that something occurred, could have been earlier than when they are actuallyt on the form and what the timestamp would record. Like the calendar date picker but time instead.
  15. Trying to get a number field (Age) to only allow numeric entries. Possible? In a basic HTML5 form it would just be <input type="number">. Am I missing something? In a perfect world, a pop up message when alpha characters entered would also e nice.
  16. Have some script I want to test in an HTML element - trying to get just a TIME OF DAT picker. But all the code I have found exceeds the 10,000 character limit in Caspio. Workaround - reference external file/js?
  17. The problem is that I need it to concatenate on the form when being completed, not on form sumbit. Really just need a time of day picker like tou have for Calendar.
  18. I would like to be able to have the user select TIME OF DAY something occurred (H:M AM/PM) and have those selections populate a Time of Day field. Exactly like the calendar popup, but just time, date not needed really. Or concatenate Selection box 1 = Select Hour (1-12) Selection box 2 = select minutes (probably 5, 10, 5, ...00) Selection box 3 = Am or PM Result of the three choices populates the Time of Day box: ie 2:25 PM Surprised its just not an option in calendar....
  19. 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 it 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? Can I use HTML5 to make it easy? <input type="number" name="quantity" min="1" max="5">
  20. 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; return true;}document.getElementById('@field:Age').onkeypress =isNumberKey;</script>
  21. I have a good app going with one main data table with lots of views and dependencies tied to it. I want to change some field types in the table - from Text to Integer, etc. But all the warning scare me about lost data if I proceed and "incompatible data will be lost." To preserve all the dependencies will this work? COPY that original table and data (call it Table 1) to "Table 1 Backup". Copy Table 1 again and all it Table New Change field types in Table New, save it. Delete original Table 1 and RENAME Table NEW to Table 1 (the original one referenced in all the views and data pages). Will that start me over with a new table with no data and preserve all the dependent reference to "Table 1" in the app?
  22. Have a table of data. Need a report or view showing IF field 1 = X, AND field 2 = A or B or C show those entries. So below, if the field Evals = YES AND field Hospital = A, B, C, D, E, E or F - show them to me. But cant get it to show data: Tried it multiple ways, nothing. ;^)
  23. Thanks for the reply! This might be a good start. But in this example, the characters to count are hard coded into the page (HelloWorld). I would need to have it count all characters entered into form fields. So var str = "Hello World!"; would have to somehow be var str = "ANY entry or selection into any field gets counted "; A Yes/No or other radial button selection also gets a registered value and gets sent to the pager and email, and would have to be counted as well. And I cant figure that out. ;^) How much to consultants charge per hour?
  24. Thanks MayMusic. I presume on re import the existing captured data would follow the rearranged rows?
×
×
  • Create New...