Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


abitaquest last won the day on October 9 2013

abitaquest had the most liked content!

abitaquest's Achievements


Newbie (1/14)



  1. Got that covered, too. Thanks again, @Vitalikssssss
  2. Thanks, @Vitalikssssss. I appreciate the help. I don't think that's my issue here, though. My table is only 304K, and it contains about 800 rows.
  3. Hi. I have scheduled tasks that export a single table each day and upload it to a remote server as a zipped .csv file. It's been running for years without issue. In the past two days, the upload has been happening, but the zipped file won't open. I thought I got around the problem by telling the system not to zip it first. (I can work with the raw .csv.) However, when that happens, I only get a small portion of the .csv records, not the full table. I think the two may be related, and that the exports are stopping before they're complete, resulting in incomplete .csv files as well as .zip files that can't be expanded. Running the scheduled tasks on demand produces the same results. I can get the data I need by going to the table and exporting directly from there. But since I need to automate this so that it runs twice daily, that's only a temporary solution, at best. (Note: This isn't happening with only single table, but with all similar tasks.) Any ideas?
  4. Hi, edujobs2k10 — This is untested, but it should work. I only changed the variable name and set "permitted_date" to be today's date plus 0 days, then changed the text of the error message. The user should now only be allowed to select today or a day in the future, nothing in the past. First, be sure that AJAX isn't allowed to run on your form. Then, paste the following into your form's footer: <SCRIPT LANGUAGE="JavaScript"> function check_date() { var entered_value = document.getElementById("InsertRecorddateNeeded").value; var entered_date = new Date(entered_value); var permitted_date = new Date(); permitted_date.setDate(permitted_date.getDate() + 0); if(entered_date < permitted_date) { alert("Cannot be a date in the past"); return false; } } document.getElementById("caspioform").onsubmit=check_date; </SCRIPT>
  5. You're right, IMDora! I had allowed AJAX to run on that form after the most recent release. Disabling AJAX put it back the way it belonged. Everything works again! I can't believe I didn't think of that myself. Much appreciated!
  6. Years ago I added some JavaScript to my forms to prevent clients from selecting a "due date" that isn't at least two weeks in the future. Recently that code has stopped working, and all submissions are allowed through, regardless of the date selected. I think this may be tied to the recent Caspio updates. At least, that's all that I can see; the forms themselves haven't changed. Below I'm pasting my JS, which resides in the footer area of my forms. Any ideas would be greatly appreciated. Thanks! (BTW, I know two weeks is 14 days, not 13. But my users don't seem to recognize that, so I made this small allowance.) <SCRIPT LANGUAGE="JavaScript"> function check_date() { var entered_value = document.getElementById("InsertRecorddateNeeded").value; var entered_date = new Date(entered_value); var two_week_date = new Date(); two_week_date.setDate(two_week_date.getDate() + 13); if(entered_date < two_week_date) { alert("Must be at least 2 weeks in future"); return false; } } document.getElementById("caspioform").onsubmit=check_date; </SCRIPT>
  7. I've been customizing my default stylesheet for accessibility. I've modified my buttons so that they're very readable on desktops using all browsers I've tried. But when I load my forms from my phone, the buttons take on a weird gradient that gives a rounded appearance to the button. This is not what I want, as it's much less legible. Anyone know how to turn off this default for mobile devices ... or at least where the style is coming from? I don't see it anywhere in my CSS. Thanks!
  8. This is perfect! Thank you, iren! You've saved my team a mountain of headaches.
  9. Hi, all. So, I need to make the calendar date selection tool available to my form's users, but I don't want them to select a date that is less than two weeks in the future. In other words, if today is Sept. 10, the earliest date they should be able to enter/select is Sept. 24. Ideas? Thanks much!
  10. Hi. I need to collect data from several different drop-downs, then combine the results into a single array in my data table. How would I do that? Example: If I collect 5 as the value for dropdown_1, and 3 for the value of dropdown_2, and 4 for the value of dropdown_3, I would need to be able to use that to create an array in another field (dropdown_values) such as: 5, 3, 4 I'm guessing this is a javascript thing. Any idea how to do that? Thanks for any help.
  11. They must have reorganized and revised their site's articles, possibly in response to the new software version. Here's the new link: http://howto.caspio.com/files-and-images/referencing-your-files/
  12. Hi, all -- I need a way to keep the user's optional upload attachments from disappearing after a warning. Example: If a user uploads a file but forgets to complete a required field somewhere in the form, he/she will see a warning on Submit. But when the warning appears, the file disappears, and the user must browse again to upload the file. Most of my users don't even notice that their file is no longer attached. I believe I've seen a javascript workaround for this in the past, but I have no idea where. Can someone help? Thanks in advance.
  13. Thank you, Emma! This is exactly what I needed.
  14. Hi, all. I need to know how to build a link to an uploaded attachment file using parameters. I'll put this link into an HTML block in my Search-and-Report form in order to make the link open in a new window. I can display the NAME of the file this way, but I don't know how to build a link to the file, which (because it has been uploaded) resides in Caspio: <p><b>Uploaded File 3:</b> [@field:Upload_3]</p> Thanks for your help.
  • Create New...