Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Tap Forms Template Exchange › Watched TV Shows
December 9, 2018 at 2:45 PM #32553
Playing around some more with Tap Forms’ scripting. I created a form that lets me pull a TV series from IMDB and then also creates a table within each record with a list of all of the episodes. I have a checkbox that I can check off whenever I watch an episode.
Couple of nice features:
- The “Completed” checkbox in the form will check off all of the episodes in the table</l1>
- If all of the episodes are marked as watched, the “Completed” checkbox will get checked
- You can add the same series twice. It won’t create a new record. If there are new episodes, it will automatically add them to the existing record.
To use this, you’ll need to create an API key at http://www.omdbapi.com
December 9, 2018 at 2:47 PM #32556
- This topic was modified 8 months, 1 week ago by Ryan M.
For those curious, here is the script for pulling the TV show and its episodes from omdbapi.comDecember 9, 2018 at 10:22 PM #32567
That’s fantastic! Great job with the scripting!
BrendanJuly 13, 2019 at 6:41 PM #35899
This looks great but I’m a bit stuck on how to make it work. I have imported the template, but unsure how to generate the api key or where to put it
Any help would be appreciated
AndrewJuly 13, 2019 at 7:18 PM #35900
Ok I have now managed to generate an API key and have pasted that in the script in TF.
Now when I run the script it asks for a IMDB URL which I paste in (example for The 100 would be https://www.imdb.com/title/tt2661044/ but then the script does not seem to do anything after that.
Is there something I am missing.?
AndrewJuly 17, 2019 at 9:19 PM #35934
I just tried the script again in my own form and it worked fine. Do you see any errors or anything when clicking on the menu Scripts > Show Console Log? Keep that window open when running the script.
One thing I’ve noticed is that the TV show won’t automatically appear. You have to click out to another form and come back and it’ll be there.
– RyanJuly 19, 2019 at 7:11 PM #35960
Thanks for your response. Yes the clicking away from the form did resolve the issue of the script not appearing to run.
I have found one other oddity though if you wouldn’t mind checking it out. Again using the V series The 100 via https://www.imdb.com/title/tt2661044/ if I run it now it does not pick up any new episodes since the first time the script was run.
In the case of the The 100 there are at least 9 new episodes list on imdb that the script is not picking up and adding to the table.
I have tried deleting the table and re running the script but I get the same result. In case you want to try he same I have added a screenshot showing what my most recent episodes are
Many Thanks for your help
AndrewJuly 20, 2019 at 7:58 AM #35963
Hey Andrew – Do you see any errors or anything when clicking on the menu Scripts > Show Console Log? Keep that window open when running the script.July 20, 2019 at 9:36 AM #35964
Where do you use the API key? I’m a total newbie, so this is probably too advanced for me- BUT, I’d love help. I got the API key. And, I imported the form. Just don’t know where to go after that…
Thanks in advance,
YvetteJuly 20, 2019 at 1:36 PM #35971
Hi, I figured out where to put the API key. Now, how do you make the script run? When I go to scripts/ show console log/ it stays blankJuly 20, 2019 at 1:44 PM #35974
There’s a Run Script button on the Scripts tab for Mac. Click the Scripts tab, then select
Import from imdband then press the Run button. It looks like a black triangle. Like a play button on a video or an MP3 player.
On iOS, view the list of records in the form, then tap the action menu button, then tap on the Run Script command.
BrendanJuly 28, 2019 at 6:27 AM #36073
This is brilliant, thanks. Until now I have been tracking my TV show progress with a spreadsheet, but this script does a much better job.
One issue though – the table seems to miss some episodes, even though they’re there on IMDb (see attached).
You must be logged in to reply to this topic.