Jump to content

roattw

Caspio Guru
  • Content Count

    178
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by roattw

  1. As an example if you had a field to invite guests to an event, and the field was a Name, Im looking to add a + or Add Another button to add up to 4 guest names below first if needed. Thanks as always.
  2. Wow, I always forget the obvious. I didnt scroll down farther when I clicked the "+" sign to see Totals and Aggregates Thanks - again!
  3. I have a pivot table using just basic totals - calculated values in the Sum area (thanks LittleMiss Ginger !) Interestingly, I went o add one more and the option to add another calculated value is grayed out and wont open. Does Caspio know I dont have another "countable" field to even apply a calc field to? I added a random field like "email" and no calculated field option, and there was no Custom option under "Summarize values as" like there was in the other fields. Fields allowing Calc Field+ and Custom option: Field not allowing Cal Field+ and with no custom:
  4. OMG! Thank you LittleMissGinger! In all the videos I watched they never noted that you dont have to assign a Column and Row value. Ugh. Working as expected now. Its always the little misses for me ;^)
  5. Im looking to generate a simple TOTAL count of attendees for 5 events. Deceptively hard in Caspio reports. I dont need all the data that comprises those totals. We are just counting Yes/No entries for people attending various events. But, 1) data report wont show aggregates/totals without the data that makes up those totals, and 2) pivot tables wont do a single row I need this: But all I can get is this: Thanks everyone
  6. I have a DP Report that tally's some basic Yes No responses . One is a Yes/No data type field in table (ED_Tour). - are you coming to this Tour. The Other is a Text field set as radio button with Yes No options custom defined (Significant_Other?) - Bringing a significant other? Both Total/Aggregate fields in the report "VERIFY" fine. But only one will actually display the result on the DP - Yes/No checkbox (ED-Tour). The text field type Yes No (Significant_Other?) wont show result. ATTENDING Yes/No type field: SELECT COUNT [@field:ED_Tour] FROM tablename WHERE [@field:ED_Tour] = 1 Significant_Other text field (radio button assigned values): SELECT COUNT [@field:Significnat_Other] FROM tablename WHERE [@field:Significnat_Other] = "Yes" As always, all input VERY appreciated.
  7. Its been asked before but no complete resolutions for that eask it seems. The offered solution was Select COUNT (Yes/Nofield) from tablename WHERE YesNo=1 I have a very basic Yes/No field for attending an event. (Attending) The formula I am using passes the Verify test. But when I preview it it says "This DataPage uses parameters. To simulate this DataPage with parameters, enter values below." Entering a value or leaving empty it concludes with "Error in Formula" Using this formula: SELECT Count([@Attending]) FROM tbl_mytablename WHERE [@field:Attending]="1"
  8. Thx kpcollier. My brain always goes direction that I screwed up some code somehow. Will start referencing that Known Issues more. I do think internally they would have a hot topic/issue awareness about that
  9. Needs to be emailed out as an important FYI. People can waste hours/days trying to figure it out when there is an easy platform specific solution. Had NailDylan not responded to my post I would have spent days trying to figure it out. I was already a few hours in ;^) Maybe there is an important announcement area I just dont know about? Just my $0.02
  10. FYI - Its not only on SOME forms, I think its all. All my forms are showing that in Safari 13.
  11. OMG. Thank you NailDyanC! That was it. Applied that localization fix and resolved. I was about to start a lot of cross browser code testing. You just saved me a Saturday afternoon! Caspio, you need to email this to customers and/or get this issue and fix front and center somewhere.
  12. I have a couple forms that used to work fine but the most recent version of Safari has been reporting on load "This version of Safari is not fully supported. Please use a different browser (ie, Chrome , Firefox, Edge, etc)." I do have some custom CSS for the form with some pretty basic webkit coding, not sure what it could be. Same form, unchanged, did not report this error on load a couple months ago.
  13. Ok, that makes sense. Thank you. Not sure they covered that subtle point well in the video.
  14. Thanks kristina. Working now. I was also passing that email field incorrectly.
  15. 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.
  16. 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
  17. 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.
  18. 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.
  19. 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.
  20. 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?
  21. 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!
  22. 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.
  23. 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?
  24. 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.
  25. 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...
×
×
  • Create New...