Profile cover photo
Profile photo
Leo Saumure
16 followers
16 followers
About
Communities and Collections
View all
Posts

Embarking on a journey.

Ok, stay with me on this, as it may be a bit long and confusing. Here is what I would like to do:

Short version: Use Google Sites and Google Sheets to create a self-service training portal for our interpreters.

Here is how I envision it working:

1. I will have one un-shared sheet, called MasterCPD, that has all the required data with EVERYONE'S training information.

2. On a regular basis, I would run a script that will extract the data from my un-shared sheet and append it to each interpreter's personal sheet, which only displays their data.

The script would need to:

a. Determine if there is an existing sheet for each interpreter.
b. If not, the script needs to:
i) create a sheet for that interpreter and place it in a particular Drive folder
ii) Share that newly created sheet with the interpreter
iii) Format the sheet to my specification
iv) Append the interpreter's data from my sheet to the interpreter's sheet.

c. If the interpreter's sheet already exists, the script will need to append the interpreter's data from my sheet to the interpreter's sheet.


I am very new to Google Apps Script, so I am wondering about any pitfalls I may run into before embarking on this journey. For example, let's say, for argument's sake, that Apps Script has no method for sharing documents via script; I'd hate to get half way through and find out what I want is impossible.

I'd would love some expert advice and pointers from the community as I get into this.

Thanks!

Post has attachment
Add a comment...

Post has attachment
It is expected that trained interpreters are familiar with medical terminology.  However, the large number of medical terms presents a challenge to interpreters. Apart from this, many times interpreters have to deal with situations where languages differ in the way medical terms are formed or medical procedures and protocols are carried out...
Add a comment...

Post has attachment
It is expected that trained interpreters are familiar with medical terminology.  However, the large number of medical terms presents a challenge to interpreters. Apart from this, many times interpreters have to deal with situations where languages differ in the way medical terms are formed or medical procedures and protocols are carried out...
Add a comment...

Post has attachment
It is expected that trained interpreters are familiar with medical terminology.  However, the large number of medical terms presents a challenge to interpreters. Apart from this, many times interpreters have to deal with situations where languages differ in the way medical terms are formed or medical procedures and protocols are carried out...
Add a comment...

Hi Everyone,

After exhausting my google searching, I am now asking the community. Can I populate a list page with values via google apps script?

I would have thought you could, but I'm not sure.

So assuming my site is called portal, and assuming my list page is called cpu-invoice, and finally assuming my two columns for the list pages a: Invoice Number and Link.

Now, let's say I wanted to add Invoice Number: 88888 and the link as: www.google.com

I thought I could simply modify the code provided on the Developer's Reference site: See example below:

var page = SitesApp.getSite("portal").getChildByName("cpu-invoice");
 var listItem = page.getListItems()[0];
 listItem.setValueByName("88888", "www.google.com");

When I try this code however, I get a message about the listItem as a null value.

First: Can you populate the list via code?
Second: Where am I going wrong?

Thanks,

Post has attachment

Best way to deal with a noisy PC exhaust fan?

Don't fiddle with tightening the screws. Don't replace the fan only to find it still rattles...simply turn the PC upside-down.

This helpful tip was provided by Derp! 
Add a comment...

After running into some support issues with Gravity Forms (not entirely their fault), we decided to use a different service. #Jotform seems to be pretty impressive so far!
Add a comment...

Post has attachment
This seems like a great product in what it can deliver. Here in Wellington, the streets can be incredibly narrow and, depending where you are, quite dark. To compensate, many cyclists use reflective vests, a VERY bright strobe headlight as well as back flashers to help with visibility.

Most of this is great except for the strobe headlights as they can blind or seriously distract the driver, even during the day and even in the rear view mirror.

This paint could light up the cyclist like a christmas tree, but it wouldn't blind the driver as the headlights do. I'd love to see this product come to NZ.
Add a comment...
Wait while more posts are being loaded