• Show page
  • Old revisions
  • Backlinks
  • Fold/unfold all
  • Back to top
    • Back to top

    Differences

    This shows you the differences between two versions of the page.

    Link to this comparison view

    Both sides previous revisionPrevious revision
    Next revision    		Previous revision
    sop:guides:managing_backflows [2020/12/24 08:10] – [Template Interface Details] daveksop:guides:managing_backflows [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
    Line 1: Line 1:
    -======== Managing Backflows ======== 
    -====== General Notes ====== 
    -This program is comprised of one main database file which can be found at either Z:\Aichele\Backflow Information or wherever the root storage is on your computer. 
    -====== Opening the Database ====== 
    -  - Navigate to the root folder by double clicking on the ‘Backflow Testing’ folder on your desktop.{{ :files:managing_backflows:image001.png?nolink& |Folder}} 
    -  - Double **Click** on the file named ‘Backflows’.{{ :files:managing_backflows:image000.png?nolink& |Database}} 
    -  - If a window about Macro Security appears, **select** the __Enable Macros__ button.{{ :files:managing_backflows:image006.png?nolink& |Macro Security}} 
    -Database is now open! 
    - 
    -====== Customer Management ====== 
    -===== Adding a Customer/Visit Record ===== 
    -  - **Open** the database as specified above if it is not already open. 
    -  - In the 'Database' pane on the left, **click** on the ‘For__m__s’ button.{{ :files:managing_backflows:image003.png?nolink& |Forms button}} 
    -  - **Double Click** on '__Edit Visits__' form name to open it.{{ :files:managing_backflows:image007.png?nolink& |Edit Visits}}<wrap info>It may open with an existing customer/visit selected.</wrap>{{ :files:managing_backflows:image021.png?nolink& |Customer/Visit Form}} 
    -  - **Click** on the 'New Record' button along the bottom of the form.{{ :files:managing_backflows:image020.gif?nolink& |New Record button}} 
    -  - **Click** in the new ‘customer_name’ field, and type the __customer’s billing name__. 
    -  - After entering the customer’s name, **click** the TAB key on the keyboard to move to the account_num field. Fill in this field if you need to. This data will come from the city. 
    -  - In the 'Reoccuring' section, fill out: 
    -    * The 'Month' field is the name in which the work is to be done, or 'once' if it is a one-time job. 
    -    * The 'week' field should be __1, 2, 3, 4, or 5__, depending on which __week of the month__ the customer would like the work to be done. 
    -  - In the 'Contact' section: 
    -    * **Enter** the Contact's Name, Phone Number, and E-mail Address. 
    -  - In the 'Site' section: 
    -    * The 'city' field is where the work has been / will be performed. 
    -    * The 'service_address' is, well, the service address. 8-) 
    -    * The 'location' is the location of the backflow device <wrap notice>(Examples: Next to produce cooler, Front Yard, North side of building…etc)</wrap>. 
    -    * The 'cross_connection_control_for' is the __type of system__ to which the backflow device is connected to <wrap notice>(Examples: Main, Hose Station, Irrigation, Espresso Machine)</wrap>. 
    -    * Field '__cc_manufacturer__' is the manufacturer of the backflow device. 
    -    * Field '__cc_model__' is the model of the backflow device. 
    -    * Field '__cc_size__' is the size of the backflow device (usually 1/2", 3/4", 1"..etc). 
    -    * Field '__cc_serial__' is the serial number on the backflow device. 
    -    * Field '__cc_assembly_type__' is the assembly type of the backflow device. 
    -    * Field '__cc_installed_ok__' is __yes__ or __no__ depending on if the backflow device was installed properly or not. 
    -    * Field '__cc_month_tested__' is the month in which the device was tested last. (or will be tested) 
    -    * Field '__remarks__' will be printed on the form, so put any remarks that you want to be seen, in this field. 
    -    * Field '__cc_prev_charge__' is the Previous Charge for this job. 
    -    * Field '__cc_setup_date__' is the date which we initially setup this client. 
    -    * Field '__cc_big_notes__' will not be printed, useful for internal remarks about the site or work. This is where we usually type in the date of when the device was tested. 
    -    * The fields like '__xx_status__' represent each year, and if the job was successful or not. a (1) means "Job was not completed", a (2) means "Job was completed successfully". 
    -  - In the "Tester and Device" section: 
    -    * **Select** the 'Tester Name' in the first field. 
    -    * **Select** the 'A-1 Plumbing & Emergency Rooter' in the 2nd field. 
    -    * **Type in** the serial number of the testing device in the __Device Serial__ field.    
    -  - To save the record, simply **click** on any 'Save Record' button. {{ :files:managing_backflows:image005.gif?nolink& |Save Record button}}If no error message appears, you have successfully added a customer record! 
    -  
    - 
    -===== Editing a Existing Customer Record ===== 
    - 
    -  - **Open** the database as specified above if it is not already open. 
    -  - In the 'Database' pane on the left, **click** on the ‘For__m__s’ button.{{ :files:managing_backflows:image003.png?nolink& |Forms button}} 
    -  - **Double Click** on '__Edit Visits__' form name to open it.{{ :files:managing_backflows:image007.png?nolink& |Edit Visits}} 
    -  - Locate the specific record you wish to edit by scrolling in the pane on the right, or using a filter (either ‘AutoFilter’ or ‘Standard Filter’. For details on how to use the filter, refer to the chapter entitled Using Filters.) 
    -  - Locate the field you wish to edit, and **click** to begin editing. 
    -  - When you are done editing the field, **click** the 'Save Record' button to save.{{ :files:managing_backflows:image005.gif?nolink& |Save Record button}} 
    - 
    -Congratulations! You’ve edited an existing customer record! 
    - 
    -  
    -===== Removing a Customer Record ===== 
    - 
    -  - **Open** the database as specified above if it is not already open. 
    -  - In the 'Database' pane on the left, **click** on the ‘For__m__s’ button.{{ :files:managing_backflows:image003.png?nolink& |Forms button}} 
    -  - **Double Click** on the 'Edit Visits' form to open it. 
    -  - Locate the specific record you wish to remove by scrolling, or using a filter (either ‘AutoFilter’ or ‘Standard Filter’). For details on how to use the filter, refer to the chapter entitled Using Filters.  
    -  - Once you have visually located the customer record which needs complete removal, **click** once on it, and MAKE SURE that that is the one you want to delete! 
    -  - **Click** the "Delete Record" button on the bottom bar.{{ :files:managing_backflows:image011.gif?nolink& |Delete Record button}} 
    -  - Confirm the removal by clicking on the ‘Yes’ button. 
    - 
    -You’ve successfully removed a customer record! 
    - 
    -====== Opening a City Form ====== 
    -  - **Open** the database (if it is not already open) by following the "Opening the Database" guide above. 
    -  - In the 'Database' pane on the left, **single click** on the ‘For__m__s’ button.{{ :files:managing_backflows:image003.png?nolink& |Forms button}} 
    -  - Locate the city form you desire and **double click** on it. The format is “Backflows: xxxx” where xxxx is the city name of where the job is being done. Following example shows the College Place template selected.{{ :files:managing_backflows:image004.jpg?nolink& |Form Selected}} 
    -  - **Visually Find** the "Form Navigation" Bar, it looks like this:{{ :files:managing_backflows:image008.png?nolink& |Form Navigation}} 
    -  - **Click** on the "Data Source as Table" button.{{ :files:managing_backflows:image002.png?nolink& |Data Source as Table button}} 
    -  - You should now be looking at something similar to the below window. (Note, it will look different for different cities){{ :files:managing_backflows:image014.png?nolink& |Open Form}} 
    -  
    -You have opened a template! <WRAP round info>I realize that it looks rather busy. Please do not be alarmed, as everything will be explained in the next few chapters. If you want an overview of this window, take a look at the chapter called Template Interface Details</WRAP> 
    - 
    -====== Creating, Filling, and E-mailing the Form ====== 
    - 
    -Ok, so you’re at the job site and you’ve finished the job. You are now ready to create the form and e-mail it around.  
    - 
    -===== Selecting the Customer ===== 
    - 
    -  - Open the correct template for the city you are in as detailed in Opening a City Template (if it is not already open). 
    -  - Locate the specific record you wish to use by scrolling or using a filter (either ‘AutoFilter’ or ‘Standard Filter’). For details on how to use the filter, refer to the chapter entitled Using Filters.{{ :files:managing_backflows:image031.png?nolink& |Scroll Bar}} 
    -  - __Highlight__ the row by **left clicking** in the brown/grey area just to the left of the row. {{ :files:managing_backflows:image033.jpg?nolink& |Selected Row}} 
    -<WRAP round info>The form should now be updated to match the row you clicked on. Great job!</WRAP> 
    - 
    - 
    -===== Filling Out Visit-Specific Details ===== 
    -  - Add information specific to this visit. You will see things like CHECKBOXES and FIELDS. The exact location and meaning of each field is different for each template. When you have completed adding information, proceed to the next step. 
    -  - Press the ‘Submit’ button at the bottom of the page. This action will launch a custom script. Wait for the e-mail window to appear and proceed to the next step __Sending the E-Mail__. 
    - 
    -===== Sending the E-Mail ===== 
    - 
    -You will see several windows flash by, and then a window asking “Do you want send this e-mail immediately?” Follow the below flowchart.{{ :files:managing_backflows:image043.gif?nolink& |Email Flowchart}} 
    - 
    -You’ve successfully sent the form via e-mail! 
    -  
    - 
    -====== Using Filters ====== 
    - 
    -<WRAP round tip>The screen goes slightly blurry as your frantically scroll downward, attempting to find that one customer to edit or use in the template. After zooming past 400 records and coming to the end, you realize you missed it. Slowly you trudge back up the list.</WRAP> 
    - 
    -The above situation can be avoided by the use of filters to filter the view to show you only what you are looking for. Here is a brief outline on how to use them. 
    - 
    -We assume that your window looks something like this:{{ :files:managing_backflows:image058.gif?nolink& |City Form}} 
    - 
    -If not, please follow the steps in the first chapter to open a database -> city template and toggle on the data source window. 
    - 
    - 
    -===== AutoFilter ===== 
    -  - Visually locate and **click** on a field you want to filter by, in the same column. For instance, if I wanted to show only the records which had a value of ‘June’ in the column named ‘month’, I would **click** on the field shown to the right.{{ :files:managing_backflows:image046.gif?nolink& |Selecting the field}} 
    -  - **Click** on the button named ‘AutoFilter’.{{ :files:managing_backflows:image047.gif?nolink& |AutoFilter}} 
    -  - Notice how only the records which have the selected value in the desired column are showing? Sweet! 
    -  - To remove the filter, **click** the ‘Remove Filter/Sort’ button.{{ :files:managing_backflows:image048.gif?nolink& |Remove Filter button}} 
    -<WRAP round important>Updates to OpenOffice may change the look of the buttons, but the names of them will always stay the same, as will the general style. Once you are familiar with the location of the buttons, they will not change on you.</WRAP> 
    - 
    -===== Standard Filter ===== 
    -  - **Click** on the ‘Standard Filter’ button.{{ :files:managing_backflows:image049.png?nolink& |Standard Filter}} 
    -  - A new window will appear which looks like this:{{ :files:managing_backflows:image051.gif?nolink& |Filter window}} 
    -  - **Click** on the first ‘Field name’ dropdown and select the field that you would like to filter. <wrap notice> For instance, if I were to filter by the field ‘month’, I would select ‘month’ from the dropdown. </wrap> {{ :files:managing_backflows:image052.gif?nolink& |Selecting "Month"}} 
    -  - If you are testing for a ‘Greater than’, ‘Less than’ or ‘Like’, **click** on the first ‘Condition’ dropdown and select the desired comparison type. Otherwise you can leave it on the default comparison type ‘=’.{{ :files:managing_backflows:image053.png?nolink& |Selecting Condition}} 
    -  - **Click** on the first ‘Value’ box, and type in the value which you would like to filter by. For instance if I wanted to filter by ‘May’, I would **click** and type in ‘May’ (without the single quotes).{{ :files:managing_backflows:image056.gif?nolink& |Filtering by 'May'}} 
    -  - If you wish to add a 2nd filter, do the above steps for the 2nd line down, then select how you want the two filters to operate from the far left dropdown called ‘Operator’. (AND = Both lines MUST be true) (OR = One of the lines must be true) 
    -  - You can also add a 3rd condition by following the previous step. 
    -  - **Click** OK to apply the filter.{{ :files:managing_backflows:image057.gif?nolink& |OK button}} 
    -  - You are now back to the main ‘Data Source’ window. Only records matching your filter are displayed. If there are no records displayed, repeat the above steps using less conditions, or broaden your condition(s). 
    -  - To remove the filter, **click** the ‘Remove Filter/Sort’ button.{{ :files:managing_backflows:image048.gif?nolink& |Remove Filter button}} 
    - 
    -