Hi! I’ve been a huge fan of your videos. From 0 coding knowledge, you made it so manageable to digest coding using App scripts. I have a request should you have time. I’d like to see you demonstrate how to use Bootstrap multiselect. Particularly, how to extract the values selected in multiselect and use these values in the server-side functions and/or form-side functions. Please and salamat!
Thank you so much for your great tutorials. They have been a great help to me in understanding Google sheets better. A quick question, how would I configure the function to handle multi input fields which are dripdowns instead of mere text input fields?
I've learned a lot through watching specific videos on your channel. Have you thought about adding coverage of MS Power BI to your portfolio? Just a thought...
Is it possible to change the input box to dropdown selection and get the options from the google sheet and every time the template is added, it will display the options? Thank you
That’s great. Can you make videos about a form modal that user adds multiple table rows for products, the client general information shall enter one time? The form shall submit to google sheet with multiple records. Thanks a lot.
This and the entire series has been very helpfull. Now if someone knows how to do the same exact thing above only instead of using a text box its a select box. Not so much have the select box appear as part of the template but have that select box fill with items from a column when clicking the toggle and when adding new lines I have not been able to figure out.
Good Morning. I have followed your videos for a long time and I have a doubt about this one. How can I add each issue in a new line of the spreadhseet? repeating the category, the item, etc.
Great videos! One question: suppose I wanted to save issues in a separate sheet with each issue in a separate row, possibly linked together by an OrderID? I THINK that would mean processing thru a created array of arrays via a nested forEach ... but could you help me understand how that works?
It depends on how many of them you have. If the count is fairly low then you can just use forEach loop once and use otherWS.appendRow([myId,mavel,orderid]) in the loop.
Hello, I have created my own UserForm in Google Sheets but when I change of computer sometimes the UserForm doesn´t load. Why does it happend (I have tried always in Chrome)? Thank you!
Hello, I really enjoyed this video and am really excited to get this functionality working, but I seem to be receiving a weird result when I am submitting the results to the spreadsheet. I built my form in a URL web app and was able to get everything working, but when I submit the form with the conditional input boxes my result for that column gives me this value: [Ljava.lang.Object;@24a0120d and other variations like it, if you could help me figure out why this is happening I would greatly appreciate it.
I have a problem, in console log Development Tools of Chrome display the next error: "Uncaught ReferenceError: template is not defined".... How can i fix this?
I enjoyed your video series. this is the upload code. This would be great continuation of the series as video14. this is the plain vanilla version, I am sure you can make it better. ADD VARIABLE TO PASS URL addnewrow aftersubmit afterbuttonclick HTML BODY ADD SOMEWHERE
This is really helpful. About to create an IT request form for my colleagues!
Educativa, útil y entretenida, esta serie de excelentes vídeos. Gracias Learn Google Spreadshets !
Awesome...been wondering how to do the 'add new' button for a long time. Thank you.
Hi! I’ve been a huge fan of your videos. From 0 coding knowledge, you made it so manageable to digest coding using App scripts.
I have a request should you have time. I’d like to see you demonstrate how to use Bootstrap multiselect. Particularly, how to extract the values selected in multiselect and use these values in the server-side functions and/or form-side functions.
Please and salamat!
Hiii,I really want to thank you again for all of your videos.Please one request,make one videos for File dailoag box.
Esperado vídeo de la serie.... Presente !!!
Thank you so much for your great tutorials. They have been a great help to me in understanding Google sheets better.
A quick question, how would I configure the function to handle multi input fields which are dripdowns instead of mere text input fields?
Things were going fairly well - until I couldn't get the 'plus' button to add a row. The 'minus' button works as intended. It's doing my head in!
I've learned a lot through watching specific videos on your channel. Have you thought about adding coverage of MS Power BI to your portfolio? Just a thought...
Have you seen my Power Pivot & Power Query videos?
Updated in my form @nice video sirji@nice work 😊😊😊
Is it possible to change the input box to dropdown selection and get the options from the google sheet and every time the template is added, it will display the options? Thank you
This is really useful.
Sir I have questions for you how to serial number run in input tag?.
And dynamic dropdown in this input tag?
That’s great. Can you make videos about a form modal that user adds multiple table rows for products, the client general information shall enter one time? The form shall submit to google sheet with multiple records. Thanks a lot.
This would also be cool, waiting for the teacher to start the session 😁
This and the entire series has been very helpfull. Now if someone knows how to do the same exact thing above only instead of using a text box its a select box. Not so much have the select box appear as part of the template but have that select box fill with items from a column when clicking the toggle and when adding new lines I have not been able to figure out.
hey, I am getting error in importxml that "it could not fetch url"
why is that I did everything as per you tutorial.
Good Morning.
I have followed your videos for a long time and I have a doubt about this one.
How can I add each issue in a new line of the spreadhseet? repeating the category, the item, etc.
Is really data produced by userform useful ?
because i found that we cannot do query functions with it nor filter functions........
Great videos! One question: suppose I wanted to save issues in a separate sheet with each issue in a separate row, possibly linked together by an OrderID? I THINK that would mean processing thru a created array of arrays via a nested forEach ... but could you help me understand how that works?
It depends on how many of them you have. If the count is fairly low then you can just use forEach loop once and use otherWS.appendRow([myId,mavel,orderid]) in the loop.
can we store conditional multi input boxes response in separate column for each response
Hello, I have created my own UserForm in Google Sheets but when I change of computer sometimes the UserForm doesn´t load. Why does it happend (I have tried always in Chrome)?
Thank you!
Hi
I have adding two input line
How to compare user not enter duplicate value?
Please help us
can you make a playlist of google sheets pivot table and v look up functions so that we can understand both of them clearly.. please.. its a request.
I already have these playlists. Check on the channel.
Please add multiple issue column
And submit data in separate row and column
Can you make the tutorial how to upload file in Google drive each no of line items.
How do you clear input value in a template tag ?
Hi all, i can not run this code in Bootstrap V5.1.1, pls help me. tks so much.
$(function() {
$('#condition').change(function() {
addInput();
});
});
Hello, I really enjoyed this video and am really excited to get this functionality working, but I seem to be receiving a weird result when I am submitting the results to the spreadsheet. I built my form in a URL web app and was able to get everything working, but when I submit the form with the conditional input boxes my result for that column gives me this value: [Ljava.lang.Object;@24a0120d and other variations like it, if you could help me figure out why this is happening I would greatly appreciate it.
I want to add another language to this form, how can I do that ? Let's say, English and Spanish. Many thanks for your amazing videos.
I have a problem, in console log Development Tools of Chrome display the next error:
"Uncaught ReferenceError: template is not defined"....
How can i fix this?
check the line with
var template =
Hey i wanted to add information in last cell not in last row, how can i do that????
That runs in android google sheets app?
kindly share tutorial for conditional multi upload files and get the url in google sheet
Detect duplicate of value multiple input fields.
Pls help me.
How to append multiple row?
olá muito bom, teria como liberar acesso a planilha ou ao código?
Is this sheet shared?
Is it possible to upload a file and get the link in the new row?
nop?
It is of course possible, but not easy to do.
I enjoyed your video series. this is the upload code. This would be great continuation of the series as video14. this is the plain vanilla version, I am sure you can make it better.
ADD VARIABLE TO PASS URL
addnewrow
aftersubmit
afterbuttonclick
HTML BODY ADD SOMEWHERE
HTML SCRIPT PORTION ADD SOMEWHERE
var uploadUrl=[]
const myForm = document.querySelector('form');
const myUpload = document.querySelector('input[name="upFile"]');
const message = document.querySelector('.message');
myForm.addEventListener('submit',(e)=>{
e.preventDefault();
message.textContent = 'Form Submitted';
const file = myUpload.files[0];
const fileR = new FileReader();
fileR.onload = function(e){
const vals = fileR.result.split(',');
const obj = {
fileName:file.name,
mimeType :file.type,
data : vals[1]
}
// console.log(obj);
google.script.run.withSuccessHandler(myResult).uploadFile(obj);
}
fileR.readAsDataURL(file);
})
function myResult(val){
uploadUrl.push(val.url);
message.innerHTML = `${val.name}`;
}
GS PORTION ADD SOMEWHERE
function uploadFile(data){
const myFile = Utilities.newBlob(Utilities.base64Decode(data.data),data.mimeType,data.fileName);
const folder = DriveApp.getFolderById('1vkPK-GMBZ4eLIZEAcTHzPrPgEFJ5Q391');
const fileAdded = folder.createFile(myFile);
const ss=SpreadsheetApp.getActiveSpreadsheet();
ss.appendRow([fileAdded.getUrl(),data.fileName,data.mimeType,fileAdded.getId()]);
const rep = {
'url' : fileAdded.getUrl(),
'name' : data.fileName
};
return rep;
}
Can it be mobile compatible view?
Sir! Would you do a small school Database? It should be control by Google web app form. Think about it, plz.
why not just add a add button on the bottom then say submit like in google forms.
Can someone post this source code as link? Pastebin works great. If you include payday or venmo Link, you might get a donation? 🤷🏻♂️
Right!!
you should subscribe to the author patron link, it has some of the source codes there.