Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


JayDub last won the day on September 23 2020

JayDub had the most liked content!

1 Follower

About JayDub

  • Rank
  1. 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
  2. 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
  3. 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
  4. 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.
  5. 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
  6. 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
  7. 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
  8. 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.
  9. 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
  10. 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!
  11. 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.
  12. 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...