u/DarkArctic88

​

Seeking independent contractor(s) to come help out a research project on a consistent basis.

Duties:

Cleaning plastic dishes and storage bins. Other opportunities exist after a trial period.

Ideal candidate

Punctual, consistent, responsible, able to follow direction, preferably available at least 4 hours a week.

Requirements:

must be 18 years old with some form of valid ID.

Must speak english fluently.

Must not have allergies, phobias, etc that interfere with your ability to perform your duties.

That's it! No experience necessary, no education required. Can you wash dirty dishes? Yes? You can do this.

We do not discriminate based on your race, gender identity, sexual orientation, immigration status, disability, etc. this is an inclusive environment.

Pay:

Pay is per item cleaned in addition to completion pay bonuses and a base pay rate of 7.25 an hour. So you get paid some for your time but more for how you spend it. The more you get done, the more you make. This payment structure allows you to work at your own pace, and gives you control over how much you can make. People report they prefer it to the traditional pay per hour schedule. The pay per item rate is negotiated on site because various items require varying time/effort to clean, but you have a say in setting the rate.

Work hours:

Make your own schedule. Quite flexible here, but we do need a heads up for when you're coming so we can let you into the gate. You'll want to come while there are still daylight hours left.

We provide:

Everything you'd need to complete your duties: electric scrubbing tools, commercial rinsers/sprayers, and PPE like gloves, aprons, ponchos. Bluetooth speakers available to play your own music. Ice water and bathroom available on site.

You'll need to provide:

Anything you might want to be more comfortable while doing so. Strongly recommend you bring a pair of rain boots, crocs, etc. as your feet will get wet. Sunscreen. Water bottle: we provide the water, you provide the container. You can bring your own food/water as well.

Should you need childcare, you'll need to make your own arrangements as no one under 18 is permitted on site.

Work Environment/Culture:

Entry level duties are performed outdoors. Crew is encouraged to come indoors every 2 hours to avoid heat exhaustion. Work space is gated with surveillance cameras. Quiet residential neighborhood.

This is a safe place to work, and it will stay that way. We will protect your privacy and expect the same in return. We value our drama free culture where everyone is safe to be themselves, and just come do honest work for honest pay. Everyone on hand at a time works beside each other including management. Our team is friendly to all walks of life and does not tolerate bullying. Simple as that. So if an inclusive work environment doesn't work for you, then you need not apply.

To apply:

If this sounds like it could be a good fit for you, dm me for the details and we'll go over the next steps.

Ok so im painfully new to javascript and im trying to get two automations going... on the same sheet of course,

The first task sorts the workbook into corresponding sheets and deletes the row as it moves. That one runs fine with the current code.

Im also trying to sort those sheets by multiple columns after the row is moved. Every sheet except one ... The only way ive been able to think to do that is to create a separate task for each of the sheets I need to sort and omit the one I do not.

Of course that ran me smack into the dreaded "multiple onEdit" problem. I was told you can get around it by bundling the tasks into one Onedit "main" and it should run subsequently.

Thing is, it runs the first task, then wont run any of the subsequent. Says "secondtask is undefined" during execution errors.

Ive seen others running with this same work around on youtube so im really not sure why mine doesnt work. I'm sure its a simple fix maybe but I cant seem to find an answer as to why the first task runs but not the second.

I ran it through a javascript validation and it says "parsing error unexpected token const" at line 29 which is

const sheetName = "Colony Maintenance";

Here's the full code, I put some notation in to make it easier to understand what i was trying to do.

Any help would be greatly appreciated!

function onEdit(e) { 
  firstTask(e);
  secondTask(e);
  thirdTask(e); 
  forthTask(e); 
  fifthTask(e); 
  sixthTask(e); 
} 


function firstTask(e) { 
let range = e.range;
let col = range.getColumn();
let row = range.getRow();
let val = range.getValue();
let source = e.source.getActiveSheet();


  if (col == 1 && val !=''){
   let ss = SpreadsheetApp.getActiveSpreadsheet();
   let sheet = ss.getSheetByName (source.getName());
   let targetSheet = ss.getSheetByName(val);
   let data = sheet.getRange(row, 1,1, sheet.getLastColumn()).getValues();


  targetSheet.appendRow(data [0]);
  sheet.deleteRow(row);
  }
 
//this is where the code stops working

function secondTask(e) {    
  //Change to the sheet you want to sort's name
    const sheetName = "Colony Maintenance"; 
    const sheet = e.source.getSheetByName(sheetName);
 
  // Only proceed if the edit happened on the target sheet
  if (e.source.getActiveSheet().getName() !== sheetName) return;

  // Define the range to sort (starting from row 2 to skip headers)
  const range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

  // Sort by multiple columns:
  // Priority 1: Column 1 (Ascending= a-z= true)
  // Priority 2: Column 3 (Descending= z-a =false)

  range.sort([
    {column: 11, ascending: true},
    {column: 3, ascending: true},
    {column: 7, ascending: true},
    {column: 6, ascending: true},
    {column: 8, ascending: true},
  ]);
  }

function thirdTask(e) {
    const sheetName = "Veterinary Care"; 
    const sheet = e.source.getSheetByName(sheetName);

  if (e.source.getActiveSheet().getName() !== sheetName) return;

  const range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

  range.sort([
    {column: 11, ascending: true},
    {column: 3, ascending: true},
    {column: 7, ascending: true},
    {column: 6, ascending: true},
    {column: 8, ascending: true},
  ]);
  }

function forthTask(e) {
    const sheetName = "Sales"; 
    const sheet = e.source.getSheetByName(sheetName);

  if (e.source.getActiveSheet().getName() !== sheetName) return;

  const range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

  range.sort([
    {column: 11, ascending: true},
    {column: 3, ascending: true},
    {column: 7, ascending: true},
    {column: 6, ascending: true},
    {column: 8, ascending: true},
  ]);
  }

function fifthTask(e) { 
    const sheetName = "Breeding"; 
    const sheet = e.source.getSheetByName(sheetName);

  if (e.source.getActiveSheet().getName() !== sheetName) return;

  const range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

  range.sort([
    {column: 11, ascending: true},
    {column: 3, ascending: true},
    {column: 7, ascending: true},
    {column: 6, ascending: true},
    {column: 8, ascending: true},
  ]);
  }

function sixthTask(e) { 
    const sheetName = "Home Life"; 
    const sheet = e.source.getSheetByName(sheetName);
 
  if (e.source.getActiveSheet().getName() !== sheetName) return;

  const range = sheet.getRange(2, 1, sheet.getLastRow() - 1, sheet.getLastColumn());

  range.sort([
    {column: 11, ascending: true},
    {column: 3, ascending: true},
    {column: 7, ascending: true},
    {column: 6, ascending: true},
    {column: 8, ascending: true},
  ]);
  }
}