Jump to content


Caspio Guru
  • Posts

  • Joined

  • Last visited

  • Days Won


roattw last won the day on March 19 2020

roattw had the most liked content!

1 Follower

Recent Profile Visitors

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

roattw's Achievements


Newbie (1/14)



  1. 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!
  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. Yeah, but they want another $1200 to add that =^/
  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
  • Create New...