Profile cover photo
Profile photo
Jordan Sidfield
"Above all else, to thine own self be true" -Shakespeare
"Above all else, to thine own self be true" -Shakespeare

Communities and Collections
View all

Hi Appsheet community! I'm wondering if anyone knows how to create a function on the Detail page for a row that includes a sort of "recommendations" section. My app's primary function is to help users find sheet music for auditions. Each row contains information about a different song. So if a person were to say look at "Oh What a Beautiful Mornin'" from "Oklahoma!," it would have a section for "recommendations" that gives links to similar songs that have common information in other rows. "If you liked this song, you may also be interested in "Surrey With the Fringe on Top," "People Will Say We're In Love," or "Some Enchanted Evening." Etc.

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
Add a comment...

Post has attachment
My new demo album is now available on soundcloud! Check it out!
Canvas by Jsidfield
Canvas by Jsidfield
Add a comment...

Dear friends, family, coworkers, teachers, and peers. I am trying to compile a database for songs from musical theatre repertoire for a personal project and need your help! If you can help me by sharing the following info of at least one song from your repertoire/knowledge I'd greatly appreciate it! Musical Theatre Song Database Variables

Include the following Information about each song:

Song (Sung by “Character”): The name of the song. 

Show: The name of the show the song is from.

Composer: The name of the person who wrote the musical score of the show.

Lyricist: The name of the person who wrote the words for the music in the show.

Time Frame: When the Show was Produced.

Pre-1920's (Early/Vaudeville)
1920's (Standards)
1930's (Standards)
1940's (Golden)
1950's (Golden)
1960's (Golden)
1970's (Pre-Contemporary)
1980's (Pre-Contemporary)
1990's (Contemporary)
2000's (Contemporary)

Genre: The Style of the Show/Song

Showtune: A “Musical” type of music. Songs by Rogers and Hammerstein, Frank Loesser, Lerner and Lowe, Irving Berlin, Charles Strouse, etc.
Rock Musical: A musical with a sound inspired by rock n' roll. 
Jukebox Musical: A musical that uses songs by popular music artists.
Complex Musical: A musical with a complex score. Shows by Sondheim, Adam Guettel, or John Buchinno would fall into this category.
Contemporary Musical: A musical with a “pop” sound. Jason Robert Brown, Andrew Lippa, or William Finn are all contemporary musical composers.
Children's Musical: A musical geared towards children. “Honk,” “A Year with Frog and Toad,” and “You're a Good Man, Charlie Brown” are all good examples.
Opera/Operetta: A classical piece of music. Arias or songs composed by Gilbert and Sullivan can fit in this category.
Pop Music Genres: A variety of genres for popular songs. Includes rock, jazz, blues, pop, hip hop, r&b, funk, folk, country, reggae, world, New-age, metal, Latin American, electronic, gospel/Christian, alternative, classical, and even comedy.

Song Style: The style presented by the music, lyrics, and suggested tempo of a song.

Ballad: A slower, usually more dramatic song. 
Uptempo: A quicker, more energetic song.
Character: A song sung by a specific type of character that displays acting chops and comedic skills.
These can all have pseudo/combined styles as well such as “Moderate Uptempo,” “Blues Ballad,” and, “Pop Ballad.”

Character Type: The archetype of Character the sings the song.

Leading Man/Lady: The hero/heroine of the show. Typical characteristics can include bravery, loyalty, smarts, integrity, kindness, strength, charisma, and more. Examples of leading men include Sky Masterson in Guys and Dolls,  Frank in Annie Get Your Gun, and Curly in Oklahoma! Examples of leading ladies include Jo in Little Women, Kathy in The Last Five Years, and The Bakers Wife in Into the Woods.
Character: The comic relief of the show. Has a wide variety of possible characteristics. Typical characteristics can include witty, stupid, odd, perverse, smarmy, wacky, annoying, unique, gullible, crazy, silly, brassy, and more. 
Examples of character men include Max Bialistock from The Producers, Nicely Nicely Johnson from Guys and Dolls, and Snoopy from You're a Good Man, Charley Brown. Examples of character women include Logaine Schwartzengrubenyere from The 25th Annual Putnam County Spelling Bee, Little Red from Into the Woods, and Adelaide from Guys and Dolls.
Villain: The antagonist of the show. Typical characteristics include evil, manipulative, sociopolitical, sadistic, creepy, dishonest, maniacal, selfish, violent, arrogant, rude, stubborn, and more. 
Examples of male villains include Judge Turpin from Sweeney Todd, Bill Sykes from Oliver!, and Dr. Parker from Bat Boy. Examples for female villains include Ursula from The Little Mermaid, Mrs. Meers from Thoroughly Modern Millie, and The Witch of the West from The Wiz.
Romantic Youth/Ingenue: The love interest of the show. Typical characteristics include sweet, vulnerable, innocent, wondrous, romantic, and naive. 
Male examples include Tony from West Side Story, Hero from A Funny Thing Happened on the Way to the Forum, and Matt from The Fantastiks. Female Examples include Rosebud from The Mystery of Edwin Drood, Julie Jordan from Carousel, and Cosette from Les Miserables.
Motherly/Fatherly Figure: The parental/matriarch/patriarch character of the show. Typical characteristics include wise, powerful, caring, loving, protective, stern, old fashioned, and more.
Male examples include Stuart from Caroline or Change, Warbucks from Annie, and Tevye from Fiddler on the Roof. Female examples include Meredith from Bat Boy, Marmee from Little Women, and Mother Abess from The Sound of Music.
Song and Dance Man/Woman: A showman/woman's primary purpose in the show is singing and tapping up a storm. Typical characteristics include having strong vocal/dance technique, charisma, stage presence, charm, poise, elegance, enthusiasm, and precision. 
Male examples include Don Lockwood from Singin' in the Rain, Billy Lawler from 42nd Street, and Robert from The Drowsey Chaperone. Female examples include Velma Kelly in Chicago, Mayzee from Seussical and Ula from The Producers.
Scholar: A character who is very book smart. Usual characteristics can include intelligence, firmness, curiosity, shyness, imagination, vision, and more. 
Male examples include Edgar from Bat Boy, Motel from Fiddler on the Roof, and Henry Higgins from My Fair Lady. Female examples include Ruth from Wonderful Town, Olive from Spelling Bee, and Vivian from Legally Blonde.
Traditionalist: A character who holds on to the ways of the past to guide their actions. Typical characteristics can include, stubbornness, nostalgia, traditional, sternness, boldness, and more.
Male examples include Mr. Snow from Carousel, Javert from Les Miserables, and Mr. Bumble from Oliver! Female examples include Sarah from Guys and Dolls, Caroline from Caroline or Change, Aunt March from Little Women.
Lustful Male/Female: This character often seems to... get around a lot. Not always by their own will. Typical characteristics can include being brash, raunchy, inappropriate, flirtatious, suave, fickle, indecisive, and more.
Male examples include Aldolfo from The Drowsey Chaperone, Trekkie Monster from Avenue Q, and The Wolf from Into the Woods. Female examples include Lucy from Reefer Madness, Bianca from Kiss Me Kate, and Aldonza from Man of La Mancha.
The Rebel: A character that would prefer to shake things up in their society. Typical characteristics can include being proud, bold, rash, challenging, defiant, discontent, restless, passionate and more. 
Male examples include Ren from Footloose, Melchior from Spring Awakening, and Enjolras from Les Miserables. Female examples include Emmie from Caroline or Change, Tracy from Hairspray, and Millie from Thoroughly Modern Millie.
Tragic Hero/Heroine: A character who maybe means well, but who's faults become their undoing. 
Male Examples include Sweeney Todd from Sweeney Todd, Leo Frank from Parade, and Luis from Kiss of the Spider Woman. Female examples include Eponine from Les Miserables, Desiree from A Little Night Music, and Wendla from Spring Awakening.
The Best Friend: Sticks with the main character through thick and thin, for better or for worse. Typical characteristics include loyalty, friendliness, honesty, trust, and more. 
Male examples include George from The Drowsey Chaperone, Sancho from Man of La Mancha, and Moritz from Spring Awakening. Female examples include Penny from Hairspray, Rusty from Footloose, and Cleo in The Most Happy Fella.

Many characters in musicals can have a much wider arc and fit into multiple of these categories. There can be Character+Motherly/Fatherly characters such as Mr. MacAffee from Bye Bye Birdy, Rebel Scholars such as Perchick from Fiddler on the Roof, Lustful Villains such as Jasper from The Mystery of Edwin Drood, and many more.

Plenty of characters also may not fit into any of these categories as well due to the specificity, complexity, and unique qualities of their traits. Feel free to make up a character type for these characters.

Age Range: The age range of the character in the song.

Child (Ages 4-10)
Young Boy/Girl (Ages 11-15)
Juvenile (Ages 16-20)
Young Man/Woman (Ages 20-35)
Middle Aged Man/Woman (Ages 35-55)
Older Man/Woman (Ages 55+)

Voice Type: The vocal range of the song.

Bass – Low Range Male
Baritone – Mid Range Male
Tenor – High Range Male
Alto – Low Range Female
Mezzo – Mid Range Female
Soprano – High Range Female

Popularity: How often the song is done.

1 – Never Done
2 – Unknown
3 – Uncommon
4 – Less Known
5 – Known
6 – Well Known
7 – Very Well Known
8 – Common
9 – Often Done
10 – Overdone

Your help would be extremely appreciated! If you have just a few minutes to do even one song that would be amazing! I hope you are all having a great new year!


Add a comment...

Post has attachment
Add a comment...

Hey Guys! Jordan Sidfield here! I'm participating in Monterey Bay Idol, a music contest, and need YOUR votes to win! If I win I get to professionally record an album of my original music! It literally takes less than 10 seconds to vote, and just as much time to share the link with your friends and get them to vote as well! It would seriously mean the world to me if you can help me win this thing. Vote here! And be sure to tell your friends! Thanks guys!
Add a comment...

Post has attachment
Jordan Sidfield plays a colorful variety of acoustic funk, folk, R&B, and rock on the ukulele, with Isaiah Roberts on stand up bass on back up. Enjoy an evening of music that will make you dance, laugh, cry, and fall in love all over again. Admission is FREE!
Add a comment...

946 e-mails later and my inbox is finally clear of spam and Backstage articles.
Add a comment...
Wait while more posts are being loaded