Jump to content


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by pse_cs

  1. Hi, I am trying to use this approach but it isn't working. I'm hoping you can spot what is wrong with my code. First, in an html block, I have a show/hide fieldset that is triggered by a checkbox (i.e. check the box if you have a promo code and when the box is checked an input field appears to enter the code). This part works fine: ---------------------- I have a Promo code. Promo code ---------------------- But I need to validate that only acceptable promo codes are entered into the input field. Since we typically only have one or two codes out there, I thought a simple if, else if, else statement would work. As advised in the previous thread, I have placed the javascript in the footer. Here is my validation function: function validator(){ var promoValue = document.getElementById("InsertRecordPromo").value; var capValue = promoValue.toUpperCase(); if (capValue == "ABC"){ return true; } else if (capValue == "DEF"){ return true; } else { alert("Invalid Promo code!"); } } document.getElementById(\"caspioform\").onsubmit= validator;
  2. I have 4 related tables which are fed from several forms. Only the forms feeding into the first table are mandatory for all applicants. For the remaining 3 tables, it depends on the type of applicant as to whether they need to complete the related forms or not. BUT, I need to be able to print one summary report showing all of the data, regardless of whether the applicant has posted data to all 4 tables or just 2 or 3. I created a view of all 4 tables. In the view I indicated the key field that connects each of the 4 tables. However it seems that if that key field isn't present for all 4 tables (i.e. because the applicant didn't need to complete that table's form), then no record is returned. Help! Please tell me there is a way to retrieve all of the data from multiple tables when only some of the tables are required!
  3. Do you have a timeframe when the Microsoft Office plug-in will be out of the beta stage? My company's IT dept will not allow any beta version products to be installed but we would very much like to use this plug-in.
  4. Since the conditional field option only applies to listboxes and dropdowns, I have resorted to Javascript to create a checkbox that when checked reveals additional fields. The javascript and show/hide fields are all contained in an html block. It works great except for some reason when the form entries for the fields in the html block are passed to the table, they have commas appended to them. Any idea how I can make that not happen The other thing I was curious about is why do I seem to have to include the fields contained in the html block again outside of the html block as hidden fields in order for the input to be captured. I'm wondering if this double inclusion of the fields has something to do with the commas.
  5. Caspio’s documentation on this is so vague it is of no help whatsoever. They say “Caspio Bridge DataPages can receive query string values from external sources through either POST or GET methods.†Unfortunately the whole reason I am using Caspio in the first place is that while I know html quite well, I don’t know scripting or form processing at all - so I have no idea how to do this. Can anyone help? Here is what I’m trying to do… We are about to launch a marketing campaign that offers a gift card to those who sign up for our program as a result of the campaign. So we need to track the customers who come directly from the campaign webpage vs all others. To do this I have added a “source†field to my table and set it up to receive a parameter @source. Then in my campaign webpage I appended “?source=campaign†to the URL in the link to the sign up page. I thought this would pass the value “campaign†to the source field for all sign-ups that came directly from that page (presumably all other sign ups would have a blank source field). But the parameter is not being passed. Any ideas? Oh, and to complicate things a little, the sign up form is in an iframe on a page in our MOSS website and I don’t know if the iframe is part of the problem.
  6. Oh well, thanks for confirming my suspicion. Mybe they'll add it in the future
  7. Is it possible to update an entire column of a table? The scenario... We have a field which indicates whether or not a record has been processed. This field is the query term used to filter records for the resulting table so that only unprocessed records are displayed. Our staff person typically processes all the new records in one sitting and would like to be able to click a checkbox at the top of the table column which would change all the no entries to yes rather than having to go into the details page for each record in order to change the entry as this is very time consuming.
  • Create New...