Jump to content

roattw

Caspio Guru
  • Posts

    203
  • Joined

  • Last visited

  • Days Won

    3

Posts posted by roattw

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

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

  3. 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]">
    
    <script>
    var isi = document.getElementById("visi[@field:Deadline]");
    if DATEDIFF(day, [@field:Sub_date], [@field:Deadline]) <= 29 {
    isi.parentNode.parentNode.style.backgroundColor = '#FFFFFF';
    }
    else{
    isi.parentNode.parentNode.style.backgroundColor = '#66699';
    }
    </script>
    
    </div>

    and

     

    CASE
    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>'
    END
  4. 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:

    1042698025_noresp.png.fa256003bdf90b383f0e7d9c9fe77ac6.png

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

    1906568085_respissue.png.41a2e919996ff130bc390e6ae7afc2d4.png

     

    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.

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

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