Challenge #153: And the Oscar goes to...

A solution to last week's challenge can be found here!

In case you missed it, the Oscars awards ceremony was held last night. Also, in case you missed it, we made it easy to get caught up on the nominees and the winners of each award category!

Using the provided dataset and look-up table to create an app to allow an end-user to select an award category. Render the result as .pcxml to reveal the winner of that category!

SPOILER ALERT: This challenge contains spoilers...if you want to read up on the award ceremony, it would behoove you to to do so before completing this challenge!

Fun Fact: Oscars weigh 8.5 lb and stand 13.5 inches tall!

challenge_153_start_file.yxmd

2019 Oscars Log.xlsx

challenge_153_solution.yxzp

Apps

Advanced

Intermediate

Accepted answers

All comments

patrick_digan

@ChristineB I think some of the text for A star is born was cut off in the text input tool. Apparently it was nominated for too many awards!

patrick_digan

Spoiler

Here you go!

challenge_153_start_file (2).yxmd

ChristineB

@patrick_digan Great catch! Should be fixed now.

cplewis90

This was fun and I think a follow up challenge could be around some survey data gauging how audiences reacted to having no host this year.

I still think the issue @patrick_digan brought up still exists in the file saved. I created some formulas to make sure and include it.

Spoiler

challenge_153_CL.yxzp

danilang

Not enough bling in the requested image...Tinsel Town.

Spoiler

Dan

challenge_153_solution_dl.yxzp

pasccout

Here is my solution...

Spoiler

challenge_153_my_solution.yxzp

cgoodman

Spoiler

Here's my solution. Struggled with getting the drop down filter to work, so ended up using the "connections from questions" option which works fine when it's an app but when testing you can't see what flows downstream. Plus is there a way to render the output in the interface designer?

Challenge_153_solution.yxzp

karp

Here's my solution. I also included a bit more to make sure that whichever Award Category is selected, the output will be displayed semantically correct. See screen shots.

Edit: I'm having difficulty uploaded my solution file - receiving this error: The contents of the attachment doesn't match its file type

Spoiler

ChristineB

@karp I know we've seen some issues with uploading .yxwz files in the past. Try uploading your workflow as a .yxzp file and see if that helps!

ChristineB

@cplewis90 Thanks for letting me know! I uploaded the original dataset to the post, just in case anyone else notices truncation.

rfergus

Spoiler

ddiesel

My Solution:

Spoiler

challenge_153_end_file_ddiesel.yxzp

NateW

challenge_153_solution.yxmd

JosephSerpis

Challenge Completed

challenge_153_Joe_Serpis.yxzp

ponraj

Here is my solution!

And the Oscar goes to...output.PNG

Spoiler

challenge_153_solution.yxzp

T_Willins

I had fun with the reporting tools. Added in the filter tool changes to make the syntax correct based on the award type.

Spoiler

challenge_153_solution.yxzp

estherb47

Had to pick a more "blingy" image too, so went with the one in the original post.

Spoiler

challenge_153_EHB_solution.yxzp

Sebenius

Fun to play around with the reporting tools abit.

Spoiler

Finished solution

challenge_153_Done.yxmd

Kucsi

Spoiler

It was fun and brainsmashing (i don't use the interface tools often)

challenge_153_solution_K.yxmd

catarina_pimpao

Spoiler

JamesMA

A cool app, but required a bit of configuring for the special cases of award.

Spoiler

James Marks Week 153 App.yxzp

Carlithian

Done

challenge_153.yxmd

JoshuaGostick

My solution

Spoiler

challenge_153_JG.yxzp

D12monkey

Fun Challenge.

Added the a runner's up section and made the answer semantically correct. Plus changed the bling up a bit more.

challenge_153_start_file.yxmd

D12monkey

So how did you get the text to show up in front of the image? (never mind, saw the spoiler, you used an overlay tool)

RichoBsJ

Hi! Here my solution

challenge_153_richobsj.yxzp

mtouiti

There are many tricky cases to be explored, Guys don't forget to think about brackets in the name of the category after cross tab!!!!!!

challenge_153_MT.yxmd

unknown

Enjoyed this one!

CE Challenge 153.yxzp

Sebenius

@mtouiti pointed out there was some more things to consider

added updated solution.

Spoiler

challenge_153_Done.yxzp

anovas

Hi - Here is my solution:

Spoiler

challenge_153_an.yxmd

shnbrb

First challenge result I've posted!

....got an error when trying to attach solution file "The contents of the attachment doesn't match its file type"

Solution 153 output.PNG

Spoiler

ChristineB

Glad to have you join the Weekly Challenge fun, @shnbrb! To attach your workflow, try exporting it (Options --> Export Workflow) from Designer and posting it as a .yxzp file. We've noticed that app file types (.yxwz) have given people some problems.