Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


bmarineau last won the day on October 2 2014

bmarineau had the most liked content!

About bmarineau

  • Rank

Recent Profile Visitors

311 profile views
  1. I have a table that keeps track of the work schedule for our clients. The record contains the date that the assignment was opened, the ID assigned to the assignment, the name of the company, and product purchased. I have a report that sorts all open assignments by a concatenated field of all the above fields. The result of the HTML code looks like: 02/19/2016 - 32984 - Company Name (Product) This portion works perfectly. I have another DataPage that allows for the work schedule record to be modified. Some times the assignment is put on hold, some times the start date needs
  2. On my DataPages that have search criteria and a view details function, the field width always displays at the default of 25 instead of any entry I put into the Field Width setting. I have it using Characters as opposed to pixels or percent. If I Preview the DataPage everything appears fine. However, when I go to the DataPage from our website, it doesn't work. This error only happens if I embed code. If I use the URL, it works as it is designed. While I can alter many of my DataPages to use the URL as opposed to Embeded code, it seems as if there may be something of a quirk here. I
  3. Hi Jan, Thanks so much. I've been looking / tweeking this on and off for a few days. Can't believe I missed something so simple. Another set of knowledgeable eyes are a wonderful thing. Bill
  4. Hi, I have an update form that contains 2 hidden fields. Depending on the changes made in the form, the value of the hidden fields needs to change. One of the fields is a dropdown what controls placement on a report. I have added the following javascript to the footer. Any changes I make to the data are saved in the table, however, the hidden fields never change. Hopefully someone can spot the error in my code. Thanks, Bill <SCRIPT LANGUAGE="JavaScript"> function concatenate1() { var Sched.Status = document.getElementById("EditRecordStatus").value; var Control = docum
  5. Hi Jan, Yes, the fields are Text64000. For the most part they do seem to "remember" things. It seems to eliminate blank lines on occasion, which may be related to the pasting issue. If I type an apostrophe it will remain. However if I paste text containing an apostrophe (or certain other punctuation marks) it's converted into the iterations I explained above. Thanks.
  6. Hi Jan, We use English (US-English to be specific). Unfortunately, the only way that it appears I can use HTML formatting is to set the field as display only. It is currently a Text Area. The problem is it needs to be a field they can edit.
  7. We have run across a problem when pasting text into a text box on an entry or edit datapage. If you paste text that has an apostrophe (or bullet points as well) Caspio turns the punctuation mark into a black diamond with a question mark in the middle. The next time you pull up the record, all the black diamonds will be replaced with the text string "�". If you enter an apostrophe from the keyboard directly into the text box, it stays as it should. I mostly see this behavior when pasting from MS Word. Although it happens when pasting from a website at times. I guess I have 2 questio
  8. I could not get the statement to work, until I played around with the parent dropdown. I had both a static value "Select" with an empty value and the table of values. I changed the empty value to "0" and it started working. On another note, I had posted the question twice since I didn't see it appear on the forum for a few days so assumed I did something wrong when I posted. The second post was answered as well with a different solution that works as well. Thank you for the reply!
  9. Jan, thank you so much! Your answer worked perfectly. I've been stumped by this one for a while now.
  10. I am having trouble with a submission form getting a total amount. I can get the javascript to work if I enter values in standard fields. It works fine if I use custom values in a dropdown. Where the code does not work is when I use a cascading dropdown. The form is an internal billing request form. There is a price field which is based on the product selected in a previous form. When the select the product, the price goes into the cascading dropdown and fills in the form properly. After price is a field for additional charges and following that a field for discount. I have the fo
  11. I have a Submission form that has a Dropdown for "Product" and the next field uses a Cascading Dropdown for "Price". The following fields are "Additional Charges" and "Discounts". I want the next field to Total the previous three. I have placed the following code in the Footer of the Submission form: <SCRIPT LANGUAGE="JavaScript"> function summation() { var Cost = document.getElementById("InsertRecordPrice").value; var Additional_Charge = document.getElementById("InsertRecordAdditional").value; var Disc = document.getElementById("InsertRecordDiscount").value; var Total
  • Create New...