This page provides some useful formulas that can be used in the Data Table. Any combination of the formulas below is acceptable. The formulas refer to the data in cell A1 but may be applied to any cell.
For more information on Data Table formulas, refer to Microsoft Excel documentation. All Microsoft Excel formulas can be used in the Data Table.
First three words in a sentence:
=LEFT(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1))
Part of the sentence starting with the fourth word:
=MID(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1),LEN(A1))
The part of the sentence starting with "word":
=MID(A1,SEARCH("word",A1,1),LEN(A1))
Check if two strings are equal:
Duplicate the string three times:
Generate a random uppercase letter:
Validating and Passing Data Back to the Server
The simple validation example uses a plain button control. If a Submit control was used, the example would never see the data to check it everything would go immediately to the server. Avoiding the Submit control lets you check the data, but it doesn't submit the data to the server. That requires an additional line of code:
<SCRIPT LANGUAGE="VBScript">
<!--
Sub Button1_OnClick
Dim TheForm
Set TheForm = Document.ValidForm
If IsNumeric(TheForm.Text1.Value) Then
If TheForm.Text1.Value < 1 Or TheForm.Text1.Value > 10 Then
MsgBox "Please enter a number between 1 and 10."
Else
MsgBox "Thank you."
TheForm.Submit ' Data correct; send to server.
End If
Else
MsgBox "Please enter a numeric value."
End If
End Sub
-->
</SCRIPT>
To send the data to the server, the code invokes the Submit method on the form object when the data is correct. From there, the server handles the data just as it otherwise would except that the data is correct before it gets there.
Subscribe to this comment's feed
| < Prev | Next > |
|---|
