Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


Posts posted by roattw

  1. I used the How To for Creating Collapsible Sections at: https://howto.caspio.com/tech-tips-and-articles/advanced-customizations/tech-tip-creating-collapsible-sections/?_ga=2.93893661.1877276159.1583021206-687599663.1583021206

    Worked pretty well.  When I first set  it up WITHOUT "Enable Responsive" I had this nice preview:


    But when I enable responsive it wraps "Some" fields below their labels even though set correctly as label to left:



    Might an adjustment of that original code for collapsible sections resolve this?  I was always curious why the original code for collapsible sectrions never included a <TR> row code.

  2. I was able to implement the collapsible sections using the Caspio How To.  However, the sections all start in the open state.  I would like them to open in the closed state, or better yest just the first one open.

    Thed instructionsz say "By default, all of the sections we created will be hidden. You can change a section’s default visibility by setting the HTML table’s style attribute to “display:inline;” instead of “display:none;”."  But mine are not opening closed by default.

  3. I have a data entry page with a 20 fairly complex rules creating conditional form logic based on form selections made.

    I have an Update Previous Entry page for submitted records. I want the same conditional field logic rules to function in the update page  the same way it does on original submission.    I had the great idea to just duplicate the data entry DP and use it as the data update page.  It did hold the individual field settings, but it erased all the rules.  Was hoping duplicate meant duplicate everything.

    I dont want to have to recreate the submission form with all its individual field settings and 20 rules  again,  Is there anyway to have the Rules copy over so I dont have to recreate them?

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


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

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



  • Create New...