All geek questions in one place

How to extend data validation to other lines?

Sheet Ranges:

enter image description here

Sheet Work:

enter image description here

The sheet Rangesin the cells A1:A5I have some value, say, One, Two, Three, Four, Five. In cell B1I have the following formula :. =ARRAYFORMULA(transpose(if(Work!$A1<>"";$A$1:$A$5;"")))that fills the cell B1:F1with the values ​​mentioned above based on whether the cell is non-empty A1in the sheetWork

Then I selected the cells B1:F1, and then using fill-handle I dragged the selection down to the coverage range B1:F10. This copied the above range, but each row now depends on the corresponding row in the sheet Work.

, , , .

, Work B1 : Ranges!B1:F1

: , Two, Three, Four, Five, A1

- (1 - 10) fill-handle, , / . . ( 2- , ​​ A .

?

+4
2

, . script, . , , .

, , , . , , .

, fill-handle , Excel. excel Google, , , / .

+1

function a(str)
{
	if(str.uname.value=="")
	{
		document.getElementById("msg1").innerHTML="! Plz Enter Username";
		str.uname.focus();
		return false;
	}
	if(str.pass.value=="")
	{
		document.getElementById("msg1").innerHTML="Plz Enter Password...";
		str.pass.focus();
		return false;
	}
	if((str.pass.value.length<3)||(str.pass.value.length>8))
	{
		document.getElementById("msg1").innerHTML="Plz Enter Password 3 to 8";
		str.pass.focus();
		return false;
	}
	
}
<?php
if(isset($_REQUEST['submit']))
	{
		$uname=$_REQUEST['uname'];
		
		}?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<script type="text/javascript" src="valjs.js">
</script>
</head>

<body>
<form method="post" name="frm"  onsubmit="return a(this)" enctype="multipart/form-data">
<table align="center" border="2"  cellpadding="5px" cellspacing="0px" border="1px">
<tr>
<td><span style="color:#FF0000">* </span>username</td>
<td><input type="text" name="uname" id="uname" />
</td>
</tr>

<tr>
<td>Password</td>
<td><input type="password" name="pass" id="pass" />
</td>
</tr>

<tr>
<td colspan="2" align="center"><input type="submit" name="submit" id="submit" value="Click" />
</td>
</tr>
</table>
</form>
<h4 align="center"><span id="msg1" style="color:#FF0000" >
</span>
</h4>
</body>
</html>
Hide result
-1

Source: https://habr.com/ru/post/1677253/

More articles:


All Articles