Going step by step, through a clearly explained, trial and error approach has helped me so much with my programming. You are a great teacher! Thank you so much for your contributions sir!
Hello! Please show us a code from which we can send text sms messages or whatsapp messages on submit of a form :) Would be a great help... Really love your videos it's very helpful! Thank you !
Hello, I keep getting the error "Cannot read the property 'Name' of undefined" any thoughts to why I might get this error using line for line the code you're creating?
Mannn! You're amazing. So much love for your work here on the channel. Do you think about allowing the "Join" function here on the channel so we can support your work? I would be glad to support your work.
You're great, but I'm too late. I need this facility now. But the google is restricting first line Code: "creatcontact" it is showing like this " -creatcontact- . How can I overcome this. Help me in this regard.
Thanks for another amazing video tutorial. I was wondering about how to add a label to the new contact. I've tried to do it but I haven't found the way.
@@ExcelGoogleSheetsThanks for your answer. It's a kind of category you can assign to each contact. In fact, contacts can have more than one category, in this case, labels. I don't know if I can send a picture here. drive.google.com/file/d/1jvBwhU8vP-7lOsvVv4BHFgc-BqiAUyHm/view?usp=sharing The picture I shared shows, in reality, two pictures, the first one, we see the contact and just under the name, you see "no label" which means that I haven't assigned any labels to the contact. and the second picture shows the labels I have created. It allows me to have my contacts in order.
@@ExcelGoogleSheets a label you can organize the people and businesses in Contacts using labels. You can use the Contacts app to find someone's contact info or organize contacts with labels like "friends" or "family." Could you do one to show us?
I congratulate you for your contribution to the community, I have a question, why do you use the CONST reserved word in the variables instead of using the LET or VAR reserved words?
const is a type that can not be redifined within the block. For example, this will give you an error, since x must remain 5 within this block. { const x = 5; x = 6; }
Thanks for sharing. Is it possible in a form the user put I'd number and then in the form show his name looking on a database or sheet ? And then the user continues filling data of the form? Thanks for any suggestions
Well, I'm not exactly sure this solves the issue or not.... I'm populating contacts just fine, but when I go Google Voice to send a SMS, the contacts in Voice haven't updated. I've noticed a difference between the computer interface and tablet interface. I left the tablet in my locker at work.... sigh.....
This is a great video I was looking for a script that could automatically save contacts from my Google sheets to my Google contacts once a new column is filled A new row in the Google sheet gets automatically filled from my Elementor form once a new sign up submits his/her details Kindly note that the sheet contains First name, Last name, phone number, email I would appreciate a tutorial that could explain how automate creating a new contact (name, phone number and email) on my Google contact successfully. Thanks
Hello there! Do you know if it's possible to add the picture on the contact via Apps Script? I'm building an employee form where I ask the user to submit a picture and I want my code to get this picture and set as the contact's profile picture.
Hi. Thank you for explaining this so well and making it look so easy. However I am having one issue - my code works if I have removed the form option of "Edit after submit". If I allow it and clicked this to edit, code is failing. Pls guide how to fix this
Thanks for this... it's really helpful and I was able to get it working on my end as well. @ExcelGoogleSheets is it possible to add the contact to additional contact group as a part of the updateContact function? Assuming the contact is already in cg[3] and they update their information, is there a way to amend the updateContact function to also add the contact to cg[4]? Thanks again!!!
Going step by step, through a clearly explained, trial and error approach has helped me so much with my programming. You are a great teacher! Thank you so much for your contributions sir!
Hello!
Please show us a code from which we can send text sms messages or whatsapp messages on submit of a form :) Would be a great help...
Really love your videos it's very helpful! Thank you !
UPPP!!!
Up
godbless you what amazing tutorial!!!!
Great Sir
@Learn Google Spreadsheets can you make an updated video with the new People API because Contact Api Not working in google app script
great job
NOT ABLE TO DO IT SOME ERROR IS STARTING WHILE USING 'INFO' AND 'E' IN BETWEEN
Hello, I keep getting the error "Cannot read the property 'Name' of undefined" any thoughts to why I might get this error using line for line the code you're creating?
Great Job!!!
Awesome! Can we get written code with details on it?
Mannn! You're amazing. So much love for your work here on the channel. Do you think about allowing the "Join" function here on the channel so we can support your work? I would be glad to support your work.
Thanks. There is a bunch of things I need to do to set it up. Hopefully I'll get to it at some point within the next month.
@@ExcelGoogleSheets I look Forward to it.
You're great, but I'm too late. I need this facility now. But the google is restricting first line Code: "creatcontact" it is showing like this " -creatcontact- . How can I overcome this. Help me in this regard.
Same issue with me as well, seems as if google has moved functions to google people api that is what it says on the website
Very interesting! Source filles should be fine to test it.
Thanks for another amazing video tutorial. I was wondering about how to add a label to the new contact. I've tried to do it but I haven't found the way.
If you explain me what labels do, I'll figure out how to add one :)
@@ExcelGoogleSheetsThanks for your answer. It's a kind of category you can assign to each contact. In fact, contacts can have more than one category, in this case, labels. I don't know if I can send a picture here.
drive.google.com/file/d/1jvBwhU8vP-7lOsvVv4BHFgc-BqiAUyHm/view?usp=sharing
The picture I shared shows, in reality, two pictures, the first one, we see the contact and just under the name, you see "no label" which means that I haven't assigned any labels to the contact. and the second picture shows the labels I have created. It allows me to have my contacts in order.
@@ExcelGoogleSheets a label you can organize the people and businesses in Contacts using labels. You can use the Contacts app to find someone's contact info or organize contacts with labels like "friends" or "family." Could you do one to show us?
Brilliant stuff man!!
Fantanstic tutorial! Thank You!
Thank you!
You da man!
I congratulate you for your contribution to the community, I have a question, why do you use the CONST reserved word in the variables instead of using the LET or VAR reserved words?
const is a type that can not be redifined within the block.
For example, this will give you an error, since x must remain 5 within this block.
{
const x = 5;
x = 6;
}
Thanks for sharing. Is it possible in a form the user put I'd number and then in the form show his name looking on a database or sheet ? And then the user continues filling data of the form? Thanks for any suggestions
Well this solves some issue. Thank you.
Well, I'm not exactly sure this solves the issue or not.... I'm populating contacts just fine, but when I go Google Voice to send a SMS, the contacts in Voice haven't updated. I've noticed a difference between the computer interface and tablet interface. I left the tablet in my locker at work.... sigh.....
This is a great video
I was looking for a script that could automatically save contacts from my Google sheets to my Google contacts once a new column is filled
A new row in the Google sheet gets automatically filled from my Elementor form once a new sign up submits his/her details
Kindly note that the sheet contains First name, Last name, phone number, email
I would appreciate a tutorial that could explain how automate creating a new contact (name, phone number and email) on my Google contact successfully. Thanks
Hello there! Do you know if it's possible to add the picture on the contact via Apps Script? I'm building an employee form where I ask the user to submit a picture and I want my code to get this picture and set as the contact's profile picture.
Hi. Thank you for explaining this so well and making it look so easy. However I am having one issue - my code works if I have removed the form option of "Edit after submit". If I allow it and clicked this to edit, code is failing. Pls guide how to fix this
how are you getting those dropdown function lists?
Would you instruct how to google sheet to gmail contact
Sir "" Exception: Service error: ContactsApp: Invalid request"" when i run the script the error is shown this?
Hi, i need make a quiz with timer on every question. is it possible? If yes, make a tutorial please :)
is there an easy way to copy the script?
please tell me, how add birthday and anniversary
i cannot do, always show error
How to add the date of birth column ?
How to disable copy,paste commands in google form
I can not look the code
Noob : returned with Error: Cannot read property 'namedValues' of undefined (line 3, file "Code") .. somebody please help
Don't manually run the code. It should run automatically when you submit the form.
i can't work out to inmplement the birtyday
Connect With Google Group please
this video could've been so much shorter and concise if you would've figured out what you were doing beforehand.
Send code
Thanks for this... it's really helpful and I was able to get it working on my end as well. @ExcelGoogleSheets is it possible to add the contact to additional contact group as a part of the updateContact function? Assuming the contact is already in cg[3] and they update their information, is there a way to amend the updateContact function to also add the contact to cg[4]? Thanks again!!!
Déjanos el código
I’m depressed. I failed