roundhouse | Database Migration Utility for .NET using sql files | SQL Database library
kandi X-RAY | roundhouse Summary
kandi X-RAY | roundhouse Summary
Project RoundhousE - Database Change Management done right.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of roundhouse
roundhouse Key Features
roundhouse Examples and Code Snippets
Community Discussions
Trending Discussions on roundhouse
QUESTION
I have a Google Sheets spreadsheet. In 'Main' worksheet I have a drop down list in Column A. The information in this drop down is being pulled from Column A of 'Places' worksheet.
For purposes of space saving on the 'Main' worksheet I am reducing the place names down to 2 or 3 letter abbreviations so as an example Pontypandy would become PP. Is there any way that when I pick 'PP' in the drop down on the 'main' worksheet, there is an automatic note added to it which would read 'Pontypandy' and would be visible to anyone who hovered the cursor over that particular cell?
Further Detail:
Below is my most recent effort at the script that you have kindly helped with to include the recent modifications you gave me which are in lines 3 and 4. Please don't be alarmed by the difference in sheet names, I have now moved onto my actual spreadsheet having been working in a test environment previously so I am now using the correct sheet names as detailed in the script below.
...ANSWER
Answered 2020-Apr-08 at 22:38- There is the drop down list at the column "A" in the sheet of
Main
. - When the drop down list is changed, you want to add a note to the active drop down list.
- For example, when the drop down list is changed to
PP
, you want to addPontypandy
corresponding toPP
to the cell of the drop down list.
- For example, when the drop down list is changed to
If my understanding is correct, how about this answer? Please think of this as just one of several possible answers.
In this answer, I would like to propose to use Google Apps Script and the OnEdit event trigger of the simple trigger. The conversion from PP
to Pontypandy
is run by using the object.
Please copy and paste the following script to the container-bound script of the Google Spreadsheet and save it. When you change the drop down list at the column "A" in the sheet of Main
to PP
, the script is run by the OnEdit event trigger, and you can see the value of Pontypandy
as the note.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install roundhouse
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page