Jump to content

roattw

Caspio Guru
  • Posts

    204
  • Joined

  • Last visited

  • Days Won

    3

Posts posted by roattw

  1. 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:

    with_custom.png.9753b8358910de9f04d761792e64d80d.png

    Field not allowing Cal Field+ and with no custom:

    without_custom.png.921cb07ccb6fa8d6e3a69630bbfe8c79.png

  2. 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:

    tally2.jpg.a42f08d2b24315f9b2662c3337d63176.jpg

     

    But all I can get is this:

    tally1.jpg.4a8f341be336a5bcdafdea43b52c3d62.jpg

     

    Thanks everyone

  3. 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"

     

    2020-01-25_14-08-03.thumb.jpg.7a2fa3815e8aabd7cd1b2f96b20dcd43.jpg

     

    As always, all input VERY appreciated.

  4. 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"

  5. 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.

     

    safari2.png

  6. 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.

    2019-12-29_17-21-43.png.ad9e497bedd6d78342c51d05d840b6ce.png

  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?

  8. 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!

  9. On 11/26/2018 at 9:30 PM, Meekeee said:

    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.

  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.

    tbl1.thumb.jpg.6ba0821e918a7dc3ccaea48e11b7d28b.jpg

     

    tbl2.jpg.b59997b391ceaaf2a1a78a212cf1f2cb.jpg

×
×
  • Create New...