Search the Community

Hi, can I use select table using caspio Api to external java script?

i want to change this error from This DataPage is not configured for public access. (Caspio Bridge error) (50510) to "This DataPage is not configured for public access. (*Your company name* error) (50510)"

Hi, I have a REST API for transferring records to the server written in Java with Spring Boot. I am trying the API through postman. The API is working fine in Linux Environment, however, in windows condition, it returns 400 Bad Request as a reaction. There is no adjustment in code in the two frameworks, as I am utilizing a similar container record in the two conditions. The POST asks for comprising of a document connection in the frame information and a parameter userName. My API acknowledges the information in that organization as it were. I have checked the headers in the demand for both the machines and I am simply passing a solitary header Content-Type as application/json. Thanks and Regards Sireesha.

I would appreciate any help you can provide on the following: I this java script on an input form where the parameter [@SU_Type] is passed into the page through a link. THIS SCRIPT WORKS perfectly: <h5><span id="business2" style="color:#263C87;">Company Information:</span></h5> <script> TypeC=[@SU_Type] if(TypeC == 1) {document.getElementById("business2").style.display = "none"} </script> THE PROBLEM: I'm trying to do something very similar on the email/destinations page of another form and it is NOT working. In this form the parameters [@Mailing_Addr_Type] and [@Mailing_Check] are being used in the form and should then be passed, which I am assuming makes them available for use on the Destinations page. However, no matter how I format them in the Jave on the Destinations page of the form the Java does not seem to read the values. I have tested the java itself on other sites and it works if a Value is assigned to md directly. What am I missing? This is my latest iteration, treating the variables as values on the same form as the Java. It does not work. I have tried the following parameter formats: [@field:Mailing_Addr_Type] (with and without the # at the end) [@Mailing_Addr_Type] Thanks for taking the time to look at this. CODE THAT IS NOT WORKING (with fake link info): <h4>Your submission was successful.</h4> <p id="answ3">If you wish to enter additional addresses:</p> <p id="answ2">It appears that the address you entered was not a mailing address (or was not marked as one). Please click the link below and enter a mailing address that can be used in the letter of authorization document. This is required by the utility, not us. Thank you.</p> <button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Add another address</button> <p><span id="answ1">Or, if you are done entering addresses: </span></p> <span id="answ4"><button onclick="location.href='https://www.GOOGLE.COM/'" type="button">Proceed to the Letter of Agreement</button></span><br /> <br /> <script> A=document.getElementById("InsertRecordMailing_Addr_Type").value; B=document.getElementById("InsertRecordMailing_Check").value; md=A+B if(md==0) { document.getElementById("answ1").style.display="none"; document.getElementById("answ3").style.display="none"; document.getElementById("answ4").style.display="none"; } else { document.getElementById("answ2").style.display="none"; document.getElementById("InsertRecordMailing_Check").value=1; } </script>

I am new to Caspio and need help. I created a data page that allows user to search a (or more than one) source. The results page lists the source(s) and for each their term number. User wants to select term numbers and pass those term numbers directly into second data page which I set up to search by term number. The solution I am being told is to use Java to creates a multiply select in data page 1 results page and pass selection to data page 2. If anyone can help me, I would greatly appreciate your help.

Hi, would appreciate some help We have customers that ship packages, we would like for the results page tabular, to when a customer clicks on ship (which is a yes/no field) that it marks the current date (NOT the time) so then we can see which package he selected to be consolidated. Afterwards we can make another database where he can click on the dates and see what he requested to be consolidated. In essence clicking YES would put a date in the table. Thank you sooo very very much!

Hi, I am updating an html block in a datapage form. I tried using this code and tested that the logic works with regular text. But whenever it tries to write the hyperlink, it displays nothing instead. Thanks for any help. <script language="javascript"> var samp='[@field:Table_Sample]'; if (samp.length>0) {var str = "New Record"; var result = str.link("https://www.sample.com");} else {samp = "Update Record" document.write(samp);} </script>

Have some script I want to test in an HTML element - trying to get just a TIME OF DAT picker. But all the code I have found exceeds the 10,000 character limit in Caspio. Workaround - reference external file/js?

Hello, is it maybe possible to display the calendar week on the calender result page? with DATEPART(WEEK,[@field:Date_field]) in a calculated field I get the calendarweek in each record, but I just want to display it at the top corner of every row. In this example the calendar week should be "Add New": http://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-create-date-specific-new-record-links-in-calendar-datapages/ Do you guys have an idea? Thanks!

Our database was created before formulas were allowed in tables. Due to relationships, table restrictions and being live, I would like to fix this without using formulas. I have a submit form that is creating a Work Order Number by concatenating the Equipment_VIN and Time Stamp. In the form the Equipment_VIN is chosen by drop drop down from an equipment table. The form works perfectly. When I change the Equipment_VIN to autocomplete so the VIN numbers are easier to find the element of the VIN is no longer pulled by the script. Anyone have an idea as to why this is happening? Here is the script I am running in the footer. The script points to an HTML block div that is called "won" for work order number. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var position1 = document.getElementById("InsertRecordEquipment_VIN").value; var position2 = '[@cbTimestamp]'; var allpositions = position1 +" "+ position2; document.getElementById("InsertRecordWork_Order_Number").value = allpositions; document.getElementById("won").innerHTML= "Work Order Number is: " + allpositions; } document.getElementById("Submit").onmouseover=concatenate; </SCRIPT>

Hi Can anybody help with some simple (i hope) java that I can place in an HTML holder. I have a data table with employees details but I need to know that they have updated their details. I have a hidden check box called "Updated" which is ticked automatically when a details update form has been completed / updated. I want to show text on my web page that will display if the tick box is EMPTY (not ticked) The text will say something like "Please update your details". This text will NOT be shown if the "Updated" box is ticked. Any help greatly appreciated Steve

Hello. I have entered the following script and on the 3rd data field, the value doesn't show! Also, would like to hide any of the fields if no value with script. Any help is appreciated... <span style="color: #A1A1A1; font-size: 12px; font-family: Arial, sans-serif; font-style: normal; font-weight: normal;">21+</span> <span id="icon[@field:age]"></span> <script> if ("[@field:age]" == "No"){ document.getElementById('icon[@field:age]').innerHTML="<img width='15px' src='http://someapp.com/nk/icons/yellowflag.png'/>"; } else if ("[@field:age]" == "Yes"){ document.getElementById('icon[@field:age]').innerHTML="<img width='15px' src='http://assets.goplaypool.com/files/theme/appcas/check_01.png'/>"; } </script> <span style="color: #A1A1A1; font-size: 12px; font-family: Arial, sans-serif; font-style: normal; font-weight: normal;">Tournaments</span> <span id="icon[@field:tourneys]"></span> <script> if ("[@field:tourneys]" == "No"){ document.getElementById('icon[@field:tourneys]').innerHTML="<img width='15px' src='http://someapp.com/nk/icons/yellowflag.png'/>"; } else if ("[@field:tourneys]" == "Yes"){ document.getElementById('icon[@field:tourneys]').innerHTML="<img width='15px' src='http://assets.goplaypool.com/files/theme/appcas/check_01.png'/>"; } </script> <span style="color: #A1A1A1; font-size: 12px; font-family: Arial, sans-serif; font-style: normal; font-weight: normal;">Tournaments</span> <span id="icon[@field:tourneys]"></span> <script> if ("[@field:tourneys]" == "No"){ document.getElementById('icon[@field:tourneys]').innerHTML="<img width='15px' src='http://someapp.com/nk/icons/yellowflag.png'/>"; } else if ("[@field:tourneys]" == "Yes"){ document.getElementById('icon[@field:tourneys]').innerHTML="<img width='15px' src='http://assets.goplaypool.com/files/theme/appcas/check_01.png'/>"; } </script>

I need help with a calculation that needs to round to the tenth of a percent. I have an update form with four fields. The fourth field is a calculation based on the numbers entered into 1, 2, and 3. Management Expenses Fundraising Expenses Total Revenue AFR My calculation must add management + fundraising and divide that sum by Total Revenue. The result should be input into the AFR field and rounded to the tenth of a percent. A few examples of what I need to accomplish: 500 + 500 / 12,000 = 0.0833333 this should be rounded to 8.3% 600 + 500 / 12,500 = 0.088 this should be rounded to 9.0% The current code that I have used based on the first calculation above only shows 8.0%. I'm new to java so I don't know all the coding that I could be missing here. One other wrinkle is that I would like the calculation to strip any symbols. For example if someone enters $1,200 or $1,200.01 I would like to show only 1200 or 1200.01 in the field. I need a way to ensure no symbols are entered into those fields that may render a calculation error. <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_management = parseFloat(document.getElementById("EditRecordManagemenExpenses").value); var v_fundraising = parseFloat(document.getElementById("EditRecordFundraisingExpenses").value); var v_totalrevenue = parseFloat(document.getElementById("EditRecordTotalRevenue").value); var v_afr = (([v_management + v_fundraising] / v_totalrevenue)*100); document.getElementById("EditRecordAFR").value = Math.round(v_afr).toFixed(1) + "%"; } /* On submitting the webform, the function calculate is executed */ document.getElementById("caspioform").onchange=calculate; </SCRIPT> Any help would be appreciated! One other wrinkle is that I would like the calculation to strip any symbols. For example

I see many JS examples, but none addressing multiple datapages on the same webpage. I have two text variables that I want to concatenate in the 3rd datapage on my update webpage. I'm using the code attached in the footer of the detail page to no avail. I've tried several alternatives on the last line but none worked. The error associated with the last line below is "Object doesn't support property or method 'getElementById'. <SCRIPT LANGUAGE="JavaScript"> function concatenate() { var temp11 = document.getElementById("EditRecordWhere_Sa").value; var temp12 = document.getElementById("EditRecordWhere_Su").value; var temp10 = temp11 + temp12; document.getElementById("EditRecordWhere_Text").value = temp10; } document.forms[2].getElementById("Mod0EditRecord").onmouseover=concatenate; </SCRIPT>

Dear all, Would like to pull data from the tables with Java. Then, after some calculation, put my results into another table in the database. Is it possible? If yes, how can I do?

I have a form that currently uses Dropdowns and want to change them to Radio buttons. Not a biggie, but I'm not sure what I need to change on my script to make it work. It seems that the radio button has 2 fields, so I think I have to somehow choose which is selected? I'm a bit of a novice, so any help would be greatly appreciated. Here is my current script: <SCRIPT LANGUAGE="JavaScript"> function calculate() { var v_q1 = parseFloat(document.getElementById("InsertRecordSec1Q1").value); var v_q2 = parseFloat(document.getElementById("InsertRecordSec1Q2").value); var v_q3 = parseFloat(document.getElementById("InsertRecordSec1Q3").value); var v_q4 = parseFloat(document.getElementById("InsertRecordSec1Q4").value); var v_q5 = parseFloat(document.getElementById("InsertRecordSec1Q5").value); var v_q6 = parseFloat(document.getElementById("InsertRecordSec1Q6").value); var v_Sec1total = (v_q1+v_q2+v_q3+v_q4+v_q5+v_q6); document.getElementById("InsertRecordSec1TotalScore").value = Math.round(v_Sec1total);

Hello Caspio Forum! First post here. One of my links include the following instruction to pass a variable: <a id="mylink" href="culex.ca/client-portal/administration-login/forms-and-reports/adult-and-species-id-form&cbResetParam=1&TPSampleID=" onclick="window.open(this.href, 'mywin','left=20,top=20,width=1100,height=800,resizable=0'); return false;"target="_blank">Click here to Open Species Form</a> Note: I removed the "http://www" here so the link is displayed complete. Unfortunately the instructions in the URL get encoded like this in my webpage: "%26cbResetParam%3D1%26TPSampleID%3D" I tried using URLEncoder like this: <a id="mylink" href="http://www.culex.ca/client-portal/administration-login/forms-and-reports/adult-and-species-id-form&cbResetParam=1&TPSampleID=" + URLEncoder.encode("&cbResetParam=1&TPSampleID=", "ISO-8859-1"); onclick="window.open(this.href, 'mywin','left=20,top=20,width=1100,height=800,resizable=0'); return false;"target="_blank">Click here to Open Species Form</a> but the problem remains the same. Any ideas how to fix this one? Thank you D