Sidebar Only Processes Submission on Next Submit

[Frayda Zirkind]

Greetings all, 

I have a custom menu on a Sheet, made by Apps Script, that includes an option to bring up a sidebar and input data. That data is, upon submission, supposed to paste onto one sheet in the spreadsheet and then copy over to another sheet (both are called up in the Apps Script by their name). 

When I originally made the Script (kudos to a member of this Community with providing me with a sample), it worked perfectly. Now, though, when I submit the data in the sidebar, it copies over to the second sheet immediately, but it only registers in the first sheet when I submit another form in the sidebar. 

For example: 

My first sheet is a list of customers and their phone numbers. My second sheet is a list of the customers' names and their order. The names automatically pull from the first sheet (upon sidebar submission) and the orders I put in manually. 

Now, I open the sidebar and input that Clayton Bowers (917-416-9708) placed an order. Nothing happens on the first sheet. On the second sheet, I see Clayton's name. A few minutes later, I submit the sidebar again with James Crosby (347-778-2114). James comes up on the second sheet and Clayton now appears on the first sheet. (It goes without saying that James does not appear on the first sheet now; we need to wait for another order before he appears.)

Any ideas of why this is happening?

Thanks!

[Keith Andersen]

We need to see the sheet or at least the code that you are using. 

Share the sheet if you're able to and it does not have sensitive data. 

You could even copy it and in the copy all of the data and then share that sheet with us so we can see set up as well as code.

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/c105644b-2a16-46d2-b049-8820e1beb300n%40googlegroups.com.

[Keith Andersen]

Sorry. I meant copy the sheet and clear all the data and then share the copy sheet

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

[Frayda Zirkind]

Hi, 

I duplicated my Sheet and changed all of the information. I also copied over my Apps Script to this new Sheet. You can view it here: https://docs.google.com/spreadsheets/d/1qr18cg5XjTejY2DdktHlTkYtJBI3EDGKr1pna1j6hic/edit?usp=sharing

Thank you!

[Keith Andersen]

I remember the Volunteers sheet I made for you. This is an adaptation of that.

What's not clear is exactly what you want to accomplish.

You have the sheet adding rows - but it also adds 500+ columns. Do you need all those columns?

What data do you want entered and where? Please be specific using the sheet names and rows/columns.

Keith

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/d2fa0380-9108-4d37-badd-409d8c1eb46en%40googlegroups.com.

--

My Site: https://www.sites.google.com/view/klaweb/

My Google Stuff: https://sites.google.com/view/klaweb/google-sheets-stuff

Passions: God, Family, Friends, Scripture, Data Management, Google Sheets + App Script, MS Access, Programing, sharing and much more.

[Frayda Zirkind]

This is my issue right now:

Upon submitting the sidebar, the sidebar is supposed to enter the relevant information into the 2026 sheet. The record number goes into column A, the last name into column C, the first name into column D, the phone number into column E, the buddy's name into column G, the day of the week into column H, and the birthday into column I. 

Then, it's supposed to copy the record number into column A of Sheet2, the last name into column B, the first name into column C, and the day of the week into column H. 

What the sidebar does now is process the information onto Sheet 2 immediately upon submission but will only process the information onto 2026 when I submit the sidebar again. 

[Keith Andersen]

Fixed

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/f0102ba4-0969-45bc-ba7e-435ffe38a781n%40googlegroups.com.

[Frayda Zirkind]

Thank you!!! It works perfectly now!!

I also saw that you simplified my formula for extracting the months from the birthdays - thank you for that as well!!

Have a wonderful day!

[Keith Andersen]

😉👍

My website: https://sites.google.com/view/klaweb/
Passions: God, Family, Scriptures, Learning, Data Management, Google Sheets + App Script and much more!

To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/f9e4a0e1-e0cb-4b2b-91bd-a162c6bc0f07n%40googlegroups.com.