Kristy1

I am finding that most of the datapages I am placing on my website are loading in the middle or bottom of the page when deployed from another datapage via the update model, or when using HTML in message display as destination. I am using iframes. Any suggestions on what I might be doing to create this issue, or any on how to make the page load to the top of the datapage every time? I do have the box checked for "Automatically focus cursor on first field" already.

I have four telephone numbers as phone1, phone2, phone3 and phone4. I want to populate radio buttons for user to indicate which is first and 2nd numbers to call in emergency. I am using an update form in multi-page form. Tried to use [@fieldname], [@field:fieldname] but all I get is exactly what I type, not the data in the field.

I can't get concatenation to work on multiple phone numbers on one form - I can only get one group of 4 groups of concatenated phone numbers to work at a time. When I label "var allpositions" with separate numbers (1, 2, 3, 4) only the last one works. When I remove the numbers from the "var allpositions" so they're all labeled the same, then only the first one works. The inserted punctuation (where I've inserted parentheses and spaces into the resultant phone number) do work on in the concatenated field (PH_1, 2, 3 and 4) but it's not pulling in the data from the fields. function concatenate() { var position1 = document.getElementById("InsertRecordPhone1_ID").value; var position2 = document.getElementById("InsertRecordPhone1_AC").value; var position3 = document.getElementById("InsertRecordPhone1").value; var allpositions1 = position1 + " " + "(" + position2 + ")" + " " + position3; document.getElementById("InsertRecordPH_1").value = allpositions1; } function concatenate() { var position4 = document.getElementById("InsertRecordPhone2_ID").value; var position5 = document.getElementById("InsertRecordPhone2_AC").value; var position6 = document.getElementById("InsertRecordPhone2").value; var position7 = document.getElementById("InsertRecordPh2Ext").value; var allpositions2 = position4 + " " + "(" + position5 + ")" + " " + position6 + " " + position7; document.getElementById("InsertRecordPH_2").value = allpositions2; } function concatenate() { var position8 = document.getElementById("InsertRecordPhone3_ID").value; var position9 = document.getElementById("InsertRecordPhone3_AC").value; var position10 = document.getElementById("InsertRecordPhone3").value; var position11 = document.getElementById("InsertRecordPh3Ext").value; var allpositions3 = position8 + " " + "(" + position9 + ")" + " " + position10 + " " + position11; document.getElementById("InsertRecordPH_3").value = allpositions3; } function concatenate() { var position12 = document.getElementById("InsertRecordPhone4_ID").value; var position13 = document.getElementById("InsertRecordPhone4_AC").value; var position14 = document.getElementById("InsertRecordPhone4").value; var position15 = document.getElementById("InsertRecordPh4Ext").value; var allpositions4 = position12 + " " + "(" + position13 + ")" + " " + position14 + " " + position15; document.getElementById("InsertRecordPH_4").value = allpositions4; } document.getElementById("caspioform").onsubmit=concatenate;

:idea: OMG, I am so very very grateful - thanks ever so much! I also changed the last line: document.getElementById("caspioform").onkeyup = upperCase; and now the letters change to capitals as they are typed.

I have a field I want the user to type in in all capital letters. I managed to put a clearing function where the words "TYPE IN ALL CAPS" appear in the box in faint gray and disappear when the box is clicked on, but I'm finding only about 60% of users are paying attention. I've found javascript coding to use when writing form from scratch, but cannot make them work within Caspio. One cool example has letters convert to capitals as they are typed (LOVE THAT) but I don't know enough to convert it to use with Caspio bridge. Any Ideas?? (From w3schools - site: http://www.w3schools.com/jsref/event_onkeyup.asp) <script type="text/javascript"> function upperCase(x) { var y=document.getElementById(x).value document.getElementById(x).value=y.toUpperCase() } </script> Enter your name: id="fname" onkeyup="upperCase(this.id)">

Looks like you're making the same mistake I did by putting your field name every place it says position1, position2 or allpositions. What I learned is that where they appear after the "var" word they are instructions for the coding and should stay put in those locations. Therefore, the only places where you insert your specific field names is within the parenthesis following the phrase = document.getElementById I assume you are using it on an Update form or Search&Report Data Page since you replaced the InsertRecord with EditRecord. Also, if you want a space between the two bits of information you're concatenating, and I assume you would with a name, you need to add code for it in between position1 and position2 in the var allpositions line. I added this in the code below (the + " " + bit where the space or other data you want added is between the quotation marks). Otherwise the name will print as JoeSmith instead of Joe Smith. This set up worked for me - I just inserted your fieldnames and changed InsertRecord to EditRecord as you had in your sample. Hope this works for you ! _______________________________________________________ function concatenate() { var position1 = document.getElementById("EditRecordTA_First_Name").value; var position2 = document.getElementById("EditRecordTA_Last_Name").value; var allpositions = position1 + " " + position2; document.getElementById("EditRecordTA_Full_Name").value = allpositions; } document.getElementById("caspioform").onsubmit=concatenate;

Bahar, thanks for the kind offer I was finally able to get it to work , but the request for incorporating it was a feature still stands!

There are SOOOO many ways that having concatenation as a tool choice within Caspio Bridge would be invaluable ... combining first + last names... combining area codes with phone numbers... putting labels with data. I think it ranks with aggregates & calculated fields, but should be in the Submission and Update forms to create combined fields directly into the database, not just in reports/views. This combining can be done by exporting to excel and re-importing, but that negates a basic value of the Caspio system in that data is automatically updated with each form submission - not the case if you have to export and re-import. Please oh please oh please!!!!! If I knew more about programming, I'd be able to do this on my own better. I did find this http://forums.caspio.com/viewtopic.php?f=14&t=12233&start=0&hilit=Insertrecord but can't get it to work.