HELP
Functions:
Standard
Search Capibilities
getDatabaseObject_Filename(Sheet, Row, Column)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Sheet: The sheet that the object is located on - 1 because the index begins with 0. (if the object was on sheet 2, then the vaule of sheet would be 1)
Row: The row that the object is located in - 1 because the index begins with 0.
Column: The column that the object is located in - 1 because the index begins with 0.
Function returns the object loacted at [Sheet][Row][Column] in the database. Will return either a string, or a number.
Sample:
var sheet = 1
var row = 2
var column = 4
var object = getDatabaseObject_MyDatabase(sheet, row, column)
alert(object)
getNumberOfDatabaseSheets_Filename()
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Function returns the number of sheets in the database as an intger.
Sample:
var numOfSheets = getNumberOfDatabaseSheets_MyDatabase()
alert(numOfSheets)
getNumberOfDatabaseRows_Filename()
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Function returns the number of rows in the database as an intger.
Sample:
var numOfRows = getNumberOfDatabaseRows_MyDatabase()
alert(numOfRows)
getNumberOfDatabaseColumns_Filename()
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Function returns the number of columns in the database as an intger.
Sample:
var numOfColumns = getNumberOfDatabaseColumns_MyDatabase()
alert(numOfColumns)
getEntireDatabaseSheetEntries_Filename(Row, Column)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Row: The row - 1 that will be referenced by the function.
Column: The column - 1 that will be referenced by the function.
Function returns an array of database objects on every sheet where the row and the column intersect.
Sample:
var sheetData =getEntireDatabaseSheetEntries_MyDatabase(1,2)
alert(sheetData[0])
getEntireDatabaseRowEntries_Filename(Sheet, Column)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Sheet: The sheet - 1 that will be referenced by the function.
Column: The column - 1 that will be referenced by the function.
Function returns an array of database objects in every row of the column specified on the sheet specified.
Sample:
var rowData =getEntireDatabaseRowEntries_MyDatabase(5,3)
alert(rowData[0])
getEntireDatabaseColumnEntries_Filename(Sheet, Row)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
Sheet: The sheet - 1 that will be referenced by the function.
Row: The row - 1 that will be referenced by the function.
Function returns an array of database objects in every column of the row specified on the sheet specified.
Sample:
var columnData =getEntireDatabaseColumnEntries_MyDatabase(2,1)
alert(columnData[0])
searchDatabaseBySheet_Filename(textToSearchFor, typeOfSearch, Row, Column)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
textToSearchFor: The string that will be searched for.
typeOfSearch: Speciefing how the search is to be preformed.
-
"number" - The search will compare 2 numbers.
-
"exact" - The search will compare 2 strings and will only return perfect matches (case sensitive).
-
"exact/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"contains" - The search will compare 2 strings and will return anything containing the search string (case sensitive).
-
"contains/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"beginsWith" - The search will compare 2 strings and will return matches begining with the search string (case sensitive).
-
"beginsWith/nc" - The search will compare 2 strings and will return matches begining with the search string (non-case sensitive).
-
"endsWith" - The search will compare 2 strings and will return matches ending with the search string (case sensitive).
-
"endsWith/nc" - The search will compare 2 strings and will return matches ending with the search string (non-case sensitive).
Row: The row - 1 that will be referenced by the function.
Column: The column - 1 that will be referenced by the function.
Function returns an array of database objects matching the search string and will search through the sheets on the row and column specified.
Sample:
var searchResult = searchDatabaseBySheet_MyDatabase("javascript","contains/nc",1,2)
alert(searchResult[0])
searchDatabaseByRow_Filename(textToSearchFor, typeOfSearch, Sheet, Column)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
textToSearchFor: The string that will be searched for.
typeOfSearch: Speciefing how the search is to be preformed.
-
"number" - The search will compare 2 numbers.
-
"exact" - The search will compare 2 strings and will only return perfect matches (case sensitive).
-
"exact/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"contains" - The search will compare 2 strings and will return anything containing the search string (case sensitive).
-
"contains/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"beginsWith" - The search will compare 2 strings and will return matches begining with the search string (case sensitive).
-
"beginsWith/nc" - The search will compare 2 strings and will return matches begining with the search string (non-case sensitive).
-
"endsWith" - The search will compare 2 strings and will return matches ending with the search string (case sensitive).
-
"endsWith/nc" - The search will compare 2 strings and will return matches ending with the search string (non-case sensitive).
Sheet: The sheet - 1 that will be referenced by the function.
Column: The column - 1 that will be referenced by the function.
Function returns an array of database objects matching the search string and will search through the columns on the sheet specified and in the column specified.
Sample:
var searchResult = searchDatabaseByRow_MyDatabase(5,"number",3,5)
alert(searchResult[0])
searchDatabaseByColumn_Filename(textToSearchFor, typeOfSearch, Sheet, Row)
Top of page
Filename: The name of the database file excluding the extensions. (database1)
textToSearchFor: The string that will be searched for.
typeOfSearch: Speciefing how the search is to be preformed.
-
"number" - The only search that will compare numbers.
-
"exact" - The search will compare 2 strings and will only return perfect matches (case sensitive).
-
"exact/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"contains" - The search will compare 2 strings and will return anything containing the search string (case sensitive).
-
"contains/nc" - The search will compare 2 strings and will be non-case sensitive.
-
"beginsWith" - The search will compare 2 strings and will return matches begining with the search string (case sensitive).
-
"beginsWith/nc" - The search will compare 2 strings and will return matches begining with the search string (non-case sensitive).
-
"endsWith" - The search will compare 2 strings and will return matches ending with the search string (case sensitive).
-
"endsWith/nc" - The search will compare 2 strings and will return matches ending with the search string (non-case sensitive).
Sheet: The sheet - 1 that will be referenced by the function.
Row: The row - 1 that will be referenced by the function.
Function returns an array of database objects matching the search string and will search through the columns on the sheet specified and in the row specified.
Sample:
var searchResult = searchDatabaseBySheet_MyDatabase("databa","beginsWith",1,2)
alert(searchResult[0])