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!
@vatsalmimani52954 жыл бұрын
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 !
@gregoriusalvin1183 жыл бұрын
UPPP!!!
@muhammadzais93673 жыл бұрын
Up
@user-in7ee5oi1d3 жыл бұрын
godbless you what amazing tutorial!!!!
@kulvinder82113 жыл бұрын
Great Sir
@allpreedotcom3 жыл бұрын
@Learn Google Spreadsheets can you make an updated video with the new People API because Contact Api Not working in google app script
@saby74164 жыл бұрын
great job
@jagrutisons50862 жыл бұрын
NOT ABLE TO DO IT SOME ERROR IS STARTING WHILE USING 'INFO' AND 'E' IN BETWEEN
@financerunner3 жыл бұрын
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?
@JerryEduardo4 жыл бұрын
Great Job!!!
@iamthatakashkaushal4 жыл бұрын
Awesome! Can we get written code with details on it?
@fernandobrito53164 жыл бұрын
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.
@ExcelGoogleSheets4 жыл бұрын
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.
@fernandobrito53164 жыл бұрын
@@ExcelGoogleSheets I look Forward to it.
@Mudassir_Ali Жыл бұрын
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.
@healthyhomemade2198 ай бұрын
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
@florentd.58174 жыл бұрын
Very interesting! Source filles should be fine to test it.
@PepitoGrilloCanarias4 жыл бұрын
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.
@ExcelGoogleSheets4 жыл бұрын
If you explain me what labels do, I'll figure out how to add one :)
@PepitoGrilloCanarias4 жыл бұрын
@@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.
@ringonguyen9415 Жыл бұрын
@@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?
@reservationsgenesis1052 жыл бұрын
Brilliant stuff man!!
@herbertmeyerhof22353 жыл бұрын
Fantanstic tutorial! Thank You!
@emilianoreyes4 жыл бұрын
Thank you!
@julioquatro14823 жыл бұрын
You da man!
@programador19723 жыл бұрын
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?
@ExcelGoogleSheets3 жыл бұрын
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; }
@elricho724 жыл бұрын
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
@photoclerk3 жыл бұрын
Well this solves some issue. Thank you.
@photoclerk3 жыл бұрын
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.....
@shaddairaphaels2 жыл бұрын
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
@fernandobrito53162 жыл бұрын
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.
@TheHungryPetu3 жыл бұрын
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
@JWesleyRussell2 жыл бұрын
how are you getting those dropdown function lists?
@daohongtien2 жыл бұрын
Would you instruct how to google sheet to gmail contact
@kulvinder82112 жыл бұрын
Sir "" Exception: Service error: ContactsApp: Invalid request"" when i run the script the error is shown this?
@anonymafioadmin53984 жыл бұрын
Hi, i need make a quiz with timer on every question. is it possible? If yes, make a tutorial please :)
@shawngormley Жыл бұрын
is there an easy way to copy the script?
@heechage3 жыл бұрын
please tell me, how add birthday and anniversary
@anwarsenua3 жыл бұрын
i cannot do, always show error
@muhammadzais93673 жыл бұрын
How to add the date of birth column ?
@arjunpremjith46634 жыл бұрын
How to disable copy,paste commands in google form
@mepconssolusicad58244 жыл бұрын
I can not look the code
@Ravisankarguruji3 жыл бұрын
Noob : returned with Error: Cannot read property 'namedValues' of undefined (line 3, file "Code") .. somebody please help
@ExcelGoogleSheets3 жыл бұрын
Don't manually run the code. It should run automatically when you submit the form.
@davypaulissen21203 жыл бұрын
i can't work out to inmplement the birtyday
@customerservice73803 жыл бұрын
Connect With Google Group please
@couchwilly5575 Жыл бұрын
this video could've been so much shorter and concise if you would've figured out what you were doing beforehand.
@iasaurav Жыл бұрын
Send code
@giantstix22 Жыл бұрын
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!!!