Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


roattw last won the day on March 19

roattw had the most liked content!

About roattw

  • Rank
    Advanced Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. I was not able to figure it out.
  2. 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
  3. That makes sense. They should update with that point. Will play around with it.... while listening to Peaches En Regalia
  4. Thanks for reply Hastur. Yes, field placed that way using Continuous next line option.
  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. For a give DP form I usually have three fields next to each other on a line/row. I always have trouble getting just those elements in that row to not go full justified. I usually end up with this: When I would prefer this: Hard to find via Chromes F12 Inspect. a
  7. I have a DP with a search field up top (2 fields) and results displayed underneath, with a Details option that also show the data underneath the search field. Right after I hit Search on the search fields it resets to empty. I would like whatever was entered in the two search fields to remain after hitting Search AND after showing details. Hope that makes sense. TY!
  8. Thanks for the reply kp. That is exactly what I have in place. Well, obviously something is not correct but I cant find it yet. Will dissect further.
  9. 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.
  10. I have a triggered action that sends a reminder email. The how to says I can launch the html option in the message box clicking an icon - but that icon is not showing in y message box. Mine just shows the insert field icon: Mine does now have that option, and Id like the web URL to be a hyperkink. Thanks!
  11. 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?
  12. Thanks kpcollier. Knack had it. I wish I could mas Knack and Capsio together ;^)
  13. 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.
  14. Wow, I always forget the obvious. I didnt scroll down farther when I clicked the "+" sign to see Totals and Aggregates Thanks - again!
  • Create New...