luizcruz

Hello! Studying the "Caspio Bridge Microsoft .Net Framework Sample", that is a general example of WS API usage in C# .Net Windows applications and demonstrates the object de-serialization and usage of SelectDataXML and ListObjects WS API methods, we could connect to our Caspio Bridge tables via WS API and Select our field values. The sample code below is working perfectly! using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Timers; using dataPhase.com.caspio.c0bkr041; using System.Web.Services.Protocols; using System.Xml; namespace dataPhase { public partial class Form1 : Form { private static CaspioBridgeAPI soapClient; public Form1() { InitializeComponent(); soapClient = new com.caspio.c0bkr041.CaspioBridgeAPI(); } private void button1_Click(object sender, EventArgs e) { string sXML; IDictionary<string, string> sRecord = new Dictionary<string, string>(); XmlDocument mXMLDoc = new XmlDocument(); XmlNodeList mList; XmlNode mNode; sXML = soapClient.SelectDataXML("AccountID", "Profile", "Password", "My_Users", false, "", "User_ID=" + textBox3.Text, "", false, false, true, false); mXMLDoc.LoadXml(sXML); mXMLDoc.Save("My_Users.xml"); mNode = mXMLDoc.SelectSingleNode("// My_Users"); mList = mNode.SelectNodes("./*"); foreach (XmlNode mFieldNode in mList) { sRecord[mFieldNode.Name] = mFieldNode.InnerText; } textBox1.Text = sRecord["First_Name"]; textBox2.Text = sRecord["Last_Name"]; textBox5.Text = sRecord["Phone"]; textBox4.Text = sRecord["Address"]; } private void Form1_Load(object sender, EventArgs e) { textBox3.Text = "Enter User ID"; } } } Now we would like to learn how to insert and update data in our Caspio Bridge database! Please, Could someone show us how to add a new user information using the same approach? and how we could update a specific user information? Best Regards! Luiz

Hi! I would like to say the jQuery solution to hide/show div I mentioned in this post, was provided by "Ashley Ford" and you can find the detailed tutorial in the following url! Simple jQuery Show/Hide Div http://papermashup.com/simple-jquery-showhide-div/ Best Regards! Luiz

Hi! Fortunately I managed to solve the issue! The mistake I was making was trying to use "class" instead of "id". Now I understood that in this case, the reference to the HTML field is taken through the id property. 1) wrong way ==>> $('.InsertRecordField_name').click(function(){ 2) Correct way ==>> $("#InsertRecordField_name").click(function(){ Ps: InsertRecord to submission forms and EditRecords to Update forms! Regards! Luiz

Hi! I'm testing a JQuery script to hide/show divs and it's working successfuly, and I consider this approch very nice to hide/show fields, because it does not cause any problem with alignment of the fields! This solution as is requires we click in the respective weblink to show and hide the fields! But I need to make a little change, I would like to trigger this function when the corresponding checkbox is checked, e.g. when the checkbox "x" is checked show div "x", and when it is unchecked hide div "x"! The triggers to call this function would be the following: 1) "Ir para o Trabalho" checkbox instead "Show/hide_1" weblink! 2) "Ir para o Colégio/ Faculdade/ Pós Graduação" checkbox instead "Show/hide_2" weblink! Please, could someone help me set these triggers? My url page is: http://sa1.caspio.com/dp.asp?AppKey=58733000aac8a3fdae8b45deb24a The script I'm using is the following: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function(){ $(".slidingDiv1").hide(); $(".show_hide1").show(); $('.show_hide1').click(function(){ $(".slidingDiv1").slideToggle(); }); }); </script> <script type="text/javascript"> $(document).ready(function(){ $(".slidingDiv2").hide(); $(".show_hide2").show(); $('.show_hide2').click(function(){ $(".slidingDiv2").slideToggle(); }); }); </script> Best! Luiz

Hi Jan! Thank you very much! I had noticed this error, but even correcting this mistake the script still does not work! Regards! Luiz

Hi Charlene! Please, What type are your fields? Dropdown, Checkbox? Luiz

Hello Heisenberg! Before run the below script go to "Web Form Wizard - Destinations and Triggers to set the destination options: Destination after record submit: Go to a new page Page URL: [@Virtual1] =>> In your last script you forgot the last command "document.getElementById("caspioform").onsubmit=myFunction;" Try this script! <script> function myFunction() { var y = document.getElementsByName("InsertRecordWorkOrderDetail")[0].value; if(y == "M1 TDM"){ document.getElementById("cbParamVirtual1").value = "http://b6.caspio.com/dp.asp?AppKey=b9443000bc1de4154c364d53a0b5";} else if(y == "M1 Fiber"){ document.getElementById("cbParamVirtual1").value = "http://b6.caspio.com/dp.asp?AppKey=b94430008aaa7fbc77eb48df83f8";} } document.getElementById("caspioform").onsubmit=myFunction; </script> I hope it works! Regards! Luiz

Hi Jan! Yes, you're right! "test" and "Test" will not work, it is wrong! But, unfortunately the problem is not the "test or Test", because the script above is just an hipotetical script! I tested with the true data, without the "t or T" issue, and it´s still does not work! Regards! Luiz

Hi Heisenberg! I'm a Newbie too, but I would like to help you, Are you receiving the field [@field:WorkOrderDetail] as parameter from another DataPage or it´s part of the same DataPage? Your dataPage is a submission form? Regards! Luiz

Hi, I'm trying to adapt the script provided by "Fangjie" to suit our needs but unfortunately it is not working yet! In our case we have dropdowns instead virtual fields! I'm trying the following: <script type="text/javascript"> function Display() { var sec = document.getElementsByName("InsertRecordRenova_Origem"); var dropdown = sec.options[sec.selectedIndex].value; if (dropdown == 'Select') { document.getElementById('Section3').style.display = 'none'; document.getElementById('Section4').style.display = 'none'; } if (dropdown == 'Yes') { document.getElementById('Section3').style.display = 'inline'; document.getElementById('Section4').style.display = 'none'; } else if(dropdown == 'No') { document.getElementById('Section3').style.display = 'inline'; document.getElementById('Section4').style.display = 'none'; } } document.getElementsByName("InsertRecordRenova_Origem").onchange = Display; </script> Please, anyone have any idea what is missing? Thanks! Luiz

Hello Jan! Thank you very much! I tried the solution you provided, but unfortunately it not works yet! You understood correctly, in the first dropdown we have 9 options, 2 of them should toggle the visibility of two different sections! Regards! Luiz

Hello Guys! I'm trying to "subscribe" to the dropdown's onchange event and change the section's visibility depending on the value selected. I would like to do the following: When I choose "Yes" in the dropdown Test_1 the "Section1" is visible When I choose "No" in the dropdown Test_1 the "Section2" is visible <script type="text/javascript"> var x = document.getElementsByName("InsertRecordTest_1")[0]; x.onchange = function() { var x = document.getElementsByName("InsertRecordtest_1")[0]; var Section1 = document.getElementById('Section1'); var Section2 = document.getElementById('Section2'); if(x == "Yes");{ Section1.style.display = 'inline' : 'none'; } else if(x == "No");{ Section2.style.display = 'inline' : 'none'; } } </script> Please, does anyone have any idea what's wrong? Thanks! Luiz

Hi MayMusic! Thank you very much! Regards! Luiz

Hi, I would like to redirect the user to a specific page after the form is submitted according to the option selected in a dropdown! I tried the following script but unfortunately it´s not working yet: 1) I created a Virtual field to redirect to the value of this Virtual field. 2) I Used the following code in the Footer of my DataPage. The value of Virtual1 should be defined by the dropdown selection! <script language="JavaScript"> function myFunction() { var x = document.getElementByName("InsertRecordMyOption")[0]; if (x == 'Yes'){ document.getElementById("cbParamVirtual1").value = "http://www.google.com/";} else if (x == 'No'){ document.getElementById("cbParamVirtual1").value = "http://www.yahoo.com/";} else if (x == 'Maybe'){ document.getElementById("cbParamVirtual1").value = "https://www.bings.com/";} } document.getElementById("caspioform").onsubmit=myFunction; </script> I set the [@Virtual1] field as form element "Hidden" could someone give me a hand? Regards! Luiz