Hello folks,
I'm a systems admin who is looking to improve his scripting and macro
skills. So I'm working on a fun little project for my friends and I that
could also help me understand some more spreadsheet scripting as well.
We've been having regular double feature movie nights and to keep up with
all of our ideas and planning of when to view them, I thought I could
organize that in a spreadsheet. The idea I envision now is that a cell near
the top of the sheet, say A1 is an input box where I or my friends would
submit a movie title we want to add to the list. Upon submission, I'd like
for that text to be copied down into the next available empty cell in
column A.
Column B has another job. Starting in B2, I have the formula =HYPERLINK("
http://www.imdb.com/find?q="; & A2, "IMDb"). This creates a hyperlink to the
IMDb search page and passes in the movie title from column A when the
hyperlink is clicked, resulting in a successful search on IMDb's website.
However, I'd really like this to be an automated task. Right now Column B
is only filled manually when I use the fill handle on the above cell. I see
the workflow going like this:
User enters title in A1 input box -> Text is copied from A1 into next
available cell in column A -> Column B of the same row is then updated with
the above formula, automatically creating the hyperlink and passing the
movie title text into that hyperlink so that an IMDb search can be
performed.
Does that make sense? I have some other ideas I'd like to implement also,
but I figure I better take this one step at a time.
Also, I did search the script gallery and found one published that does
IMDb lookups and actually returns the data about the film into a popup
window (complete with box art!). However, my testing with it was subpar. It
would return results that didn't exactly match the text I had entered. I
like my idea of just launching an IMDb search window, because that way you
don't have to be exact on the spelling or wording of the title and still
find what you're looking for.
Thanks in advance for any and all help!
Bryan
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
