Timeline for Need Help With a Script to Automatically Insert Rows in a Sheet Based on Other Rows/ Data Inserted in Another Sheet
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 18, 2015 at 19:25 | comment | added | Rubén - Volunteer Moderator -♦ | @CailenSullivan. I still think that you should update your question. I will add more details as comments of it. | |
| Aug 18, 2015 at 19:10 | comment | added | Cailen Sullivan | it is probably fine the way it is unless you think one way is easier then the other? Either way I need the script to insert rows and formulas in "Overall_Formuas" based upon how many rows of data are inserted in "Raw_Data". Whether the rows are being inserted at the top or bottom does not matter from my end. | |
| Aug 18, 2015 at 12:46 | comment | added | Rubén - Volunteer Moderator -♦ | @CailenSullivan. Thanks for sharing what you just realized. As your comment include details regarding your question, please update it. | |
| Aug 18, 2015 at 4:14 | comment | added | Cailen Sullivan | Ruében I just realized something! And hopefully this makes my question a bit easier...... The reason I needed my data to be inserted as rows above is because I was using array formulas that I could not "filter". However, now that we will be pasting formulas (via script) into every cell and every row, the data will be able to be filtered. This means that I can add the new data I have to the bottom of the "Raw_Data" sheet. So really at this point I just need "Overall_Formulas" to insert formulas with the same amount of rows of data that were inserted at the bottom of "Raw_Data" | |
| Aug 18, 2015 at 0:52 | comment | added | Cailen Sullivan | Thanks Rubén. I'll wait to see your next comment on the formulas in the code itself. | |
| Aug 17, 2015 at 23:25 | comment | added | Rubén - Volunteer Moderator -♦ | The undefined variable 'e' on line 12 occurs because the input parameter 'e' it's not being passed. If you added specified onChange trigger, it will pass the required parameter every time that a change is made to the bounded spreadsheet. To run this function from the Script editor, you should create a function that populates the required properties. Regarding the second question, yes there is a way, actually there are several ways to have the formulas in the code itself. I will add more comments about this later. | |
| Aug 17, 2015 at 22:51 | comment | added | Cailen Sullivan | Thanks @Rubén for the answer! There are a couple of issues that I am running into. One, is that there is an undefined variable 'e' on line 12. Not sure what that is supposed to be? Also, the formulas I have should really never change. Is there a way to have the formulas needed to be added in, in the code itself? And will they apply themselves to the all of the rows added by the script in "Overall_Formulas" that were added in "Raw_Data"? | |
| Aug 15, 2015 at 21:11 | history | edited | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 | Updated the code of the first situation and added the explanation and code for the second situation. |
| Aug 15, 2015 at 14:54 | history | answered | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |