# Feeling Awesome with the JavaScript Column! - Thanks Glide
**URL:** https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373
**Category:** Ask for Help
**Created:** [July 27, 2022, 6:56pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373 "2022-07-27T18:56:18Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [July 27, 2022, 6:56pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/1 "2022-07-27T18:56:18Z")
Hello Community,
How are you’ll everyone? I hope you all are fine!
I’m just experimenting the JavaScript column with some codes while I’m creating Apps and Pages in Glide and thought to share them with you’ll and correct the codes if I’m wrong in somewhere!
* * *
This is my first attempt! :
Getting the Timezone of the device!
This is the code :
```auto
var first = (new Date().toTimeString().slice(9));
var second = (Intl.DateTimeFormat().resolvedOptions().timeZone);
var third = (new Date().getTimezoneOffset() /-60);
var full = first + "," + '\xa0' + second + "," + '\xa0' + third;
return full;
```
* * *
My second attempt ( Part 1 ) :
First Name, dot and Last Name
This is the code :
```auto
var first_name = p1;
var first_name_in_capital = first_name.charAt(0).toUpperCase() + first_name.slice(1);
var last_name = p2;
var last_name_in_capital = last_name.charAt(0).toUpperCase();
var Name = first_name_in_capital + "." + last_name_in_capital;
return Name;
```
* * *
My second attempt ( Part 2 ) :
First Name, Last Name and dot
This is the code :
```auto
var first_name = p1;
var first_name_in_capital = first_name.charAt(0).toUpperCase() + first_name.slice(1);
var last_name = p2;
var last_name_in_capital = last_name.charAt(0).toUpperCase();
var Name = first_name_in_capital + "\xa0" + last_name_in_capital + ".";
return Name;
```
* * *
My third attempt :
Get the first letter in a word.
This is the code :
```auto
var value = p1;
var first_letter = value.charAt(0);
return first_letter;
```
When adding these codes add the columns for p1 or p2 or p3 and sometimes two or all!
And also I’m still learning JS in school and not have a much knowledge with it 🤓 If I’m wrong in somewhere please let me know 🙌
I will update this post once I found new things! 🙌
Thanks for reading!
Have a great day!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [July 27, 2022, 8:03pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/2 "2022-07-27T20:03:49Z")
Nice choice in sample data. 😉
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [July 27, 2022, 8:49pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/3 "2022-07-27T20:49:50Z")
Welcome to the Code world!! 💪
---
### Author:  [@11183](https://community.glideapps.com/u/11183)
#### Post date: [July 27, 2022, 8:58pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/4 "2022-07-27T20:58:40Z")
I started digging into js all thanks to this column) It’s a wonderful feeling when your function finally works!)
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [July 28, 2022, 12:50am UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/5 "2022-07-28T00:50:30Z")
> This is the code :
```auto
var value = p1;
var first_letter = value.charAt(0);
return first_letter;
```
If you want to have a smaller/faster code, you just need to type …
`return p1.charAt(0) `
Saludos y sigue aprendiendo! 💪
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [July 28, 2022, 1:08am UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/6 "2022-07-28T01:08:51Z")
One of my favorite types of columns. Allows me to transform data in a variety of ways!
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [December 28, 2022, 4:14pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/7 "2022-12-28T16:14:03Z")
Oh man! JavaScript is so powerful!!! 💪 🤩
My fourth attempt :
Get the first and last name from a text column without a split text column 🤯
The code :
> **First Name**
>
> ```auto
> const fullName = p1;
> const [first, last]= fullName.split(' ');
> return first;
>
> ```
> **Last Name**
>
> ```auto
> const fullName = p1;
> const [first, last]= fullName.split(' ');
> return last;
>
> ```
Cheers for Glide and JavaScript 🥂 ❤
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [December 28, 2022, 4:48pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/8 "2022-12-28T16:48:53Z")
If you want to save some typing, you could do:
```auto
return p1.split(' ')[0]; // first
return p1.split(' ')[1]; // last
```
Although, that would fail (as would your solution) if there happened to be extra spaces between the two names. So a slight improvement on that would be:
```auto
return p1.split(/\s+/)[0]; // first
return p1.split(/\s+/)[1]; // last
```
And then of course you might have folks that also have a middle name. So to make sure you get their _actual_ last name, and not their middle name, you might do something like this:
```auto
return p1.split(/\s+/).pop(); // last
```
That’s probably far enough down the rabbit hole for now 😉
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [December 28, 2022, 4:53pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/9 "2022-12-28T16:53:55Z")
You are becoming a coder! We might be able to call this the Thinh phenomenon: the more you nocode, the more inclined you are to code.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [December 28, 2022, 4:57pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/10 "2022-12-28T16:57:10Z")
Awesome! Thanks Darren! Very much appreciated! I’m still learning about this powerful programming language and thanks for helping me to learn it better!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 29, 2022, 12:04am UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/11 "2022-12-29T00:04:53Z")
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [February 26, 2023, 5:10pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/13 "2023-02-26T17:10:18Z")
Let’s start this by giving a **BIG CHEER FOR _JavaScript_**! 🥳
Give me a _ **J** _ → **J**
Give me a _ **a** _ → **a**
Give me a _ **v** _ → **v**
Give me a _ **a** _ → **a**
* * *
Give me a _ **S** _ → **S**
Give me a _ **c** _ → **c**
Give me a _ **r** _ → **r**
Give me a _ **i** _ → **i**
Give me a _ **p** _ → **p**
Give me a _ **t** _ → **t**
* * *
_My Fifth Attempt ( 1st advance code that I wrote by my own with some help in other coder’s codes 😋 )_
**Getting the Sundays as dates of a month!**
1st One :
Get the Sundays as dates of the current month with commas!
> **JS Code**
>
> ```auto
> var d= new Date();
> var dd= d.setMonth(d.getMonth() , 2 );
> var dd = d.toISOString().slice(0, 10);
> var year = d.getFullYear();
> var month = d.getMonth() + 1;
> var d= new Date(year,month,0);
> var n = d.getDate();
> var d = new Date(dd);
> var Sunday = new Date(dd);
> Sunday.setDate(d.getDate() - (d.getDay()||7) +7);
> var get_sunday_date = Sunday.getDate();
> var a = (Sunday.getDate());
> var b = (Sunday.getDate() + 7);
> var c = (Sunday.getDate() + 7 + 7);
> var d = (Sunday.getDate() + 7 + 7 + 7);
> var e = (Sunday.getDate() + 7 + 7 + 7 + 7);
> var get_sunday_month = Sunday.getMonth() + 1;
> if (get_sunday_month < 10) {
> var get_sunday_month = "0" + (Sunday.getMonth() + 1);
> } else {
> var get_sunday_month = Sunday.getMonth() + 1;
> }
> var get_sunday_year = Sunday.getFullYear();
> if (a < 10) {
> var a = "0" + a;
> }
> if (b < 10) {
> var b = "0" + b;
> }
> var a = get_sunday_year + "-" + get_sunday_month + "-" + a;
> var b = get_sunday_year + "-" + get_sunday_month + "-" + b;
> var c = get_sunday_year + "-" + get_sunday_month + "-" + c;
> var d = get_sunday_year + "-" + get_sunday_month + "-" + d;
> var e = get_sunday_year + "-" + get_sunday_month + "-" + e;
> var f = (Sunday.getDate() + 7 + 7 + 7 + 7)
> if (f > n) {
> var all = a + "," + b + "," + c + "," + d;
> } else {
> var all = a + "," + b + "," + c + "," + d + "," + e;
> }
> return all
>
> ```
> **Preview**
>
> 
> 
* * *
2nd One :
Get the Sundays as dates of the current month with spaces!
> **JS Code**
>
> ```auto
> var d= new Date();
> var dd= d.setMonth(d.getMonth() , 2 );
> var dd = d.toISOString().slice(0, 10);
> var year = d.getFullYear();
> var month = d.getMonth() + 1;
> var d= new Date(year,month,0);
> var n = d.getDate();
> var d = new Date(dd);
> var Sunday = new Date(dd);
> Sunday.setDate(d.getDate() - (d.getDay()||7) +7);
> var get_sunday_date = Sunday.getDate();
> var a = (Sunday.getDate());
> var b = (Sunday.getDate() + 7);
> var c = (Sunday.getDate() + 7 + 7);
> var d = (Sunday.getDate() + 7 + 7 + 7);
> var e = (Sunday.getDate() + 7 + 7 + 7 + 7);
> var get_sunday_month = Sunday.getMonth() + 1;
> if (get_sunday_month < 10) {
> var get_sunday_month = "0" + (Sunday.getMonth() + 1);
> } else {
> var get_sunday_month = Sunday.getMonth() + 1;
> }
> var get_sunday_year = Sunday.getFullYear();
> if (a < 10) {
> var a = "0" + a;
> }
> if (b < 10) {
> var b = "0" + b;
> }
> var a = get_sunday_year + "-" + get_sunday_month + "-" + a;
> var b = get_sunday_year + "-" + get_sunday_month + "-" + b;
> var c = get_sunday_year + "-" + get_sunday_month + "-" + c;
> var d = get_sunday_year + "-" + get_sunday_month + "-" + d;
> var e = get_sunday_year + "-" + get_sunday_month + "-" + e;
> var f = (Sunday.getDate() + 7 + 7 + 7 + 7)
> if (f > n) {
> var all = a + "\n\n" + b + "\n\n" + c + "\n\n" + d;
> } else {
> var all = a + "\n\n" + b + "\n\n" + c + "\n\n" + d + "\n\n" + e;
> }
> return all
>
> ```
> **Preview**
>
> 
> 
* * *
3rd One :
Get the Sundays of the selected date’s month with commas!
> **JS Code**
>
> Same but connect the date column to the JavaScript column with p1! So need to select the Date column for p1 and add p1 in the start of the code inside newDate() brackets!
>
> ```auto
> var d= new Date(p1);
> var dd= d.setMonth(d.getMonth() , 2 );
> var dd = d.toISOString().slice(0, 10);
> var year = d.getFullYear();
> var month = d.getMonth() + 1;
> var d= new Date(year,month,0);
> var n = d.getDate();
> var d = new Date(dd);
> var Sunday = new Date(dd);
> Sunday.setDate(d.getDate() - (d.getDay()||7) +7);
> var get_sunday_date = Sunday.getDate();
> var a = (Sunday.getDate());
> var b = (Sunday.getDate() + 7);
> var c = (Sunday.getDate() + 7 + 7);
> var d = (Sunday.getDate() + 7 + 7 + 7);
> var e = (Sunday.getDate() + 7 + 7 + 7 + 7);
> var get_sunday_month = Sunday.getMonth() + 1;
> if (get_sunday_month < 10) {
> var get_sunday_month = "0" + (Sunday.getMonth() + 1);
> } else {
> var get_sunday_month = Sunday.getMonth() + 1;
> }
> var get_sunday_year = Sunday.getFullYear();
> if (a < 10) {
> var a = "0" + a;
> }
> if (b < 10) {
> var b = "0" + b;
> }
> var a = get_sunday_year + "-" + get_sunday_month + "-" + a;
> var b = get_sunday_year + "-" + get_sunday_month + "-" + b;
> var c = get_sunday_year + "-" + get_sunday_month + "-" + c;
> var d = get_sunday_year + "-" + get_sunday_month + "-" + d;
> var e = get_sunday_year + "-" + get_sunday_month + "-" + e;
> var f = (Sunday.getDate() + 7 + 7 + 7 + 7)
> if (f > n) {
> var all = a + "," + b + "," + c + "," + d;
> } else {
> var all = a + "," + b + "," + c + "," + d + "," + e;
> }
> return all
>
> ```
> **Preview**
>
> 
>
> 
> 
* * *
4th One :
Get the Sundays of the selected date’s month with spaces!
> **JS Code**
>
> Same but connect the date column to the JavaScript column with p1! So need to select the Date column for p1 and add p1 in the start of the code inside newDate() brackets!
>
> ```auto
> var d= new Date(p1);
> var dd= d.setMonth(d.getMonth() , 2 );
> var dd = d.toISOString().slice(0, 10);
> var year = d.getFullYear();
> var month = d.getMonth() + 1;
> var d= new Date(year,month,0);
> var n = d.getDate();
> var d = new Date(dd);
> var Sunday = new Date(dd);
> Sunday.setDate(d.getDate() - (d.getDay()||7) +7);
> var get_sunday_date = Sunday.getDate();
> var a = (Sunday.getDate());
> var b = (Sunday.getDate() + 7);
> var c = (Sunday.getDate() + 7 + 7);
> var d = (Sunday.getDate() + 7 + 7 + 7);
> var e = (Sunday.getDate() + 7 + 7 + 7 + 7);
> var get_sunday_month = Sunday.getMonth() + 1;
> if (get_sunday_month < 10) {
> var get_sunday_month = "0" + (Sunday.getMonth() + 1);
> } else {
> var get_sunday_month = Sunday.getMonth() + 1;
> }
> var get_sunday_year = Sunday.getFullYear();
> if (a < 10) {
> var a = "0" + a;
> }
> if (b < 10) {
> var b = "0" + b;
> }
> var a = get_sunday_year + "-" + get_sunday_month + "-" + a;
> var b = get_sunday_year + "-" + get_sunday_month + "-" + b;
> var c = get_sunday_year + "-" + get_sunday_month + "-" + c;
> var d = get_sunday_year + "-" + get_sunday_month + "-" + d;
> var e = get_sunday_year + "-" + get_sunday_month + "-" + e;
> var f = (Sunday.getDate() + 7 + 7 + 7 + 7)
> if (f > n) {
> var all = a + "\n\n" + b + "\n\n" + c + "\n\n" + d;
> } else {
> var all = a + "\n\n" + b + "\n\n" + c + "\n\n" + d + "\n\n" + e;
> }
> return all
>
> ```
> **Preview**
>
> 
>
> 
> 
> **A Video to show the preview of 3rd and 4th one's**
>
> [Get the Sundays of the selected date's month - Preview.mp4 - Google Drive](https://drive.google.com/file/d/1p5V1-Td2w-6oTGjjwz4Ts69sFL9xDzzN/view?usp=share_link)
* * *
Hope to write more advance codes like these in future!
As always, JavaScript Gurus let me know if I have done something wrong or modifies! 🙌
Lastly let’s give a **Huge Clap for _JavaScript & Glide_**! 👏 👏
Thank you and Have a great day!
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [March 16, 2023, 4:05pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/14 "2023-03-16T16:05:41Z")
Oh man… I’m speechless at the moment! 🤐
Glide + JavaScript column = 🔥 🔥 🔥
* * *
_My Sixth Attempt_
Built a simple calendar that shows the dates with week day name of the current month or selected month and the current date is highlighted!
Check it by here : [https://simple-calendar.glide.page](https://simple-calendar.glide.page)
Will share a video and the JS Code(s) shortly!
Have a great day!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 17, 2023, 1:01am UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/15 "2023-03-17T01:01:40Z")
I assume you should see something under the buttons, but I’m not seeing anything.
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [March 17, 2023, 6:15am UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/16 "2023-03-17T06:15:19Z")
Thinh, you should see the dates. Can you try again?
And thanks for checking it!
---
### Author:  [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [March 17, 2023, 12:35pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/17 "2023-03-17T12:35:09Z")
Empty here
---
### Author:  [@CouscousOps](https://community.glideapps.com/u/CouscousOps)
#### Post date: [March 17, 2023, 1:03pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/18 "2023-03-17T13:03:55Z")
Thank you for sharing and documenting this 🙌
I keep trying to learn js and I don’t know keep getting stuck. Maybe learning from the Glide community has been the key I’ve been missing in my attempted learnings.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 17, 2023, 2:04pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/19 "2023-03-17T14:04:19Z")
Seems like it’s working on my end, but we’re lacking a 1-2-3-4-5 row?
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [March 17, 2023, 3:17pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/20 "2023-03-17T15:17:29Z")
Thinh & Eric , could you guys check the app again?
---
### Author:  [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [March 17, 2023, 3:21pm UTC](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373/21 "2023-03-17T15:21:28Z")
Your welcome, Rachel! I couldn’t do this without the legends in this forum! Thanks Everyone! 💪 🎉
> [@CouscousOps](#):
>
> Maybe learning from the Glide community has been the key I’ve been missing in my attempted learnings.
And yes, this is actually true. I have learned so many things from these talented humans! Saying thanks again for them!
[Next page](https://community.glideapps.com/t/feeling-awesome-with-the-javascript-column-thanks-glide/45373.md?page=2)