Jump to content


Caspio Guru
  • Content Count

  • Joined

  • Last visited

  • Days Won


aam82 last won the day on July 16 2017

aam82 had the most liked content!

About aam82

  • Rank
    Advanced Member

Recent Profile Visitors

1,640 profile views
  1. You can hide columns in tabular reports via css. The cascading should still work. #tabular table:nth-of-type(1) td:nth-of-type(4) {display: none;} #tabular table:nth-of-type(1) th:nth-of-type(4) {display: none;} 4 indicates the column number.
  2. If you code your scholarships datasource with a citizenship field scholarships name, type, citizenship and your Users table with a citizenship field users name, email, citizenship Then you can make a Scholarships Report, with Record Level Security, based on: Identitiy field in Authentication: Users_Citizenship Matching field in current data source: Scholarships_Citizenship
  3. Bumping this. I can't find any documentation regarding search/replace syntax in Table view.
  4. link: http://stackoverflow.com/questions/5913/getting-the-text-from-a-drop-down-box instead of setting your variable to a value, try to set it to the text of the selected <option> property for that field.
  5. Where on your datapage are you calling your custom.js? Your script requires jQuery as well... Can you use inline javascript instead of an external file? The Caspio article on this is good:
  6. Hi! Have a question? Feel free to send me a direct message.

  7. How many timezones are you dealing with? Does it have to be a secure limit, that can't be subverted, or can it be a hack?
  8. There are some buggy ways to prepopulate the user's email program with a list of emails. One bug that I don't like is the opening of a new tab as a side-effect. Another is call to location.href with a mailto: link getting served over http, causing a mixed contect warning. There is also the window prompt you linked to, which has a 2,000 character limit. Since you have fewer than 999 addresses in the data set you want to use, you won't run into the 999 record per page Caspio limit, so I suggest the following, adapted from the second response to the same SO thread you linked: In your da
  9. srufini, take a look at the javascript forum section for tips. 2)no, this would require use of the API and custom programming. I don't know another way.
  10. 1) If you have a report of all users, you can check boxes of each user to email. You can use a script to preselect users based on criteria, but you will have to send emails in 999 user chunks (Caspio record limit per page). This script looks for a field >=1 and if so, marks it for bulk editing (for emailing). It works because it is the only field with the matching selector(.cbResultSet...) on the page. I use it to send emails to about 100 every other week. <script type="text/javascript"> var delay=1000; setTimeout(function() { var elems = document.querySelectorAll(".cbResultS
  11. Spend a few days away from the forum and all hell breaks loose! Well, the new plan works better for us and them. We upgraded, but we're getting more, and not pinching pennies with deployment hacks that were making for an uneven UX. Looks good to me.
  12. I was able to reduce data usage by dp.asp by 2KB by copying Caspian, zeroing it out, and loading it locally instead. It can't truly be zeroed out, even in souce mode, but you can remove all parameters from each selector so that you have just table{} etc. in your Caspio CSS. Not a big improvement. However.. I just ran a test, and found that my JS embed datapage draws 711KB for just 81 records, and the same datapage in IFRAME or URL deployment draws 125KB! (The report has a couple of unoptmized SQL queries. There might be more savings here. I think Caspio does its own optimization behind
  13. Just chiming in that I've had extensive discussion with support and my findings were the same.
  14. Nevermind, this is better accomplished using the dynamic TO: setting on Automatic Emails-Insert and Update configuration page. That wasn't available when this workaround was developed.
  • Create New...