Please change the link-sharing option of the docs from "Restricted" to "Anyone with the link" so that you don't have to make an effort to grant access to everyone.. Just a suggestion...
Hi, Sir is it possible to add a print button to the previous database you created the userforrm with images thanks looking forward for more videos from you
This tutorial is most helpful for those who already have basic knowledge. I can follow easily even without audio. It is so kind of you to share the app with everyone. Thank you so much
P S you're not showing us how to make it from scratch!! people who don't know how to build databases won't know how to build it from scratch please re-do video
When I click on Search button, it shows, Running Script, Finished Script, But nothing shows up (all fields are blank) in any of the cell, I checked each and every line of code, everything is fine there, Can anyone help me? all things are okay but search button are not working. var SPREADSHEET_NAME = "Data"; var SEARCH_COL_IDX = 0; var RETURN_COL_IDX = 0; function searchStr() {
var ss = SpreadsheetApp.getActiveSpreadsheet(); var formSS = ss.getSheetByName("Form1"); //Form Sheet
var str = formSS.getRange("B5").getValue(); var values = ss.getSheetByName(SPREADSHEET_NAME).getDataRange().getValues(); for (var i = 0; i < values.length; i++) { var row = values[i]; if (row[SEARCH_COL_IDX] == str) {
Hi, this is a great tutorial. I have a big request from you if you can please tell me how can make this to work for multiple sheets? Thank you a lot for your tutorials! I wish you all the best!
Your Note Book (Google Sheet) - Write online in your own Language : th-cam.com/video/ZHA9pPGFhgk/w-d-xo.html&feature=em-comments Your Note Book - Google Sheet Link : ---------------------------------------------------- docs.google.com/spreadsheets/d/1ip1Ut7zuM2ikapUu3Tybfdzd2ZzJoADlPSN5ALR5Gk4/edit#gid=0
please make small data base and form for employee time , name , work start time , work end time, break and total work time.for month and year how to link one for m to an other
Unimpressive presentation of good work. It appears as if the speaker is only interested making this programme for himself. Incase if your are teaching to other keen learners, please speak to the learners. I mean no offence towards you. Kindly watch a school teacher and how they create interest in the subject. Your style is not doing this. Sorry for writing thses silly words.
Hi sir, I'm experiencing a hard time at Search button function, it says REFERENCE ERROR, my spreadsheet is not define.. What will I do.? Thanks a lot. More power
But I am finding that all new records I add to the database through the form are written at the bottom of the Data sheet (the last row itself)... yet the script line : datasheet.getRange(datasheet.getLastRow()+1, 1, 1, 26).setValues(values); under the submit function is unchanged except for the number of columns which is 7 in your example database but 26 in mine. I have watched over and over the video here but cannot see nor find the solution to append the new submitted record to the last record row + 1 (which in my case should be in row 177, but is written in row998). Can you help please? I'd be extremely grateful. Thanks
if you press enter on a cell even there is no character in it, the computer read it as a zero length string, mean it has a value of string but no length , in human eyes it is empty cell but in computer it has a value of string that have no character. therefore it is not the last raw.
Hi, Sir I done as you explain but in the in "Authorisation Required" (A script attached to this document needs your permission to run) appears. Can you please help me in this
hello, idk if you read it but i wanna ask ypu something. ypur video is really helping me but can you tell me how to save file into multiple sheet? for example if i want to save this file, i want to save it in sheet 2, and if i want to save another file, i want to save it in sheet 3, etc thank you (sorry for bad english)
I tried to repeat your template, but I have an error about image display. It's not display in box event I try to correct the formula you provided. Please help to solve this.
Hello there. This video of yours helped me a lot. Thanks. Can the page where the data is saved be another table, another file? Can we print data to another file? How do this? Thanks.
Hi, im a begginer in google script and got your code to work for what Iam trying to do for the most part but there is one problem with it, or that i cant seem to solve. If a person tries to use the function sumbmitSave data when there is already a data point saved for in your case an employees ID number then there will be two rows in the data set for this employee. Tried making a if statement but since im inadept in this type of code I cant get it to work properly, is that something you could help/guide with?
can I send a data from one sheet to another sheet? i created two different sheet, I don't mean tabs under same sheet, I mean two different document. I want to call up the data from a sheet to which nobody except me have access to, but they can search data using this database search tool you created, but they wont have direct access to the sheet where database is held
Sorry i want ask: For example, i changed "Emp No. From blank box to 1000, and you share to everyone, what the everyone get went open the google sheet, the box is blank or the box is filled by 1000?
Hey P S, It's me again :D Just wondering If you would know how to add some coding that prevents entering or saving duplicates? For example, when you click new then fill out the data, you hit save and It looks through your database and If It finds the same Emp. No. , a window pops up saying this Emp. No. already exists. Thank you for your time :D
Hello ! Thanks for this content ! I have a problem with the property getDataRange, it shows "Cannot read property 'getDataRange' of undefined"... Can someone help me ?
I was sleeping during this tutorial because our sir was too slow and sounded monotonous. Can you be more loud and lively to make the lessons interesting.Thank you
Thank you very much for the example & code. First google form video with practical use! Just one question, I wish to have more fields in the form, changed 7 to 12 in 2 arguments and added rows where specific fields are mentioned. It works but each time one field is not being stored in the Data form. every time a different field... Can you please help? I guess I have to change something more than what I have already done... Thanks in advance.
datasheet.getRange(datasheet.getLastRow()+1, 1, 1, 7 ).setValues(values); datasheet.getRange( Row Number to add, Starting Column Number, Number of Rows to Add, Number of Columns to Add) If you increase the fields, then you change only the "Number of Columns to Add"
Nice. But I've tried about that's buttons too, and they didn't work in the smartphone. I got this for an alternative th-cam.com/video/Z5n-q2W_5QM/w-d-xo.html
Sadly dropdown list in google sheet android version uses exact match where we have to write exact word from the beginning matching the words located in particular list. The thing is different with web version of google sheet, we could write any word, not only from beginning
Thank you very much for offering this project to the community. Everything works fine for me except the update function. I am using my own layout and changed the max columns In the script editor but I keep getting the error "The number of columns in the data does not match the number of columns in the range. The data has 7 but the range has 6." My Data actually only has 6 columns In use, so I've been tweaking with the code but still have not figured out what else needs to be changed to show that only 6 columns are needed. Thank you In advanced.
datatasheet.getRange(INT_R, 1, 1, 7).setValues(values1); .getRange (row, column, NumRows, NumColumns) In bracket : 1. Starting Row 2. Starting Column 3. Number of Rows 4. Number of Columns If you have 6 columns then the 4th number is 6
@@PS-tr9ly thank you so much for your reply. That’s correct and I did change that to 6 but I continue to get the error stating that my data has 7 columns and my range only 6. My data Columns go from A to F so that’s 6 columns when I count it :). I even made a new data sheet with your layout just to see if my layout is wrong. I get the same error as before. The only difference I have is I’m using 6 columns. Is there somewhere else in the coding that says I’m using 7 columns ? Thank you once again.
Hard to hear your voice but thank you very much, sir. Sample file and code will be very helpful as I learn to apply this knowledge for my own project..
![How to create a data entry form in Google Sheets [with multiple databases]](/img/n.gif)
Please change the link-sharing option of the docs from "Restricted" to "Anyone with the link" so that you don't have to make an effort to grant access to everyone.. Just a suggestion...
2:32 what just happened here
SEARCH AND UPDATE IS NOT WORKING FOR ME, THERE IS NO ERROR IN THE CODE & ONE MORE PLEASE IMPROVE THE AUDIO QUALITY SIR
Same for me, the search is not returning the values to the specified cells. PLease help.. Great Video btw
Hi, Sir is it possible to add a print button to the previous database you created the userforrm with images thanks looking forward for more videos from you
Use macros and store that in a button name it print
This tutorial is most helpful for those who already have basic knowledge. I can follow easily even without audio. It is so kind of you to share the app with everyone. Thank you so much
how multiple user can work on this?
awesome but you did not show how to make "sheet2"
P S you're not showing us how to make it from scratch!! people who don't know how to build databases won't know how to build it from scratch please re-do video
Hello sir! I want to make print button on Google Sheet. pls give a sample video!
When I click on Search button, it shows, Running Script, Finished Script, But nothing shows up (all fields are blank) in any of the cell, I checked each and every line of code, everything is fine there, Can anyone help me? all things are okay but search button are not working.
var SPREADSHEET_NAME = "Data";
var SEARCH_COL_IDX = 0;
var RETURN_COL_IDX = 0;
function searchStr() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var formSS = ss.getSheetByName("Form1"); //Form Sheet
var str = formSS.getRange("B5").getValue();
var values = ss.getSheetByName(SPREADSHEET_NAME).getDataRange().getValues();
for (var i = 0; i < values.length; i++) {
var row = values[i];
if (row[SEARCH_COL_IDX] == str) {
formSS.getRange("B7").setValue(row[0]) ;
formSS.getRange("E7").setValue(row[1]);
formSS.getRange("H7").setValue(row[2]);
formSS.getRange("K7").setValue(row[3]);
formSS.getRange("N7").setValue(row[4]);
formSS.getRange("A12").setValue(row[5]);
formSS.getRange("B12").setValue(row[6]);
formSS.getRange("C12").setValue(row[7]);
formSS.getRange("D12").setValue(row[8]);
formSS.getRange("E12").setValue(row[9]);
formSS.getRange("F12").setValue(row[10]);
formSS.getRange("G12").setValue(row[11]);
formSS.getRange("H12").setValue(row[12]);
formSS.getRange("I12").setValue(row[13]);
formSS.getRange("J12").setValue(row[14]);
formSS.getRange("K12").setValue(row[15]);
formSS.getRange("L12").setValue(row[16]);
formSS.getRange("M12").setValue(row[17]);
formSS.getRange("N12").setValue(row[18]);
formSS.getRange("O12").setValue(row[19]);
formSS.getRange("P12").setValue(row[20]);
formSS.getRange("Q12").setValue(row[21]);
formSS.getRange("R12").setValue(row[22]);
formSS.getRange("S12").setValue(row[23]);
formSS.getRange("T12").setValue(row[24]);
formSS.getRange("U12").setValue(row[25]);
formSS.getRange("V12").setValue(row[26]);
formSS.getRange("W12").setValue(row[27]);
formSS.getRange("X12").setValue(row[28]);
formSS.getRange("Y12").setValue(row[29]);
formSS.getRange("Z12").setValue(row[30]);
formSS.getRange("AA12").setValue(row[31]);
formSS.getRange("AB12").setValue(row[32]);
formSS.getRange("AC12").setValue(row[33]);
formSS.getRange("B17").setValue(row[34]);
formSS.getRange("B18").setValue(row[35]);
formSS.getRange("B19").setValue(row[36]);
formSS.getRange("B20").setValue(row[37]);
formSS.getRange("B21").setValue(row[38]);
formSS.getRange("G16").setValue(row[39]);
formSS.getRange("H16").setValue(row[40]);
formSS.getRange("I16").setValue(row[41]);
formSS.getRange("G17").setValue(row[42]);
formSS.getRange("H17").setValue(row[43]);
formSS.getRange("I17").setValue(row[44]);
formSS.getRange("G18").setValue(row[45]);
formSS.getRange("H18").setValue(row[46]);
formSS.getRange("I18").setValue(row[47]);
formSS.getRange("G19").setValue(row[48]);
formSS.getRange("H19").setValue(row[49]);
formSS.getRange("I19").setValue(row[50]);
formSS.getRange("G20").setValue(row[51]);
formSS.getRange("H20").setValue(row[52]);
formSS.getRange("I20").setValue(row[53]);
formSS.getRange("B27").setValue(row[54]);
formSS.getRange("B28").setValue(row[55]);
formSS.getRange("B29").setValue(row[56]);
formSS.getRange("B30").setValue(row[57]);
formSS.getRange("B31").setValue(row[58]);
formSS.getRange("B32").setValue(row[59]);
formSS.getRange("B33").setValue(row[60]);
formSS.getRange("B34").setValue(row[61]);
formSS.getRange("B35").setValue(row[62]);
formSS.getRange("B36").setValue(row[63]);
formSS.getRange("B37").setValue(row[64]);
formSS.getRange("B38").setValue(row[65]);
formSS.getRange("C27").setValue(row[66]);
formSS.getRange("C28").setValue(row[67]);
formSS.getRange("C29").setValue(row[68]);
formSS.getRange("C30").setValue(row[69]);
formSS.getRange("C31").setValue(row[70]);
formSS.getRange("C32").setValue(row[71]);
formSS.getRange("C33").setValue(row[72]);
formSS.getRange("C34").setValue(row[73]);
formSS.getRange("C35").setValue(row[74]);
formSS.getRange("C36").setValue(row[75]);
formSS.getRange("C37").setValue(row[76]);
formSS.getRange("C38").setValue(row[77]);
formSS.getRange("D27").setValue(row[78]);
formSS.getRange("D28").setValue(row[79]);
formSS.getRange("D29").setValue(row[80]);
formSS.getRange("D30").setValue(row[81]);
formSS.getRange("D31").setValue(row[82]);
formSS.getRange("D32").setValue(row[83]);
formSS.getRange("D33").setValue(row[84]);
formSS.getRange("D34").setValue(row[85]);
formSS.getRange("D35").setValue(row[86]);
formSS.getRange("D36").setValue(row[87]);
formSS.getRange("D37").setValue(row[88]);
formSS.getRange("D38").setValue(row[89]);
formSS.getRange("F27").setValue(row[90]);
formSS.getRange("F28").setValue(row[91]);
formSS.getRange("F29").setValue(row[92]);
formSS.getRange("F30").setValue(row[93]);
formSS.getRange("F31").setValue(row[94]);
formSS.getRange("F32").setValue(row[95]);
formSS.getRange("F33").setValue(row[96]);
formSS.getRange("F34").setValue(row[97]);
formSS.getRange("F35").setValue(row[98]);
formSS.getRange("F36").setValue(row[99]);
formSS.getRange("F37").setValue(row[100]);
formSS.getRange("F38").setValue(row[101]);
return row[RETURN_COL_IDX];
}
}
}
who could tell me how to show the image? I tried many many times. All is fail. The other is working perfect.
When i go to tools, I don't see script editor
What shouldi do to make it visible?
You Goose. It's already created and you showing us how to create?
sir, search function run time error
TypeError: formS.getRange(...).getvalue is not a function
what to do please tell
Same here. Did you find a solution by chance?
Hi, this is a great tutorial.
I have a big request from you if you can please tell me how can make this to work for multiple sheets?
Thank you a lot for your tutorials! I wish you all the best!
a question....if 2 persons in different place....can their open it in the same time...any problem?
How to add a upload student photo option in the registration form, Please refer the below link for my college registration form, and advice.
Sir image link not work link add but imge not show in frame pls help
Your Note Book (Google Sheet) - Write online in your own Language :
th-cam.com/video/ZHA9pPGFhgk/w-d-xo.html&feature=em-comments
Your Note Book - Google Sheet Link :
----------------------------------------------------
docs.google.com/spreadsheets/d/1ip1Ut7zuM2ikapUu3Tybfdzd2ZzJoADlPSN5ALR5Gk4/edit#gid=0
thankyou for this video. I want to make a purchase order form in google sheet. Do you have this template?
I'm very intrested in it, unfortunately the voice is not clear.
Try this
Spreadsheet Form th-cam.com/video/2sPcXiVrff8/w-d-xo.html
please make small data base and form for employee time , name , work start time , work end time, break and total work time.for month and year
how to link one for m to an other
noise background.
Not working in mobile
thankyou for this video. please tell me about how create google sheet form to store google sheet.
how to add script editor, developer at g.sheet?
To add script in Google sheet
1. Click on Extensions
2. Click on Apps Script
Awesome. I had no idea it could be done with Google Sheets.
Unimpressive presentation of good work. It appears as if the speaker is only interested making this programme for himself.
Incase if your are teaching to other keen learners, please speak to the learners. I mean no offence towards you. Kindly watch a school teacher and how they create interest in the subject.
Your style is not doing this. Sorry for writing thses silly words.
Hi...I want to save data in other google sheet not in the same sheet..Kindly help me the scrip.
how did you create that form 3:12
Hi sir, I'm experiencing a hard time at Search button function, it says REFERENCE ERROR, my spreadsheet is not define.. What will I do.? Thanks a lot. More power
But I am finding that all new records I add to the database through the form are written at the bottom of the Data sheet (the last row itself)... yet the script line : datasheet.getRange(datasheet.getLastRow()+1, 1, 1, 26).setValues(values); under the submit function is unchanged except for the number of columns which is 7 in your example database but 26 in mine. I have watched over and over the video here but cannot see nor find the solution to append the new submitted record to the last record row + 1 (which in my case should be in row 177, but is written in row998).
Can you help please?
I'd be extremely grateful. Thanks
try to delete the row 178 to 998
if you press enter on a cell even there is no character in it, the computer read it as a zero length string, mean it has a value of string but no length , in human eyes it is empty cell but in computer it has a value of string that have no character. therefore it is not the last raw.
not working
Hi, Sir I done as you explain but in the in "Authorisation Required" (A script attached to this document needs your permission to run) appears. Can you please help me in this
How to copy the apps script please?
1. Click on File
2. Click on 'Make a Copy'
Please Muje Apka Nombar Bhejo Muje Google Sheets FORMENT banana Na He
I want to do in android
Geez that went from showing how to setup a Google account to suddenly having form created already...
hey man itrying to make a script to prevent put same Emp No number into Form. may i ask how to do it? thank you
Sir if entry should be saved in the first row every time what will be the code
its unclear how you jumped to having the form on sheet2 in the google sheets (min 3:10~)
hello, idk if you read it but i wanna ask ypu something.
ypur video is really helping me but can you tell me how to save file into multiple sheet?
for example if i want to save this file, i want to save it in sheet 2, and if i want to save another file, i want to save it in sheet 3, etc
thank you (sorry for bad english)
YOU SAVED MY LIFEE!! THANKS A LOT
hahahaha
If I download the file the database formula will remain?
Sir,
I want to contact with you about this project.
Please help me. I will be glad to you very much.
Hi, Sir.. how I can add link and submit it together with my data to datasheet ? is it possible to add a upload file button in the userform ?
Sir, Some parts are not clear. For eg. how you created employees details page and designing form. Pls clarify them
I tried to repeat your template, but I have an error about image display. It's not display in box event I try to correct the formula you provided. Please help to solve this.
Hi Sir, can you help me set up a form if i give you the details, working with script looks difficult.
Hello sir. Very helpful video and it is very close to what I am trying to do. Would you interested to have a look on my idea and give me a solution?
hello i have a question please how can we check if the employee id exists before when save the data because we will have duplication
Thank you very much. Your video is so educational. God bless you man.
Thanks for the great work. Please can you demonstrate how to upload an image from PC to the form, so that it is stored on Google drive?. Thanks
I want to create database like this but when I press new, the employee number is automatically filled (+1 from last employee). How to do that?
formSS.getRange("C8").setValue(datasheet.getLastRow()+1) ;
Hello there.
This video of yours helped me a lot. Thanks.
Can the page where the data is saved be another table, another file? Can we print data to another file? How do this? Thanks.
Great Video.....in simple words accomplishing high purpose.please suggest code for form to Google sheet and sheet to form in same form
Hi, im a begginer in google script and got your code to work for what Iam trying to do for the most part but there is one problem with it, or that i cant seem to solve.
If a person tries to use the function sumbmitSave data when there is already a data point saved for in your case an employees ID number then there will be two rows in the data set for this employee.
Tried making a if statement but since im inadept in this type of code I cant get it to work properly, is that something you could help/guide with?
Hi, thnks for the video but why I don't have a validation date in my data ?
helo could you help in adding image
what code did you use
He hide everything
can I send a data from one sheet to another sheet? i created two different sheet, I don't mean tabs under same sheet, I mean two different document. I want to call up the data from a sheet to which nobody except me have access to, but they can search data using this database search tool you created, but they wont have direct access to the sheet where database is held
please check the video "Multi user Data Entry Form"
th-cam.com/video/ZGIpe66gpPI/w-d-xo.html
Dear Please help me about how to check duplicate ID before save.
Helo sir, i i saw from your video, more better please used google form and link to google sheet. more easy dan fast
and with auto crat we can print this entry and send back to who input data base
It is virtually impossible to understand anything
Weldon job but you shouldn't show how to make form 1
Good tutorials, but the voice is not clear and the explanation is not so good.
Very good ! That is exactly what I was searching for, thank you bro, god bless you.
Good tutorial...
After response is submitted ... is it possible to make arithmetic operations on specific cells using Apps script?
Thank You guys, yuo're awesome :)
Sorry i want ask:
For example, i changed "Emp No. From blank box to 1000, and you share to everyone, what the everyone get went open the google sheet, the box is blank or the box is filled by 1000?
This is what exactly expected
GREAT TUTORIAL HOW I CAN GET VALUES FROM MERGED CELLS
Thank you very much your valuable service please share to Example with editable mode please
Thank you very much for your help :)
Hey P S, It's me again :D Just wondering If you would know how to add some coding that prevents entering or saving duplicates? For example, when you click new then fill out the data, you hit save and It looks through your database and If It finds the same Emp. No. , a window pops up saying this Emp. No. already exists. Thank you for your time :D
Thank you so much, You did a great help for us!
it is very helpful, sir I share sheet then after add buttons doesn't work in sharing sheet. Pl guide
Are
sir,is the image getting saved in the datasheet also ?
Hello ! Thanks for this content ! I have a problem with the property getDataRange, it shows "Cannot read property 'getDataRange' of undefined"... Can someone help me ?
Can we input without mouse sir?
I need to protect the sheet by date wise automatic
Hi sir can u make me a data sheet
I was sleeping during this tutorial because our sir was too slow and sounded monotonous. Can you be more loud and lively to make the lessons interesting.Thank you
I have issue with get range error.
Please sir how do you add the sign in form to it
Thank you very much for the example & code. First google form video with practical use! Just one question, I wish to have more fields in the form, changed 7 to 12 in 2 arguments and added rows where specific fields are mentioned. It works but each time one field is not being stored in the Data form. every time a different field... Can you please help? I guess I have to change something more than what I have already done... Thanks in advance.
//Input Values
var values = [[formSS.getRange("C8").getValue(),
formSS.getRange("C10").getValue(),
formSS.getRange("C12").getValue(),
formSS.getRange("E8").getValue(),
formSS.getRange("E10").getValue(),
formSS.getRange("C14").getValue(),
formSS.getRange("C20").getValue()]];
// Save New Data
datasheet.getRange(datasheet.getLastRow()+1, 1, 1, 7 ).setValues(values);
datasheet.getRange( Row Number to add, Starting Column Number, Number of Rows to Add, Number of Columns to Add)
If you increase the fields, then you change only the "Number of Columns to Add"
I am appreciated it in your sharing script code, it is very easy to apply to many kind of works. Thank you very much.
Excelente, llevaba mucho tiempo buscando algo así. Thank you so much.
Nice. But I've tried about that's buttons too, and they didn't work in the smartphone. I got this for an alternative th-cam.com/video/Z5n-q2W_5QM/w-d-xo.html
Already subscribed... Thank you Sir for tutoring us and for the downloadble files
Hi, how do I access the downloadable files please?
Thank you for the tutorial it was super helpful. If you wanted to search by employee name instead of Number how would you go about that?
Thank you so much for this!
Formats create ela chesav cheyadam chupinchaledu
A spreadsheet is NOT a database!
bro, gracias por el video, ¿Cómo prodría agregar datos desde forms a la base de datos?
How did you create that form?
hello PRADEEP how are you, i need your help please about some thing thanks
Sadly dropdown list in google sheet android version uses exact match where we have to write exact word from the beginning matching the words located in particular list.
The thing is different with web version of google sheet, we could write any word, not only from beginning
Thank you very much for offering this project to the community. Everything works fine for me except the update function. I am using my own layout and changed the max columns In the script editor but I keep getting the error "The number of columns in the data does not match the number of columns in the range. The data has 7 but the range has 6." My Data actually only has 6 columns In use, so I've been tweaking with the code but still have not figured out what else needs to be changed to show that only 6 columns are needed. Thank you In advanced.
datatasheet.getRange(INT_R, 1, 1, 7).setValues(values1);
.getRange (row, column, NumRows, NumColumns)
In bracket :
1. Starting Row
2. Starting Column
3. Number of Rows
4. Number of Columns
If you have 6 columns then the 4th number is 6
@@PS-tr9ly thank you so much for your reply. That’s correct and I did change that to 6 but I continue to get the error stating that my data has 7 columns and my range only 6. My data Columns go from A to F so that’s 6 columns when I count it :). I even made a new data sheet with your layout just to see if my layout is wrong. I get the same error as before. The only difference I have is I’m using 6 columns. Is there somewhere else in the coding that says I’m using 7 columns ? Thank you once again.
@@urickyo5370 var values1 = [[formSS.getRange("C8").getValue(),
formSS.getRange("C10").getValue(),
formSS.getRange("C12").getValue(),
formSS.getRange("E8").getValue(),
formSS.getRange("E10").getValue(),
formSS.getRange("C14").getValue(),
formSS.getRange("C20").getValue()]];
Please you check the above ranges in array "values1". Here it is 7 ranges
In your code it must be 6
@@PS-tr9ly Wow, that actually fixed it :D thank you so much for your time and assistance. Subscribed :D
Ah also noticed the formula you use for the image (=image(substitute(TRIM)) etc, does not work anymore. Maybe google blocked this kind of sharing.
OMG ....
THANK YOU
VERY HELPFUL
Hard to hear your voice but thank you very much, sir. Sample file and code will be very helpful as I learn to apply this knowledge for my own project..