We understand that there are many ways in which you would like to use our new “live” availability utilizing Google Sheets. There are so many ways to open, search, and print our current availability depending upon what device you are using. Click on the buttons below to find out more.
Windows PC
To View Availability:
Click on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
This will open the Inventory List in Google Sheets through your browser.
To Search Availability Page:
Click on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Press Ctrl and F on your keyboard.
In the search board that pops up on your screen (usually top right corner), type in the plant or size you would like to search for.
Results will be highlighted on the page. Scroll through each result until you find what you are looking for.
To Download Availability:
Click on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Click File, Download As, select your preferred format (Microsoft Excel, PDF, etc).
After you click on the preferred format for your download, a window will appear at the bottom of your browser asking you if you want to “Open”, “Save”’, or “Cancel” this download file. If you click on the down arrow next to the “Save” button and select “Save As” another window will appear that will allow you to select a different folder if you do not wish for it to save it in the default folder which is normally your Download folder. After you select the folder you wish to save the file in, click “Save”. If you just click on the “Save” button in the first window and do not click on the down arrow next to the “Save” button and then select “Save As”, it will automatically save it to your Download folder.
If you choose to download as a PDF: on the Print Settings page, click “Export” button in the top right corner of the page. After you click on the “Export” button, the window at the bottom of your screen should appear with the “Open, “Save”, or “Cancel” buttons and you can follow the same steps as above to save the file to your desired location or in the Download folder.
To Print Availability:
Click on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Click “File”, then “Print”.
Click “Next”. Choose the correct printer. Click “Print”.
Apple iPhone/iPad
In order to view Availability on your iPhone, it would be best to download the Google Sheets app to your phone. You can do this by going to App Store and search for the Google Sheets app. Once you find it, tap on “Get”, then “Install”. Once installed, the Google Sheets app will appear on your home screen and now anytime you follow the steps below to view, search, download or print the latest list, it should open it up in your Google Sheets App. This will allow for a much better ease of use in viewing the list from your phone.
To View Availability:
Tap on the button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
If you downloaded the Google Sheets app, this will open the document in Google Sheets for easier viewing. If not, it will open it in your Safari browser and will be harder to navigate through.
To Search Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Find and Replace” option.
The search box will appear at the top of your screen. Type the plant or size you would like to search for.
This search/Find option will take you to the first instance in the list that matched what you typed. You can continue to search for other occurrences of what you are searching for by hitting the down arrow next to the search screen.
To close out of the Search/Find option, you can either tap on the “X” that appears in the top left of your screen.
To Download Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Share & export” option.
Tap on the “Save As Excel (.xlsx)” option. This will create a local copy of Excel file and reload your new file as an Excel spreadsheet inside Google Sheets. If you want to be able to use this file in an Excel app on your iPad/iPhone or if you want to send it to yourself through email, you can use the “Share & export option and then select “Send a copy”. Then you can tap on the “Mail” icon or “Save to Files” icon depending on whether you want to email it to an email address or save it to your iPad or iCloud. Once the file is saved to the iPad or iCloud you can open it up in the Microsoft Excel App.
NOTE: Unfortunately from the iPhone or iPad, you only have the option to download this file as an Excel file and there is really no need to do this as it will automatically bring this same file up in Google Sheets.
To Print Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Share & export” option.
Tap on the “Print” option. It will prepare the file in a viewable format for printing (a PDF like view). Use the down arrow at the top right of our screen to choose a printer. NOTE: You must have printers installed on your phone already to be able to print the list to a particular printer.
Android/Google Phone
In order to view Availability on your Android Phone, it would be best to download the Google Sheets app to your phone. You can do this by going to your Play Store on the device and search for Google Sheets and tap “Install”. Once Installed, anytime you follow the steps below to view, search, or print the latest list, it should open it up in your Google Sheets App. This will allow for a much better ease of use in viewing the list from your phone.
NOTE: Once you open this Availability List in Google Sheets, it should be available from your Google Drive and you can make a link to it directly on your home screen. If you wish to do this, just open your Google Drive app that should already be available in your Google Apps on your phone. Open the Google Drive and you should see your Currins_currentavailability file. Do not open the file, but instead, tap on the 3 dots to the top right of the file. This will bring up a drop menu. Scroll down the menu and select the “Add to Home screen” option. This will add an icon that is a direct link to the file and if you tap on this link it will automatically bring the Availability List in your Google Sheets app.
To View Availability:
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
If you downloaded the Google Sheets app, this will open the document in Google Sheets for easier viewing. If not, it will open it in your Google Chrome browser and will be harder to navigate through.
To Search Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Find and Replace” option.
The search box will appear at the top of your screen. Type the plant or size you would like to search for.
This search/Find option will take you to the first instance in the list that matched what you typed. You can continue to search for other occurrences of what you are searching for by hitting the little magnifying glass that is in the bottom right of your keypad.
To close out of the Search/Find option, you can either tap on the “check mark” that appears in the top left of your screen or you can hit the return button on your phone a couple of times until you are back at the main menu.
To Download Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Share & export” option.
Tap on the “Save As…” option. This will bring up a Save As Menu options. Select the format you wish to download the list as (like Excel or PDF) and click “OK”.
NOTE: If you are wanting to download and view this file as an Excel file on your phone, there is really no need to do this as it will automatically be a file available already in Google Sheets.
If you chose a PDF, it will convert it to the desired file type and present you with a view of that file. To actually download it to your phone, you must tap on the little down arrow icon to the right of the file name at the top. This will download it to the Download folder in “My Files” icon. If you choose another file type, it will try to save this file to your Google Drive that is associated with your Google account. If you do not have a Google account, it will encounter an issue when saving the file.
To return to your list view, just hit the Left Arrow at the top of your screen or hit your phone’s return button.
To Print Availability (This assumes you downloaded the Google Sheets App):
Tap on the top button (Labeled: LINK TO AVAILABILITY VIA GOOGLE SHEETS) on the availability page to open the link.
Tap on the three dots in the top right of your screen and select the “Share & export” option.
Tap on the “Print” option. It will prepare the file in a viewable format for printing (a PDF like view). Use the down arrow at the top right of our screen to choose a printer. NOTE: You must have printers installed on your phone already to be able to print the list to a particular printer.