Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything 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. I need to count how many times each of 22 categories occurs in a table column. Colum= Major_category I can get the count non blanks as below but I need the resultant counts sorted by magnitude, not by the category sorted alphabetically. Thanks!
  3. 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.
  4. Have a signture field. In the table it only shows coordinates [{"lx":133,"ly":37,"mx":133,"my":36},{"lx":132,"ly":36,"mx":133,"my":37}, It shows the signature image in reports views. Can we not get that image of the signature to download as well into exported results? I have a couple less robust Form services that do that. Am I missing a setting?
  5. I cant find via Inspect how to increase the spacing between the listed option under a dropdown box filed. Thanks!
  6. Thanks Barbie. This might be a good solution. Does this approach mean you would delete the existing rule that hides a given field - and just allow the JS to hide them not rules.
  7. TY! Will see what I can find in those settings, and try the cache.
  8. I have several fields with a Yes No radio button and NO is set as default answer. Using rules I have some fields conditionally hidden. If these fields are set to not show by a rule and the form is submitted the table doesnt receive the default No option, comes over as blank. Way to send all field results and thier defaults even if not shown by a rule?
  9. I get this warning message when I try to add a second triggered action: I had this triggered action: I tried to add this second one but got that error. All have to be combined in one giant triggered action?
  10. 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?
  11. I have a list box with 5 options. Set the Rows to show and it shows them all fine UNTIL I changed the size of the checkbox (transform: 1.4). With checkbox input a little larger the listbox no longer contains all its entries, cuts the last one off. Thoughts? As always, thank you!
  12. I was not able to figure it out.
  13. 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
  14. That makes sense. They should update with that point. Will play around with it.... while listening to Peaches En Regalia
  15. Thanks for reply Hastur. Yes, field placed that way using Continuous next line option.
  16. 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.
  17. 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
  18. 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!
  19. 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.
  20. 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.
  21. 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!
  22. 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...