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
Your scripting guide to create a form for a google sheet is excellent - search, add, Modify and delete ... thanks for the comprehensive brevity ... Thank you so much
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...
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
Thank you Sir for sharing your script. It is very useful for people like me who dont know how to write a script.. I am adapting your database and the script itself but am finding
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
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!
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..
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)
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.
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
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?
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"
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.
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?
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 ?
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.
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 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
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
In image cell add this code --> =image(substitute(C20,"open?id","uc?export=download&id")) In cell address C20 , you add the image location. (You can change the cell address C20 to C21 or other cell)
@@PS-tr9ly Hi, =IMAGE(SUSTITUIR(D29;"open?id";"uc?export=download&id")) and address drive.google.com/file/d/0B-qliiTmMynTaXVYWV9iMVpCRFU/view?usp=sharing, It doesn't work, please
Hello sir, this tutorial is very useful May I ask, how to change the starting column at sheet "data" for saving function? In my case, the data always start to the first column (column A)
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 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
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
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?
Hi PS, firstly thank you for creating this video, I found this easy enough to follow and your time is greatly appreciated. I have however stumbled upon an issue with the script. I have downloaded the script directly and the issue is still present. It appears this script does not like partial entries (example) New record, New ID, Employee Name, Designation, if you save or update, only the ID, Employee Name will save/update, the Designation text is also still shown after the update/Save and not using th "Clear" function. If you search the record and renter the Designation along with the "Remarks" click update the designation will update/save but not the remarks and so on. Its fine if you create the record from start to finish but sometimes you may need to do a quick save and complete another time. Update seems to have to be clicked twice for the record to "Update". I would be grateful if you could provide a fix, or if it is something that I am doing wrong, but pasting your script and saving has the same outcome using your "Form1" example.
Hi PS, after looking into this a little more (and some sound advice from the wife I might add after working on this for two days straight) I have found that you have to click off the cell that had the text, in order for it to update and save, not just type the text and click "Save/Update" this would also account for the twice "update" clicks, new Database looks awesome thanks to your assistance. Although the double entry "Save" would be helpful to have a duplicate ID message if your able to assist with that "string"...... Keep up the good work!
Thanks a lot, I used your code for my database with some changes. But I need to do something that I really don't know., I am new in this. For example, when I add a new person I need that the script search the maximun value on my register and add the next on for at the id part. But not the row, only the value. There is a formula for that in the script?
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
Your scripting guide to create a form for a google sheet is excellent - search, add, Modify and delete ... thanks for the comprehensive brevity ... Thank you so much
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...
Thank you very much. Your video is so educational. God bless you man.
Awesome. I had no idea it could be done with Google Sheets.
I am appreciated it in your sharing script code, it is very easy to apply to many kind of works. Thank you very much.
YOU SAVED MY LIFEE!! THANKS A LOT
hahahaha
Very good ! That is exactly what I was searching for, thank you bro, god bless you.
Thank you very much for your help :)
a question....if 2 persons in different place....can their open it in the same time...any problem?
OMG ....
THANK YOU
VERY HELPFUL
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
Thank you Sir for sharing your script. It is very useful for people like me who dont know how to write a script.. I am adapting your database and the script itself but am finding
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
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!
Thank You guys, yuo're awesome :)
Thank you so much for this!
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..
Already subscribed... Thank you Sir for tutoring us and for the downloadble files
Hi, how do I access the downloadable files please?
Thank you so much, You did a great help for us!
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)
It is very helpful and informative..
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.
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.
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
very good
Thanks a lot of Sir
Great Video.....in simple words accomplishing high purpose.please suggest code for form to Google sheet and sheet to form in same form
thanks, your tutorial is amazing
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?
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
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 , it help me a lot
I like your video,Thanks a lot
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"
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?
Ni Made Niati
Thank you so much !
Hello...how can 2 person use this simultaneously ti key in data
Thanks a lot
Thanks ....Very Helpful
how multiple user can work on this?
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
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.
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?
Sir image link not work link add but imge not show in frame pls help
Thanky you for the video. Can we change the Data sheet to a different Google Sheet file? I want the data to go to a different Google Sheet.
set the data spread sheet as follows :
var ssdata = SpreadsheetApp.openByUrl("Your shared data spreadsheet url");
@@PS-tr9ly thank you so 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, 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?
sir,is the image getting saved in the datasheet also ?
Hi...I want to save data in other google sheet not in the same sheet..Kindly help me the scrip.
helo could you help in adding image
what code did you use
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
thankyou for this video. I want to make a purchase order form in google sheet. Do you have this template?
awesome but you did not show how to make "sheet2"
thankyou for this video. please tell me about how create google sheet form to store google sheet.
Good tutorial...
After response is submitted ... is it possible to make arithmetic operations on specific cells using Apps script?
Sir if entry should be saved in the first row every time what will be the code
If I download the file the database formula will remain?
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 ?
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.
Hi, thnks for the video but why I don't have a validation date in my data ?
I like it this tutorial video
Tank you so much!
Hello sir! I want to make print button on Google Sheet. pls give a sample video!
2:32 what just happened here
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
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
When i go to tools, I don't see script editor
What shouldi do to make it visible?
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) ;
how did you create that form 3:12
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
Can we input without mouse sir?
Sir, Some parts are not clear. For eg. how you created employees details page and designing form. Pls clarify them
it is very helpful, sir I share sheet then after add buttons doesn't work in sharing sheet. Pl guide
Are
Hi Sir, can you help me set up a form if i give you the details, working with script looks difficult.
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
Good
Hello, in the link in the image the open? Id does not appear, how do I make it appear?
In image cell add this code -->
=image(substitute(C20,"open?id","uc?export=download&id"))
In cell address C20 , you add the image location.
(You can change the cell address C20 to C21 or other cell)
@@PS-tr9ly Hi, =IMAGE(SUSTITUIR(D29;"open?id";"uc?export=download&id")) and address drive.google.com/file/d/0B-qliiTmMynTaXVYWV9iMVpCRFU/view?usp=sharing, It doesn't work, please
Hello sir, this tutorial is very useful
May I ask, how to change the starting column at sheet "data" for saving function?
In my case, the data always start to the first column (column A)
This is what exactly expected
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];
}
}
}
thanks.
its unclear how you jumped to having the form on sheet2 in the google sheets (min 3:10~)
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
Thank you very much your valuable service please share to Example with editable mode please
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
Please sir how do you add the sign in form to it
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?
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?
Select Emp. Number and search.
Or check the function name you given in search button is correct
@@PS-tr9ly It is now working, thankyou, but I am not able to view the image, Kindly Help.
I have issue with get range error.
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
I need to protect the sheet by date wise automatic
how to add script editor, developer at g.sheet?
To add script in Google sheet
1. Click on Extensions
2. Click on Apps Script
Dear Please help me about how to check duplicate ID before save.
Hi PS, firstly thank you for creating this video, I found this easy enough to follow and your time is greatly appreciated. I have however stumbled upon an issue with the script. I have downloaded the script directly and the issue is still present. It appears this script does not like partial entries (example) New record, New ID, Employee Name, Designation, if you save or update, only the ID, Employee Name will save/update, the Designation text is also still shown after the update/Save and not using th "Clear" function. If you search the record and renter the Designation along with the "Remarks" click update the designation will update/save but not the remarks and so on. Its fine if you create the record from start to finish but sometimes you may need to do a quick save and complete another time. Update seems to have to be clicked twice for the record to "Update". I would be grateful if you could provide a fix, or if it is something that I am doing wrong, but pasting your script and saving has the same outcome using your "Form1" example.
Hi PS, after looking into this a little more (and some sound advice from the wife I might add after working on this for two days straight) I have found that you have to click off the cell that had the text, in order for it to update and save, not just type the text and click "Save/Update" this would also account for the twice "update" clicks, new Database looks awesome thanks to your assistance. Although the double entry "Save" would be helpful to have a duplicate ID message if your able to assist with that "string"...... Keep up the good work!
bro, gracias por el video, ¿Cómo prodría agregar datos desde forms a la base de datos?
Thanks a lot, I used your code for my database with some changes. But I need to do something that I really don't know., I am new in this. For example, when I add a new person I need that the script search the maximun value on my register and add the next on for at the id part. But not the row, only the value. There is a formula for that in the script?
Sir,
I want to contact with you about this project.
Please help me. I will be glad to you very much.
How did you create that form?
GREAT TUTORIAL HOW I CAN GET VALUES FROM MERGED CELLS