Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

242
Views
Apps Script: SubFunctions of my library not showing

community.

I have a stand-alone apps-script file called 2022 Journiq that reads, format and set values to/from many sheets. It works fine. But stand-alone files can't work with onEdit(e), so:

  • I created a file bounded to the sheet I want events to be triggered, called Forms;
  • I created a library of 2022 Journiq ('cause many videos and forums told me so) and it worked fine, as well;

The problem is that when I do myLibrary.whateverFunc().whateverSubFunc(), I don't receive the completions, so I have to remember all function names by heart??

  • I've had this problem before, but it was a simple return mistake. This is not the case, because apps-script displays the list of subFunctions in 2022 Journiq, but not in Forms;
  • All my functions are public, which means there are no privFunc_;
  • All subFunctions are not showing;

Here follow my attempt:

const {getMySpreadsheets} = JourniqAutomation // << my library

function doSomething(e){
  const eClass    = getMySpreadsheets() // << when I type '.' no functions appear
}

This is inside 2022 Journiq

function getMySpreadsheets(){
  this.access            = (id) => SpreadsheetApp.openById(id)
  this.getSpreadSheet01  = (  ) => this.access ('*****');
  this.getSpreadsSheet02 = (  ) => this.access ('*****');
  return this
}  

I was about to deploy it as a private add-on to check if it solves the problem, but it seems like a complicated process for me, so the question still remains: why does the Subclasses of my library won't show?

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!