Challenge #365: LEGO® My Data!

[sknman92]

my solution

[Rob-Silk]

Standard solution:

Spoiler

App-based solution:

Spoiler

[snbandi]

My solution for Simple version. Intermediate to come later for after more experience with other tools.

[asultanov]

Solution & app attached.

[becky-pattinson]

Spoiler

[Mikeimbi]

With App

[Lucy_Hickman]

The challenge_365_solution app does not contain an error message for "Sorry, the ID number you entered does not exist." 

I would have liked to have seen how you include an error message when a user enters an ID that doesn't match to an ID in the column ID. I've only seen error message displayed when the input doesn't match a certain format. 

[Lucy_Hickman]

The best Error Message Expression I could come up with is 

REGEX_Match([#1], '^(?!\d{4,5}$).*$')

this will only be true when its not a 4 or 5 digit number. This will still allow invalid 4 or 5 digit IDs to pass through the workflow and the user will only realize once they open an empty PDF. 

[mwong]

what a challenge.  my solution:

[toby49]

My solution:

Spoiler