Jump to content

roattw

Caspio Guru
  • Content Count

    189
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by roattw

  1. As always, many thanks for the input!!! Im not sure you regular responders to questions ralize how important your help is! On first run it had a syntax issue with the > sign.
  2. Not quite sure I understand the difference between choosing a specific table value (from the Select From) versus the #inserted? I see #inserted in many examples but not sure what it does or how its different. Thx
  3. I have a form that has an option for Pending Info (checkbox) that users can select if they dont have enough info at the time the form was completed. This form is stamped with user level auth so the record is associated with that user, so later they can login and just see thier entries. I would like a triggered action to EMAIL the user who submitted the form if they used the Pending Info checkbox. To serve as an email reminder to do back and update the record. Their email address is part of their user account info table. Username and password is used for login, but email is also collected. I put a virtual hidden field on the form to receive on entry the auth table field email (Virtual1) and also pass that on exit. I think I have the email set for Pending info checkbox but Im not sure how to have it sent to specific user who submitted the form.
  4. Thanks Andrew, will give it a try and report back. I would also like the script to occur on exit of the fields, not on Submit.
  5. Roosta, thank you very much. This is a great and informative response. Will see where mine differs from how you have it. This will be helpful to many.
  6. I have a field that contains a 24 hour clock time as 4 digits. It is a start time. They are number fields (but could be text). Entered simply as #### (ie 1300) I would like to populate another hidden field with this number converted to a time value of 13:00. Ive tried CAST and CONVERT. I can do it in Excel with several different formulas but I cant find a Capsio equivalent that doesnt error. =TEXT(field]cell,"0\:00") Try_Convert(time(0),LEFT([@field:DTN_Start_value],2) +':'+ RIGHT([@field:DTN_Start_value],2)) Any thoughts?
  7. I have a field that contains a 24 hour clock time as 4 digits. It is a start time. They are number fields (but could be text). Entered simply as #### (ie 1300) I would like to populate another hidden field with this number converted to a time value of 13:00. Ive tried CAST and CONVERT. I can do it in Excel with several different formulas but I cant find a Capsio equivalent that doesnt error. =TEXT(field]cell,"0\:00") Try_Convert(time(0),LEFT([@field:DTN_Start_value],2) +':'+ RIGHT([@field:DTN_Start_value],2)) Any thoughts? Thanks!
  8. They need an option to remove DATE from the drop down / calendar option . SO many steps just to get a simple field to enter time of day.
  9. Very helpful. May, What does your data entry page look like? How can you set a time field (Date/time) where people only enter the time (ie the time they started or ended)? Without getting a dateor using a calendar popup?
  10. I really need to use an HTML table to apply some column structure to a Submission Form. Need explanatory headings to align over their respective fields. Using HTML section in the data page I can begin to build this structure but for every <td> cell I put in an HTML block Caspio adds another <td> (cbHTMLBlockContainer) just for the html block thereby misaligning everything. I really need the data field to align under the explanatory top row headings above it.
  11. Having trouble finding an easy way to have people select a start time and end time so the difference can later be calculated. This would be on same date. I can insert two date field using date and time but the user has to enter the date calendar pop up twice and then change the two times. Seems clunky. Im usually missing something easy...
  12. I need START Time and an END Time on a form. I was using the Separate Input Fields for Date/Time Parts steps. Works well but only once. But I need to do it twice. I need to use it once for a Start Time field and an End Time field. When I enter the script twice in footer (once for a start time section, once for an end time section) it doesnt work anymore. Also tried combining them but no luck. <script> document.getElementsByName('Submit')[0].onmouseover = function(){ <script> var date = document.getElementById('cbParamVirtual1').value; if(date == "") { date = "1/1/2011"; } var hour = document.getElementById('cbParamVirtual2').value; if(hour =="") { hour="00"; } var minute = document.getElementById('cbParamVirtual3').value; if(minute == "") { minute = "00"; } document.getElementById('InsertRecordTIME1').value = date + " " + hour + ":" + minute; }; </script> <script> document.getElementsByName('Submit')[0].onmouseover = function(){ var date2 = document.getElementById('cbParamVirtual4').value; if(date == "") { date = "1/1/2011"; } var hour2 = document.getElementById('cbParamVirtual5').value; if(hour =="") { hour="00"; } var minute2 = document.getElementById('cbParamVirtual6').value; if(minute == "") { minute = "00"; } document.getElementById('InsertRecordTIME2').value = date + " " + hour + ":" + minute; }; </script> Any way to run this twice. Or a better way to get a Start Time and End Time fields using time values so they can be subtracted as time between intervals later?
  13. Still not quite there. When report page first loads no scrollbar. If I choose Grid Edit, no scrollbar. But once I exit out of Grid Edit THEN the scroll bar appears. Additionally, the top one doesnt scroll all the way to the right like the bottom one does, it stops before the end.
  14. Not working for me but I think its because I have other <div> elements in header and other closing </div> elements in footer and its confused on the order the div tags are appearing and closing.
  15. Andrew. See the image below. Each file uploaded by user on form and available in report can be selected using a checkbox, and those selected can be downloaded (as opposed to one at a time).
  16. Thanks for the reply, esp. without much info. A more detailed description of what I meant: Over a period of time user makes form entries where a specific category of three choices is made for each entry. Im hoping to get the subtotal of each drop down selection made and the total overall over a time period. Its the subtotals Im stuck on. For example, over 6 month period of entries: Type of training session done form: 2 Fields: Date, Dropbox with 4 choices Drop box choices are: EMS, Cardiology, Trauma, Stroke Over 6 months Bob makes entry for 12 sessions: 3 EMS, 4 Cardiology, 2 Trauma, 3 Stroke Would like report to show for each user: Bob Smith EMS Date EMS Date EMS Date Total EMS 3 Cardiology Date Cardiology Date Cardiology Date Cardiology Date Total Cardiology 4 Trauma Date Trauma Date Total Trauma 2 Stroke Date Stroke Date Stroke Date Total Stroke 3 Total session: 12
  17. Thanks for the reply Andrew. That looks nice. Im envisioning more of a list of files (like Caspio would typically show in a report) with check boxes next to each. Your example didnt really show check boxes but instead put all uploaded into a zipped file for download. My files would already be uploaded and displayed in a list, if that makes sense.
  18. Thanks for the reply, as alwyas, thats what we ended up doing to prospectively fix the issue. Just have more than 1000 documents not obviously named. Capsio was also allowing unsupported characters like the "|" character which was locking up FilStor as well.
  19. People upload a document when they complete one of our forms. In the data page tabular report we generate one of the columns is the hyperlink path to that document. We can download/open the PDF by clicking on the hyperlink. Problem is the report can have many and clicking each individually is not ideal. Is there a way to add a select box next to each document we want to download and be able to select all or multiselect several then download all at once?
  20. So I have a form where users login and upload files. They had been asked to name their files using a specific format like Last_Name_filename.pdf Looking at a lot of the files many have no Last_Name indication. They are just filenames with no association to the person who uploaded it. In a report I can show each persons collection of files but they show as individual as "downloads" that have to be clicked one at a time to get them, where I could then rename them. I would like to be able to sort and easily identify in Files/FileStor which person the file was uploaded by and associated with. In the Files folder they are just all lumped in there. If I could after the fact append the files with the Last_Name field, that would be awesome. Is it possible to programmatic append and rename uploaded files after already uploaded? Thanks!
  21. I have a data page form that concludes with an automatic email send to a group and shows all the forms entries. Often there are fields that are blank, not all fields are required. But there are a lot of fields. And these results go to a pager which has a line and character limit. So with a lot of blanks th Is there anyway to have the email reporting the fields to ignore BLANK entries? The auto email looks like this, basically includes results of all the form fields.
  22. A while back I had a simple request to COUNT and total the number of times a checkbox item was selected. For example, for every encounter our people make a visit entry with the question: Visit type: A. Phone B. In person C. Remote So each employee over 100 entries would have say 30 Phone, 60 in person, 10 remote. Counting and totaling the number of text answer selections seems unusally cumbersome (at least compared to other apps like Knack). But its even hard to count them across and for all employees. For example total number of Phone visits all employees. I can never get it to work in the formula, using regular expressions or SQL. In Knack its a simple option, here its so programmatic and feel like there has to be an easier way. Im kinda new though.
  23. Odd, I have that Custom setting set for 2 decimal places. No effect. Its also set for 2 in the localization. But no decimal, and the calculation whould have many digits to the right of decimal. The Caspio (SQL?) calculation and rounding error seems odd. I run the same formula/calculations in Excell I get one answer. I run it in another web-based Excel to App converter, same results as Excel. Run it in Casio and the rounding error is much more pronounced. Calculated values off by several counts (for example 2886 in Excel, 2880 in Caspio).
  24. I did have a missing bracket - darn. Better. But the Localization setting of 2 decimals does not seem to have an effect.
×
×
  • Create New...