Jump to content


Caspio Ninja
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by JayDub

  1. I have a report that I have created using the method in this video, which utilizes an embedded DataPage in an iframe to create almost a master/sub report effect. It works great when I am viewing the report in the browser, but when I turn on the option to enable a PDF download of the report, the PDF that is produced shows "No Records Found" for the subreport portion of the Report. Even though records are being displayed when viewed in the browser. Has anyone run into this issue? pdf view.pdf brower view.pdf
  2. JayDub

    Email PDF

    Thanks @Talbot. I will keep your solution in mind and I appreciate your offer to share the code. We are trying to generate a course completion certificate for students that have attended a course. I think, for now, we may employ a simpler solution to just email them a link to the DataPage report that generates the certificate and allow them to download it as a PDF from there. If that doesn't work, I may be back in touch. Thanks everyone!
  3. JayDub

    Email PDF

    I'd like to generate a report on a scheduled basis and email the result as a PDF attachment to a user. Is this possible within Caspio or would it require an integration with a third party service of some sort?
  4. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
  5. Thanks @kpcollier and @sandy159. I will try the difference in days option and let you know if it works. It's strange to me, though, that the example Caspio uses in their post about tasks, which is illustrating essentially what I'm trying to do, uses the other method, which (unless I'm missing something) does not seem to work!
  6. Hi - I'm trying to send an email once a day to students that have registered in an upcoming class to let them know how to join the class. I created a task to retrieve the correct records and scheduled the task to execute each day at midnight. It should send emails to students in classes that begin in four days. I used this article as an example (Example 2: Event Reminder): https://howto.caspio.com/tasks/ I've attached my logic. The task runs successfully but no email is ever sent. If I change the Where Criteria to have the Course Start Date = the literal date I'm trying to target, and run
  7. Thanks @TellMeWhy. It's odd that it would be allowed with datapages and not tasks. Unfortunately, I have a process that runs once a day to send out emails about upcoming events so I'm not able to use a datapage for sending of the email.
  8. Is it possible to have a different display name shown in the TO field of an email in a Task or Triggered action. For instance, when you set the TO field to info@acme.com the recipient will see "info" as the name of sender of the email. I would instead like the name to be show as Acme Info. In Outlook, this is done by prefacing the email with the user name like: <Acme Info> info@acme.com. But, in looking around, and testing some different syntax, I can't find anything similar for the TO field in Caspio. Any ideas are welcome.
  9. Hi - I've created a shopping cart process using Caspio. By design, this process could not use authentication in Caspio - it had to allow a user to move through the shopping cart without having to login. Instead, I use a parameter value passed from page to page as the user moves through the cart process to uniquely identify them. Everything works fine with one exception: if a user completes a purchase using a credit card and then tries to hit the back button, they wind up at a previous page in the cart process (there are three separate pages in all) but with no parameter value being passed (I d
  10. Hi @sandy159 I finally got iMask to work. Not sure what the issue was. I re-did all of the steps and this time it worked. I do have a different question, though. And I'm wondering if anyone else has noticed this? The iMask solution works to ensure the user is entering numeric characters, and it adds the "-" automatically between the area code, prefix and last four numbers - all good. However, from what I've found in testing it, it does still allow invalid phone numbers to be submitted because there is no check on whether the user has entered enough characters to make the phone number valid. I
  11. Hi @telly. I have been working on other things but just came back to this issue. I added !important to the cbFormTextBox style but it still has no effect on height of the credit card fields. As a matter of fact, no matter what I set as !important for the field height, the credit card fields always display 10px higher than that value (see attached screenshot, where I set them to 50px - and they are displaying as 60px.) I submitted this issue to Caspio support and this was their response: They are basically saying there is no way to change the formatting of the credit card fields, a
  12. Hi @NiceDuck. Thank you for your suggestion. And my apologies if my explanation wasn't clear. I confirmed in a chat with Caspio support that there is not built-in way to retrieve a record's primary key when inserting into a different table while in a trigger. So I used a workaround, somewhat similar to what you suggested, by using a marker on each record that I could identify when I went to do the insert into the next table.
  13. Hi - I'm trying to create a trigger that will do the following: When a new record is inserted into Table A, a trigger will fire off inserting x number of records into Table B from Table C. Table A and Table C can be joined via a common field, so I am able to select the "x" number of records to insert into Table C fairly easily. However, I'm getting stuck on the second part of what I want the trigger to do. When each new record is inserted into Table C, I would like to get the Primary Key field value back from that insert and write it along with the primary key of Table A into another tabl
  14. Hi @Vitalikssssss, I replaced error message 351 in my localization file for the form with: <div id="norecord"><h3>Please add a student to continue.</h3></div> I originally used the code higher in this thread in the window.onload event and it worked to hide the buttons when the form first loaded. But due to the Ajax functionality employed when records are deleted, it did not remove the buttons when all records were deleted. So at the suggestion of @Alison I changed the code to listen for the DataPageReady event of the specific form on my page but now it
  15. I've tried to replace my previous function that was called by window.onload with the code below. I've placed the code in my form header. The HideFooter element that it references (to hide) is in the form footer and is a span that contains two buttons, that I only want to show when there are records in the form. I'm sure I'm doing something wrong as the buttons show no matter whether there are records or not. Any help is appreciated! <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if (event.detail.appKey == '--i put my form's app k
  16. Hi - I tried this method to hide a couple of buttons I had placed in the footer and it worked wonderfully if there were no records initially displayed in the DataForm. However, if a user adds a record (which then displays the footer with the buttons successfully), then deletes that record, the buttons in the footer still remain showing. I'm guessing this is because the page is not doing a full refresh so the onload event of the window is not being called again? Is there a different event that this function could be attached to so that it will fire if a user deletes all records as well? Thanks.
  17. Thanks @telly . I'm able to set a few properties, like the border width of the fields using the method you described, and the payment processor fields seem to pick it up. However, other properties, like the placeholder text color and field height it seems to ignore. The odd thing is, if I use the inspector in Firefox, it looks like it is using correct property value of 40px for the height. But when I hover over the field it is 50px in height, so all of the payment processor fields appear taller than my other fields on the form. The other odd thing is that the payment processor fields will pick
  18. Hi - I've found the basic payment processor styles under Form/Details/Fields/Payment Processors but as far as I can see, you can only make changes to a few things, like the font, etc. How do you control other aspects of the fields holding the payment information, such as the width, border size, etc? I ask because on my form, the payment fields do not take on the style settings that I have created for the other fields on the form. I'm sure there is a way to fix this, but I haven't been able to find it. Thanks!
  19. Hi - I'm trying to use the iMask framework and my DataPage is being hosted inside a WordPress page. The loading of the JavaScript library is failing with this message in the Chrome Console: Uncaught SyntaxError: Cannot use import statement outside a module and it references the appParameter holding the imask.js file. Anyone have thoughts on what may be causing that? Thanks in advance.
  20. I have a DataForm with a calculated field. In the calculated field, I would like to look up and Sum matching records in a View. I know that you can query a Table in a calculated field, and I have done this successfully. However, the value that I need is currently in a View. When I create the query in the calculated field using the name of a View, I get an Invalid Formula error. I am trying to use a View instead of a table because there is not a direct relationship between the current table the DataForm is based on and the Table the value I need to Sum is in. I have to relate both tables via a
  • Create New...