CalendarApp | 📅 Sample calendar app created with CalendarKit | iOS library

I am coding a room booking system using combination of Google forms and Google calendar.

When there is a new booking order:

• An event will be automatically created on the selected calendar.
• An edit response URL will also be generated automatically and put in column 10 of the spreadsheet in the same row where the form answer was inserted.

I'm using react/express.

I have a simple webpage, which takes user input and stores this in SQL using axios.post. In my backend I need to access this user variable in my get, so I can filter what to send back to the user.

I have not been able to get the return function to work and I don't want to use global variables as it has caused errors before.

Is there something i'm missing? How can I access a variable from my get request from my post request.

frontend.js

This is the script I have now, taken directly from the video. It works to schedule the event. What I am trying to do though is to have cells in another column, that would contain emails, be automatically added to this event. Further, if at all possible, could I have a meeting link (Zoom, Teams, etc) in another cell to add that to the description?

'''

I'm not sure the question title is pretty clear, so I'll explain it better.

I have a spreadsheet I'm working on which is basically a template just for checking financial data. Even with full info copied from the original Excel file, the script only gets 4 cells to work with, which are the highlighted ones.

The first one (C3) is the client's name. The second one (C9) is how many days after the delivery date the payments are due, and if it's 2 or more payments, it is split with a /. Then, we have the delivery date on F11, and the total value on H25.

Everything I needed to do was quite easy to do, even integrating with Google Calendar to register different payments depending on the client. What I have here is the =split() of C9 in A26:26, the sum of the split cells with the delivery date right below, and the division of the total amount by the count of payments.

Then I used =transpose() to create a new matrix to properly send this data to my Google Calendar.

That said, it's kind of obvious I'm working mostly with formulas and references. What I can't seem to do now is to get the divided payment values and order them in a second sheet according to the payday. I don't need the client's name or anything, just sort the payment's values of different clients into columns (or rows, whatever is easier to accomplish), so I can have the total for that day.

So I need to somehow scan trough the dates and then down the rows to add them - pretty much like I already did with the Calendar - but to sum up the total value for that day, which can change in the event of a new order, so I guess using the second row for the sum and starting from row 3 would be the best case. (Also, notice that not all values are present here, since I have every day, one by one, in the sheet, so for this example the 5th of June is there, only not in the screencap).

Assume that I have the case above, with those four payments. If I have a new order, it would then look like this on the template:

And on the other sheet, it would keep the old data from the first example and include the new data, summing up the payments' values, like so:

This way, the new data could be entered below the previous one, or above by creating a new row. Doesn't realy matter which.

It could be done in a static way, so to speak, never removing days already gone, on dynamically, always updating the first day acording to =today() or a new Date(), which I guess is way more complicated to do.

I forgot to mention that for every order, there is a new spreadsheet, which I'll just copy into this template. The new sheet with the expected results is just this one for every entry, so I'll need a special paste for values only as well.

Here is the full copy of the Spreadsheet with the script, except the Calendar ID.

I am very new to Script editing. I have a Spreadsheet from a source online that I replicated in order to add events for students.

I want to be able to add the Description and then change the event color depending on the class. The script that I am using is copied below. I don't know how to add in the description and color ID for the event.

Goal: Add attendees through Google Calendar Add on to live event being created on the spot

Context: Live Event being created (left)+ Calendar Add on (Right)

Code snip:

I wrote this function to bring spreadsheet entries into my calendar. As you see, now I take all entries in the range B5:B30. If I do not fill in all cells in this range, I get an error as my parameters are wrong.

Now if I would be able to only take the values from this range that are not empty, I think all would work. Is there a way to drop empty cells from my range or only execute the getValue() and save it in my definition of signups if there is a value?

I am trying to add an event to Google Calendar, and I am not getting an event added when doing so. I am sure the code is working around it. Does anyone have any ideas why an event is not being added to the calendar?

I would add the entire code, but I feel like it misses the point.

It appears I'm missing something fairly obvious in trying to automatically copy all events from one google calendar to another. Others don't want access to the source calendar, so it goes.

Below what doesn't work, as a kick-off.