Agin thanks for a great work. I have a sheet named 'Main Data' then i have created another sheet named 'Clint1' which is sync with Main Data. Now i use Data validation in Clint1 sheet. in my case data validation is date input only. when I input a date in Clint1 sheet, It returns the value in Main Data but not that formate, it return a garbage value. is there any solution For data validation from client 1 sheet to Main Data sheet?
It's not "garbage value," it's the serial date shown as the sheet actually stores it. Dates, as far as the spreadsheet is concerned, are just numbers. Change the formatting on the column and it should work fine.
Hello! could you help me understand the script, from the code i understand that it only updates new edits to the "Database" spreadsheet, however when i try your example sheet it actually really works both ways from the database to the other sheets and vice-versa. When i try to copy the scipt and paste it to another sheet however it doesnt work both ways. is there something i am missing out?
Oh i see the reason why, im duplicating the original sheet and filtering them using the filter to create the new sheets but yours uses something else, may i know how do you create your additional filtered sheets?
Thanks for this video Spencer. Is there a way to allow adding info in additional rows to propagate back to the database? For example, if Mary had another student join her class. Is there a way to make it so that if she were to add the student in a new row in her tab, this new student would show up in the database tab and assign an ID to the row?
Hi Spencer. Thank you for making this video. The 2-way sync works but whenever I use the filter feature on my queried sheet, my filtered data disappears. I'm just new to app scripts and I've been trying to figure out what should be added to the script. Can you please help me?
What a great tutorial. is it possible to sync two way for comment? when i make a comment in one sheet this comment is not shifted in my database sheet.
@@SpencerFarris Your script working well but when i create new tab in the same sheet just for general purpose(Which is not linked with previous) , this new sheet don't take any value. is there any issue?
@@SpencerFarris Hmm Cool. I need help with the following too . 1) Formulas in Cells Does Not Work Sample (="hi"&A3&"the amount due is "&C3&".Kindly make the payment") 2) Please share the Code with Sample to exclude certain tabs(sheets)
Hi Spencer. Thank you again for making another version of the 2 way sync row aligned ver. I am wondering, is it possible to have 2 or more databases in a single workbook or worksheet?
Hi Spencer, thank you for the excellent explanation however i can't seem to get it to work in my sheets. I currently have a Master List Worksheet and a separate Worksheet for the other team members and i can't seem to get it to work so that whenever my team members edit their worksheet the new data will overwrite the existing data and appear in the Master List while corresponding to the unique ID :(
This is completely awesome !!!
thank you SOOO MUCH for this!!
Agin thanks for a great work.
I have a sheet named 'Main Data' then i have created another sheet named 'Clint1' which is sync with Main Data.
Now i use Data validation in Clint1 sheet. in my case data validation is date input only. when I input a date in Clint1 sheet, It returns the value in Main Data but not that formate, it return a garbage value. is there any solution For data validation from client 1 sheet to Main Data sheet?
It's not "garbage value," it's the serial date shown as the sheet actually stores it. Dates, as far as the spreadsheet is concerned, are just numbers. Change the formatting on the column and it should work fine.
Hello! could you help me understand the script, from the code i understand that it only updates new edits to the "Database" spreadsheet, however when i try your example sheet it actually really works both ways from the database to the other sheets and vice-versa. When i try to copy the scipt and paste it to another sheet however it doesnt work both ways. is there something i am missing out?
Oh i see the reason why, im duplicating the original sheet and filtering them using the filter to create the new sheets but yours uses something else, may i know how do you create your additional filtered sheets?
oh my gosh i figured it out, thankyou!
@@prisylj6621 So glad!
Excellent, I always thought this issue has no solution.
Hopefully Google someday supports it directly. But until then, apps script hack!
Thanks for this video Spencer. Is there a way to allow adding info in additional rows to propagate back to the database? For example, if Mary had another student join her class. Is there a way to make it so that if she were to add the student in a new row in her tab, this new student would show up in the database tab and assign an ID to the row?
Yes, I've set it up before where if there is no ID it adds a new row.
How do you edit the code to specify which sheets you want this code to run on
I just specify in the IF statement that if the sheet name isn't correct, stop running. IF(src.getName() != "sheet name") return;
Hi Spencer. Thank you for making this video. The 2-way sync works but whenever I use the filter feature on my queried sheet, my filtered data disappears. I'm just new to app scripts and I've been trying to figure out what should be added to the script. Can you please help me?
Interesting. Can you make me an editor on the sheet?
@@SpencerFarris yes. What's your email ? thank you so much.
@@candymabaquiao4445 spencer.farris@gmail.com
What a great tutorial.
is it possible to sync two way for comment?
when i make a comment in one sheet this comment is not shifted in my database sheet.
No. Apps script has no access to comments in any way
@@SpencerFarris Thanks dear. I am glad for your fast response.
@@SpencerFarris Your script working well but when i create new tab in the same sheet just for general purpose(Which is not linked with previous) , this new sheet don't take any value. is there any issue?
How do you make the refresh rate faster 😅
Like how quickly the script runs? I don't think there's anything we can do about that
@@SpencerFarris Hmm Cool. I need help with the following too .
1) Formulas in Cells Does Not Work Sample (="hi"&A3&"the amount due is "&C3&".Kindly make the payment")
2) Please share the Code with Sample to exclude certain tabs(sheets)
@@filingbee 1) Remove the parenthesis
2) I already did - this video shows the code and it's in the description. In this case it excludes "Database"
@@SpencerFarris 1) Removed-Not Working
@@filingbee Want to share your sheet with me? spencer.farris@gmail.com
Hi Spencer. Thank you again for making another version of the 2 way sync row aligned ver. I am wondering, is it possible to have 2 or more databases in a single workbook or worksheet?
Sure! You would have to do some IF() checks to make sure things are referencing the correct databases, but yah
@@SpencerFarris Thanks man!
Hi Spencer, thank you for the excellent explanation however i can't seem to get it to work in my sheets. I currently have a Master List Worksheet and a separate Worksheet for the other team members and i can't seem to get it to work so that whenever my team members edit their worksheet the new data will overwrite the existing data and appear in the Master List while corresponding to the unique ID :(
I can't do much off an explanation that "it's not working." Can you share the sheet with me?