If you store documents in a QuickBase application, you can search for a name or snippet of text that a file may contain. You can use Advanced search to do just that. QuickBase can search many types of files—presentations, spreadsheets, word-processing documents, and Adobe Acrobat files.
Advanced search lets you search file attachments in two ways:
Search all file attachment fields in an application
Search a particular file attachment field in an application
Note: QuickBase searches are not case-sensitive; QuickBase returns a match, regardless of case.
QuickBase lets you search any and all file attachments in a table by providing the <some attached file> option in Advanced search. The <some attached file> option makes sense when your table contains several file attachment fields and you want to search across them, or when you're not sure of the name of the field you want to search. The option does have some limitations, though. When you choose this option, you can't search filenames; you can only search the contents of the file using one of the following options:
When you choose
QuickBase returns a report listing records with file attachments that
contains the word
contain the exact word you enter
contains a word that starts with
contain a word that begins with the string you enter
You can choose to search a particular file attachment field. In this case, you can search for documents that contain a specific word, or that contain a word that starts with a particular string. You can also search the filenames of file attachments when you search for a particular field. You can search for:
When you choose the operator
QuickBase returns a report listing records with file attachments with filenames that
contain the string you enter
filename does not contain
do not contain the string you enter
match the string you entered. Note that you must specify a file extension to get an exact match.
are not an exact match with the string you enter
start with the character or string you enter
does not start with
do not start with the character or string you enter
QuickBase allows you some flexibility when entering search strings. You can:
Search for more than one string at a time
Search for an exact match
Search for strings with variable characters using "wildcards"
To search for more than one string at a time, enter a search string that contains the following operators:
Searches for more than one string at a time.
apple AND pear AND banana
Contain all three of the words: apple, pear, and banana. Entries that contain only one or two of these words are not returned.
Searches for either one string or another.
apple OR pear OR banana
Contains any or any combination of these three words.
Note: AND and OR are called Boolean operators and the search phrases you build with them are called Boolean requests.
To specify an exact match for your search, enclose the search string in double quotation marks.
Finds an exact match of the phrase you enter.
Contain the exact phrase "ice cream."
Appends an exact string search to another search string.
Contain the exact phrase "ice cream" plus another search string.
Excludes an exact phrase from a search.
DO NOT contain the exact phrase "ice cream."
To search for strings that may contain characters that vary, place a wildcard character in your search string.
Use in place of any single character.
Contain a series of letters. (Possible matches are woman or women.)
Use in place of any number of characters.
Contain words that begin with i and end with e. (Possible matches are ice and icicle.)
Use to indicate a numeric range.
Contain numbers between 5 and 12 (including 5 and 12).
Open a table from the Table bar, then click Search on the Global bar.
Note: If you don't see this button, your app admin has removed access to it for users in your role.
Click Advanced Search.
Select all or any of these conditions are true under Show <records> where.
You can add more than one search condition in Step 5.
In the first dropdown on the left, select the name of a field, or <some attached file>.
Select an operator from the middle dropdown.
Type the term that you want to find in the dropdown on the right.
To enter another set of criteria, click the plus sign that appears when you move the pointer over the search condition, then repeat Steps 4 through 6.
QuickBase searches the contents of records in the table, then displays a list of records that contain the documents that match your criteria. QuickBase automatically returns results in the column and row order format specified in the reporting defaults for the table. You can change the reporting defaults, if you like.
Tip: If QuickBase doesn't return the results you want, use the icon on the Page bar to edit your search conditions. Read more about searching for records.
Return to top
© 1999-2016 QuickBase, Inc. All rights reserved. Legal Notices.
Show help contents