Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by JayDub

  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!
  16. 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.
  17. 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 table, Table D. In a SQL Server Stored Procedure, I believe you could use a statement like: Select @n1 = n1 from inserted a To retrieve the primary key when inserting a new record. I'm thinking if Caspio has something similar, I can use a Loop to insert each new record into Table C one at a time, reading back the Primary Key each time and then inserting a new record into Table D. Alternatively, I believe SQL has a SCOPE IDENTITY function that also retrieves the PK of the newly inserted record. Anything similar in Caspio? BTW - I considered having a second, separate trigger in Table C to insert the record into Table D, but that won't work, because sometimes records will be added manually to Table C and in this case, new records should not be created in Table D.
  18. 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 doesn't work at all, the buttons always show. Thank you for the suggestion to use the Console in the browser. I wasn't familiar with how to use it, but I looked it up and when I did try it, it showed an error that there was a missing ) in my code. I went back to the original example here https://howto.caspio.com/datapages/ajax-loading/ and realized I was missing ); from the very end of my script. So the complete block should have been: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { if (event.detail.appKey == '--i put my form's app key here--') { if (document.getElementById('norecord')){ document.getElementById('HideFooter').style.display = 'none'; } } }); //added right parentheses and semicolon here </script> It works like a charm now!
  19. 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 key here--') { if (document.getElementById('norecord')){ document.getElementById('HideFooter').style.display = 'none'; } } } </script>
  20. 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.
  21. 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 up any value over 50px and actually become taller, but they seem to ignore any value under 50px. And, again, they are completely ignoring the placeholder text color I have set. In the html, I can see that the payment processor fields are actually in an iframe. I don't know if that is causing the issue or not?
  22. 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!
  23. 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.
  • Create New...