Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


JayDub last won the day on April 27

JayDub had the most liked content!

1 Follower

Recent Profile Visitors

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

  1. Hi All - this may have been asked and answered elsewhere but I could not find it, so any input is appreciated. I have an existing table in Microsoft Access that has a Primary Key that is set to "Autonumber" for the datatype. I want to import this field into a new Caspio table and set the field Datatype in Caspio to also be Autonumber. In essence, I want it to keep generating a new primary key value picking up where the old Autonumber left off for newly added records. I have not found a way to do this. If you set the field datatype to Autonumber during the import, it will discard all of the existing values. If you try to change the field datatype to Autonumber once the table is imported, it will tell you, again, that it is going to discard the existing values. I have hundreds of records, and the existing primary key values have to be maintained in order to relate the table to other tables. Is there a workaround for this? Thanks in advance.
  2. Hi @Sprocket - sorry for the late reply. I got mine mostly looking like I wanted it, but it took setting up an expert session with Caspio support to figure it out. I still have some issues with the height of the payment processor fields, but nothing terrible. I would suggest submitting a ticket if you haven't already to get help.
  3. In all of the examples of calendar datapages that I have seen (like this one: https://apps.caspio.com/demo18/ec/calendar_view.html) the events all only occur on one day. I am trying to create a calendar to show classes that span multiple days. So, for instance, a class start date may be Monday, but it may be a three day class and therefore will be occurring Monday, Tuesday and Wednesday. I have the start date and the end date of the class in the view my calendar is based on, but I don't see any way to achieve this, since the datapage wizard only allows you to select one field to indicate what date the record should display on the calendar. I want something that looks more like the attachment. Any help or suggestions are appreciated!
  4. @NailDyanC you were correct. The issue was that I was filtering the "child" datapage by receiving a parameter when I walked through the datapage creation wizard, so it worked fine when it was on a page that was receiving the parameter, but I didn't explicitly pass the parameter value in the URL that was used in the iframe on the "parent" datapage, so it would come up empty in the PDF.
  5. 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
  6. 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!
  7. 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?
  8. Thanks @kpcollier and @sandy159 - the difference in days option worked. Appreciate your help.
  9. 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!
  10. 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 the task, the email sends. But with the logic to test for four days out, the task runs but no emails are sent. Any thoughts are appreciated.
  11. 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.
  12. 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.
  13. 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 delete the parameter value from the database once they successfully submit payment information.) My first thought was to just use a Rule on the datapages in the cart process that would hide each datapage if the parameter value was blank. But that doesn't work because each of the datapages has required fields, which means they can not be hidden with a DataPage rule. Is there anyway to redirect a user elsewhere (like my home page) if they go to one of the checkout pages and no parameter value is passed in? (This might also happen if someone bookmarks one of the pages in the cart process and tries to go back to it later.) Any suggestions are welcome!
  14. 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 tried using the Character Length Min setting on the phone number in the DataPage and set it to 10, however, that still allows a phone number like this: 123-456-78 to be submitted, because it counts the hyphens as characters. Is there a way to modify the mask so that it also will not allow submission of a phone number that is not 10 (numeric) characters long?
  15. 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, and I have to change the rest of my form to match them instead (which still doesn't work because, as mentioned previously - they always appear 10px taller.) But, in addition, you are clearly able to do what I am trying to do - and I can't. So why are they telling me it's not possible - when you clearly can do it? Their explanation that it is a security issue doesn't make sense to me - why would changing a field height be a security issue? So, I'm trying to figure out what the real issue is so I can figure out a workaround as this issue is keeping our site from going live. Question for you: the screenshot you included of your result - is that just the Caspio Datapage preview or is that the Datapage displaying on an actual site (my preview in Caspio works fine - it's when I place it on a page that I have the issue.) I am hosting the page in WordPress - could that possibly be creating the issue? Thanks for any help you (or anyone else) can give! This is driving me crazy - I've even had our web developer look at it and they are stumped - and Caspio's explanation doesn't clear anything up!
  • Create New...