Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Posts posted by roattw

  1. I might be making this harder than it is (which would be par for the course).  Thanks for any input!

    Simple Table (publications) with the following fields:

    Entry_ID  (autonumber)
    Title     (text field)
    Year     (text -  but also tried as number) entered as 2021, 2020, 2019
    EM_FA (Text - brought in by radio button options YES and NO)
    Resident    (Text - brought in by radio button options YES and NO)



    Im trying to get this result.  Both category calculations grouped by Year.



    But with Pivot Table using calculated field I cant get past this, doing each year one at a time:


    OR this by adding Year as a Row: SAME Calculation applied to each field.




    Or this using Tabular Report. Closer, but have to do each Year one by one.



    All input and condolences welcome ;^)


  2. Ever get an answer to this?  This seems like such a basic feature.  Counting record occurrences should not be this completx - or require coding in a no code platform.   I get asked for a report like this all the time and I have to go back to basic excel to di it!  Looking at Knack because I think it does it by default.

  3. I have a form that requires authentication before access.  Once logged in, I have a couple users reporting that they are being logged out after form submission.  There is not auto logout programmed or page redirection.  The form is set to display a message after form submission.  To complicate things, Im not sure its all users.  Thoughts?

  4. I have looked at the posts on this topic using a Yes/No field.  But would be possible to do it with  DATEDIFF?  

    I have two simple fields.  A submit_date (timestamp)  and a deadline_date (text field as calendar popup).  The app requires a minimum of 30 days to complete a request.  So if someone submits a request (submit_date) and chooses a deadline date (Deadline)  that does not meet then 30 day minimum notice we need that Deadline date text to be read preferrably  (or the field background, or row).  Ive tried versions of this:

    <div =id="visi [@field:Deadline]">
    var isi = document.getElementById("visi[@field:Deadline]");
    if DATEDIFF(day, [@field:Sub_date], [@field:Deadline]) <= 29 {
    isi.parentNode.parentNode.style.backgroundColor = '#FFFFFF';
    isi.parentNode.parentNode.style.backgroundColor = '#66699';



    WHEN ATEDIFF(day, [@field:Sub_date], [@field:Deadline]) <= 29 
    THEN '<span style="color:red;">'[@field:Deadline]'</span>'
    ELSE '<span style="color:#blue;">'[@field:Deadline]'</span>'
  5. 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.

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

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

  • Create New...