Jobs spreadsheet module for Google Sheets

Performs the identical function of the All-PICKUPS Collector module, but displays them in a separate document in the cloud storage on Google Sheets ( Google Sheets ) - this is a description of the boards (sites with open data) that it collects and stores them in the database. The database is duplicated in parallel to the cloud storage on Google Sheets . It works automatically every 5-10 minutes, or by manual call from the Telegram channel. Organized in the form of a grid with horizontal rows with numbers 1,2,3...5000, etc. and vertical columns with names taken from open data sites: Organized as a grid with horizontal rows with numbers 1,2,3...5000, etc., and vertical columns with names taken from open data sites:

• Job No.: This column displays the unique job number assigned to each job posting.

• Type: This column displays the type of move associated with the job posting, such as residential or commercial.

• Move Date: This column displays the date of the move for each job posting.

• Win-dw: This column displays the window date for each job posting, which refers to the range of dates during which the move can take place.

• Time: This column displays the time of day for the move.

• 1st Avbl Delivery: This column displays the first available delivery date for the job.

• Moving From(City): This column displays the city from which the job will be moved.

• Fm: This column displays the state abbreviation for the city from which the job will be moved.

• From (ZIP): This column displays the ZIP code for the pickup location.

• Moving To(City): This column displays the city to which the job will be moved.

• To: This column displays the state abbreviation for the city to which the job will be moved.

• To (ZIP): This column displays the ZIP code for the delivery location.

• CF: This column displays the cubic feet required for the move.

• Lbs: This column displays the weight of the items being moved.

• Miles: This column displays the distance between the pickup and delivery locations.

• Estimate: This column displays the estimated cost of the move.

• Url: This column displays the URL of the job posting.

• Price Per Transportation: This column displays the price per transportation.

• Profit: This column displays the profit earned from the job.

• Pay for Cubs: This column displays the payment for cubic feet.

• Price /cub: This column displays the price per cubic feet.

• Trip: This column displays the trip number associated with the job posting.

• CHECK: This column is used to select multiple job postings for editing or deletion.

• Book TXT: This column is used to book the job posting via text message.

• Book email: This column is used to book the job posting via email.

• Add to Calendar: This column is used to add the job posting to a calendar.

Rows and columns intersect to form cells that contain data that was taken from the open data of the All-PICKUPS URL List Collector module. As a rule, columns and rows are filtered, which allows you to change their display according to the specified conditions of the User Filter. Such a filtering system allows users to easily refer to a specific job in the table by specifying its number, e.g. Job No, or other string parameters according to the filtering conditions.

To use the spreadsheet module, users can first scroll through the list of jobs to find the one they are interested in. Alternatively, they can use the filtering and search functions to narrow the list to jobs that meet their specific criteria. The rows and columns intersect to form cells that contain data that was pulled from open data All-PICKUPS URL Puller Module

Once a user has found a job they are interested in, they can click on the job number to view more information about it and check if it is still available for booking. They can also add the task to their calendar, send a booking notification via SMS or email, or mark the task as completed.

Overall, the spreadsheet module is a useful tool for users of the Moving Boards USA web application to view and filter available jobs, making it easier for them to find jobs that meet their specific needs.