I am trying to convert this excel formula into a Javascript equivalent for a form I am doing in Acrobat Pro 9 and you guessed it. everything is done apart from this.
=SUMIF(B2:B29,"LA",A2:A29)+SUMIF(F2:F29,"LA",E2:E2 9)
in excel i want to replace the word bebo with a value in cell B1 this is the line CREATE TABLE IF NOT EXISTS `bebo` ( `id` int(10) NOT NULL auto_increment,`beboid` varchar(255) default '0',`status` varchar(255) default 'No Comment Posted',PRIMARY KEY (`id`))
in column B i have a load of values so i need an excel formula to replace bebo so that it will take values from B1 to B26 I know this is not the correct section to be posting in but couldnt find a relative section on this site..
I need a Javascript that can process two math formulas to convert Estimated Average Glucose to HbA1c and vice versa. The formulas are as follows:
(28.7 x A1C) - 46.7 = eAG
(46.7 + eAG) / 28.7 = A1c
It could be a two function javascript or two separate javascripts, I am not that particular as long as it does what I need it to do. The way I would like to see it work is you type the number you have into a field, and press a button to convert it. If it was a two function javascript you would have to select the conversion type you want do first.
I have a jQuery object $('p').eq(1) and I would like to display its text equivalent '$('p').eq(1)' in an alert box ie I want the alert box to display $('p').eq(1).The alert box only displays [object Object] (as you might expect).I have used String() (and many others) but this does not work.If this cannot be done, is it possible to do the opposite ie to convert the string "$('p').eq(1)" to the jQuery object $('p').eq(1) ?
This is my code
<html>
<head>
<title>object to text</title>
[code]....
I have a couple of simple forms:
[Code]...
but it doesn't work, because it's not passing the variables correctly I don't think. I don't know how to simulate a simple GET posting of a form.. the data line in this code is from another script which uses POST, but POST doesn't work for my purposes so I have to use GET.
Im opening an excel worksheet and adding data to it using Javascript ActiveX Excel Object as below
var Excel,Book;
Excel = new ActiveXObject("Excel.Application");
Book = Excel.Workbooks.Open("c:/example.xls");
var excel_sheet = Book.Worksheets("Sheet1");
[code]....
In the above code the column A in excel worksheet will have a unique value.I need to delete the entire row matching the value in column A and shift the rest of the rows up using this Javascript ActiveX Excel Object.
Is there an easy way to navigate through the fields of a form with the arrow keys in the same way as navigating cells in excel?
View 2 Replies View RelatedI am trying to create a form/calculator. My concept includes drop down menus, check boxes, roll over images, and calculations. I've been trying to do the coding in Microsoft Excel; however, this has been very cumbersome, and the look is very generic.
View 4 Replies View Relatedhow to send data to MS-Excel sheet from HTML form with javascript. It should be done in javascript not java.
View 5 Replies View RelatedI want to create a mathematical formula plugin for my website where users will enter their own numbers based on the formula in an html form style. The formula is (a)*(b)^2/800 I want their to be a box for users to submit their data which will be (a) & (b) and then a box below showing the calculation. Also buttons giving the users the option to "calculate" and "clear fields". Is there a website where I could input the formula and they could generate the coding?
View 5 Replies View RelatedI'm trying to figure out how to write a formula in jQuery and am stuck... I have simple sums working by using the code pasted below. Now, I'm trying to write a more complicated formula but am unsure of the syntax... The formula I'm trying to write is: (value1 / (0.01 * value2 ))-1
[Code]...
I have a textarea where i want the user to just enter the values: $x $y $z $a $b $c (,),+,-,*,/ ^ Here what i have so far Formula <textarea name="formula" onkeyup="check(this.value)" >
View 1 Replies View RelatedOn a form, I want to jump to the next tabindex when pressing the 'enter' key. The script that should do the thing, should look like this (the tabindex is generated dynamically and the code is simplified):
<form id='MyForm'>
<?php
$tabindex = 1;
?>
[Code]....
i have want to make a formula for my table height.i have some result, every result is 300 pixel height i want to calculate table height= number of result * 300
View 1 Replies View RelatedI am in the middle of designing a website and I am pretty new at it. The guy I am designing the website for wants me to make input fields that calculate data that is entered into them. There are 3 formulas that I need to make.
a=b*.262*c
c=a/(b*.262)
b=a/(c*.262)
They are the same formula just solving for different variables.
I'm making a loan processing system using javascript. But I can't get through with the right outputs because I cant make one formula right. Here are the specifications and requirements:
[Code]...
I am a teacher and would love to find a way to create a form that my
students/parents fill out and email me and then have a macro/script take
this information and automatically create/update a contact in my Outlook
Express Address Book.
Please let me know if there is a way to accomplish this. My site is on
Comcast, and I cannot dynamically save information to the site.
I would like to create a program which converts some letters into different ones.
1) I want 2 text areas (input and output) + "convert" button
2) if I type in the input area the letters "ea" I would like it to be converted into "a", so that If I type "cambrea" and press "submit" the output text will have "cambra".
3) if I type "e " which is (e+space) I want it to be converted into " " which is "space" example: if I type the word "spine " it should be converted into "spin , note that there is a space after "spin ".
4) If I type any vowel before "o" it should render "o", example: gambuo becomes gambo.
would this be possible? I'm not very familiar with Javascript even though I can modify it.
I am working on a page where the user will select a location from a dynamically generated dropdown list. I was able to create the php multidimensional array (tested and working) from a MySql database using the users information at login, but I'm having problems converting it to a javascript multidimensional array. I need to be able to access variables that I can pass to a number of text fields within an html form.For instance, if a user belongs to a company with multiple addresses, I need to be able to let them select the address they need to prepopulate specific text fields.
View 9 Replies View RelatedIs there a way to achieve multithreading in JavaScript? I'm looking to
fetch a page into a div while allowing the user to interact with another
div. At some point the newly fetched page contents will be available to the
div that the user is working in but I don't want to cause unnecessary
blocking. I've thought of using frames (would prefer divs) plus timeouts
and checking for when a load completes. Does anyone have an idea of how
this could work?
A friend of mine has built as simple site for use on his company's
intranet. It uses JavaScript to read comma-delimited information from a
text file and displays it in tabular form.
When I looked at the source there is js like this:
function forwardClick() {
if (sitelist.recordset.AbsolutePosition !=
sitelist.recordset.RecordCount) {
sitelist.recordset.moveNext();
} else {
alert("You are already at the last record in the database.");
}}
and HTML like this:
<OBJECT id="sitelist"
classid="clsid:333C7BC4-460F-11D0-BC04-0080C7055A83" border="0"
width="0" height="0">
<PARAM name="DataURL" value="sites.txt">
<PARAM name="UseHeader" value="True">
</OBJECT>
Obviously it's a Windows and IE only thing but is there an equivalent
for non-IE browsers and/or non-Windows OS?
wondering if there is a va_list equivalent in Javascript. Well,
actually, I know that there is, but I don't know if its user...
applicable. va_list in C/++ anyhow is a way of being able to pass in
any number of arguments at the end of a function, I'll show an example:
Code: ( text )
Header:void addLine(int, const char*, ...); cpp:addLine(int line, const char *string, ...) {char *output;va_list args;va_start(args, string);vasprintf(&output, string, args);va_end(args);}
So as you can see, the space is reserved at the end of the function
declaration with the "..." syntax, and in the function body is expanded
and processed. I could be way off here, but I think I'm on the right
track.
I'm trying to find out if javascript has something akin to $$ in php.What I'm trying to do:
var costs = {
cost1: 5,
cost2: 10,
cost3: 15
}
// Retrieve cost user has selected
alert(costs.selectedCost);
Its obviously a hyper-simplified example of what I'm trying to do, but the premise is the same. In PHP, I could use $$ to convert one variable into another, not sure if JS can do the same.
I have been trying to figure out how to access files on different servers through javascript, as i am converting an onsite myspace app to an iframe app, i need to get the contents of a file from the last.fm api and store it in a variable. Or maybe i could get it with php and store it in a javascript variable if that is possible,
View 3 Replies View RelatedIs there a javascript equivalent of PHP's nl2br() function? I have to send the value of a textarea to a new window that will display the text of what was in the box, which is why I need to somehow convert newlines to breaks.
View 9 Replies View RelatedI've been using display:none on the style property of some <option>
elements in my forms, which works fine with Mozilla - as expected it
removes the option from my dropdown (although it still exists in the
code). Is there an equivalent in IE?
The reasoning behind this is that I want users to rank objects using a
<select> for each place (see below), and to remove the choice of earlier
objects from <select> drop-downs later in the list.
1st place: [<Select> with option 2 chosen]
2nd place: [<select> with option 4 chosen]
3rd place: [<select> --> Option 1
Option 3
Option 5
Option n]