Google Appscript – CalenderApp, create events from a spreadsheet and write relevant ids back to the spreadsheet

I have a function to create events for field based workers. Eventually I will add this to an onEdit trigger and give the user (centrally based admin worker) some functionality to edit/delete events after they have been created. To do the latter, I believe I will need to be able to isolate the event ID.

Whilst I can write events to a calendar and retrieve the event ID and index of the event just created. I am having difficulty in writing that information back to the spreadsheet (this would be used for edit/delete later in my program).

ws.getRange(4,13,indexes.length,1).setValues(eventIds); allows me to write ids to the spreadsheet but they are not writing to the correct row where the event was created.

How can I use the index stored in const indexes = (); to tell the function the correct row to write the id to. Or is there a better way to achieve this?

Any help would be amazing, I am still very much in the learning stage with Google Appscript. I have tried to research the problem to no avail and I was hoping that the wisdom of others might be able to show me where I am going wrong.

function createEvents(){

const ss = SpreadsheetApp.getActiveSpreadsheet();
const ws = ss.getSheetByName("Sheet Name");
const lr = Math.max.apply(0, ws.getRange('b:b').getValues().map(function (v, i) { if (v != '') { return i } else { return 0 } })) + 1;
const lc = ws.getLastColumn();
const cal = CalendarApp.getCalendarById("myCalId");

const allData = ws.getRange(4,2,lr-3,lc).getValues();
const eventIds = ();
const indexes = ();


const startDate = new Date(r(4));
const sDateHrs = startDate.setHours(8,0);
const endaDate = new Date(r(6));
const eDateHrs = endaDate.setHours(18,0);

if(r(10) === true && r(7) === 'In Progress'){

  var event = cal.createEvent(r(0), new Date(sDateHrs), new Date(eDateHrs), {location: r(1), description: r(3) });  
  var eventId = event.getId();

  eventIds.push((eventId));//pushing event ids to an array to call on later
  indexes.push((idx));//pushing the index of each id to use when writing the ids back to the spreadsheet

  ws.getRange(4,13,indexes.length,1).setValues(eventIds); //places event ids into spreadsheet but not in the correct rows. I want the ids to be written to rows corresponding to the indexes array

  return event;}});


Is Luxy CBD Gummies Still Relevant?

Bears aren’t only your tacky standard CBD for a similar explanation. They have put forth an admirable attempt to refine their recipe and make them the most scrumptious chewy confections accessible. That, nonetheless, is normally strong, made to be made of 100% reasonable resources. CBD Chewy Candies are delectable and an exceptional technique should be clung to get your full scope of CBD. The concentrate has been made to ensure 100% bioavailability. It packs in the entirety of the…

Read more

I will do 80 nofollow niche relevant blog comments for $5

I will do 80 nofollow niche relevant blog comments

Quality is always better than Quantity . Only live links will be counted at the time of delivery.

Hello I am jahanghir55,

Are you thinking of getting comments backlink for your blog, page or web site in a manual way?

Are you looking for Niche relevant nofollow high quality blog comment backlinks? If so, please stop here:

Niche relevant blog comments is one of the prettiest ways of getting huge organic traffic and ranking targeted keywords. It will also help enrich your site’s links juice to google link profile

Benefits of ordering my service:

  • Niche Relevant Commenting.
  • Links are NO-Follow.
  • Google Index Guaranteed.
  • No Spamming.
  • 100% Manual Work.
  • Genuine Traffic.
  • Deliver Work on time.
  • Satisfaction Or Guaranteed.

Note: ADULT, PORN, GAMBLING, CASINO, DATING, DRUGS, or any other illegal ACTIVITY NICHE ARE NOT ACCEPTED. (otherwise, we will not refund, and you will not get any report).
If you have any questions Ping me.


Is the transaction size relevant if fee per byte is the same?

Is the size of the transaction some factor when the miner chooses one transaction over the other, provided that they both have the same fee per byte?

In other words, will the miner prefer larger or smaller transactions if they all have the same fee per byte?

python – Is this a good approach to stop an API function and return relevant error message?

I am writing an API function using DRF where I want the API execution to stop if it fails in any of the steps and return an appropriate response. So I created a custom exception which takes an error code, and an error message like below.

class CustomException(Exception):
def __init__(self, status, msg):
    self.status = status
    self.message = msg
    super().__init__(self.message + ': ' + str(self.status))

And I came up with the below code structure for the API function,

def place_order(request):
    err_msg = 'Problem in placing order. Please contact us'
        response = is_cart_empty()
        if response.status == 0:
            err_msg = 'Cart cannot be empty'
            raise CustomException(0, err_msg)

        # Do something...

        response = is_valid_user()
        if response.status == 0:
                err_msg = 'User is not valid'
                raise CustomException(0, err_msg)

        # Do something...

        response = is_product_available()
        if response.status == 0:
            err_msg = 'Product out of stock'
            raise CustomException(0, err_msg)

        # Do something...

        response_data = {
            'status': 1,
            'order_id': '1235'
    except CustomException as e:
        response_data = {
            'status': e.status,
            'error_message': e.message
    except Exception as e:
        response_data = {
            'status': 0,
            'error_message': err_msg
    return Response(data=json.dumps(response_data), status=status.HTTP_200_OK)

Is this is a good design approach ? What better approach can I adopt to make it more efficient and robust ?

I will do 100 Niche relevant Blog Comments Seo Backlinks for $5

I will do 100 Niche relevant Blog Comments Seo Backlinks

create 100 niche relevant blog comments seo backlinks

seoclerk Super gig is Offering Bluster Niche relevant backlinks Package that will help you to shoot your Website Ranking on Search
engines (starting price just for 5$)

If you need Niche Relevant Blog Comments then, you are at the right place. There is no Spammy Work. I will Submit High Quality Backlinks via Blog Comment On Your Niche. I am Sure that you’ll like my Work. I won’t create any Problem For you.

Why Choose my Service?

  • Infinite URLs And KeyWords accepted.
  • All NICHES are Accepted except Gambling and Porn or Adult.
  • Links are NO-Follow.
  • Satisfaction Or Guaranteed.
  • 100% Manual Work.
  • No Spammy Work.
  • Deliver Work on time.
  • Providing High Quality Work.



http – Is there a tool to test if my web server follows relevant RFCs?

Is there a tool to test if my web server follows relevant RFCs?

So, I create a web server my self. And I want to know if I had made any mistake in following the RFCs. It would be too hard to test stuff just using telnet and openssl s_client.

So, if there is a tool that requests the web server with requests that are not valid, and tells me if there are situations where my web server doesn’t follow rules, or returns invalid HTTP responses.

I will Provide You Niche Relevant 20 Quora answer’s for promote your Website for $10

I will Provide You Niche Relevant 20 Quora answer’s for promote your Website

I’ll promote your website with Quora Answer by different account.

If you want to promote your website or products then I’ll help you. I Post answer On Quora for long-time. So, I can give you a more unique and high-quality quora answer and promote your website or brand.

Stop thinking and wasting your time that how grow the brand or website ! I can assure you that you are in the right place.

My Service Specialties:

1.All answer will post manual and my answer will never delete.

2. I used website URL in every answer with your keyword.

3. All links will turn into Clickable backlinks.

4. Fast delivery before Deadline order.

5. Give you complete Excel report.

Frequently Asked Questions.

Qus:- Will Quora delete my website URL?

Ans:- No, Because Quora never delete URL from a quality answer. And if you will face this kind problem later then you have to just

knock me, I will fix that soon.

Qus:- Are you answer for the youtube video?

Ans:- Yes , sure.

Qus:- Do you write a long answer? like 500,700 or 1000 words?

Ans:- Yes. If you want 500 or 700 or 1000 words (any amount accepted) answer then contact me before placing the order.

Qus:- Do you accept illegal, Cryptocurrency link or adult porn or drugs related websites?

Ans:- No. I don’t.


1000+ High Authority Powerful Niche Relevant Wiki Backlinks To Boost Website Rankings for $3

1000+ High Authority Powerful Niche Relevant Wiki Backlinks To Boost Website Rankings

Wikipedia is one of the biggest, oldest and most authoritative websites on the internet which makes Wikipedia backlinks one of the most powerful links on the planet.

Wikipedia has such a super high Domain Authority, trust flow and citation flow that it affects your rank positively just by virtue of being connected. If you could get a backlink from the site, your SEO will soar.

With the superb quality and relevancy of the content that we create for the wiki pages that contain your backlink. All in all you are really in for a major Search Engine Optimization boost.

My Service Features:

  • 1000+ Panda safe Contextual and Unique Links from Wiki Sites.
  • Domains have high Page Rank up to PR8
  • 100% Verified live links.
  • Backlinks will be submitted on wiki articles pages
  • Each article will have 3 backlinks for your website
  • Article spinner before submitting.
  • Mix platforms backlinks including profiles, contextual, …etc.
  • Rank higher in Google
  • Improve your website visibility and brand exposure
  • Boost your website authority and credibility
  • Multiple links/keywords accepted for each order
  • Full details reports including each created links/accounts

Achieve better search results now!



build da 30 plus dofollow niche relevant pbn backlinks for $10

build da 30 plus dofollow niche relevant pbn backlinks

Looking to buy pbn backlinks? Buy pbn links from us. We provide DA30+ Niche Relevant sites with Unique Content.

You have a website. You want it to rank. But every time you buy pbn links

online, you’re highly disappointed. A few hundred dollars later you see

zero movement in the SERPs. Ranking in Google isn’t hard. All you need

is a healthy number of backlinks from a healthy number of referring

domains that have authority and trust in Google’s eyes.

We Can Help With That…

That’s why we decided to build our own private blog networks so we could

control the quality of our site – from the sites we linked to, to the

content we used and even the total number of links on an individual


We ranked consistently in the Top 3 Spots of Google for dozens of high-value, commercial keywords. You can take advantage

of our highly refined process for building high quality, powerful

private blog networks without the hassle, headache and expense of doing

it all yourself!Our PBN links for sale are based on the most important factor that actually matters when you want to push your site up in the rankings.

Order Now, 100% Satisfaction Guaranteed.