Spreadsheet to app

[Martin_Heggdal]

Trying to make a app where you can read different songs

I want a list from collum A
And when i press A1 it will open B1 in a text box

I will also need a search feture since i got over a 100 songs

Can anny help?

[ABG]

Since the song table is probably stable, you can download it as a CSV (Comma Separated Values) text file, and load it at app startup from a File in the Media folder.

Load it into a dictionary, with keys from column 1 and values from column 2.

Present the keys in a List Picker, with a search box.

When a key (title) is selected from the List Picker, look up its value in the dictionary and show it in a Label.

[Martin_Heggdal]

I know im far away, but how far?

[ABG]

@Martin_Heggdal

how far?

Very far.

There should be no titles or song texts in any blocks.

Start by learning lists at

Imagnity.com List Tutorial, Mirrored - @Saj

(copied from imagnity.com, courtesy of @Saj) List Blocks On App Inventor by Sajal Dutta | app-inventor, tutorials | 102 comments List is a necessity in almost every app regardless of what programming language you use. This is the easiest way to create and manipulate a set of values/items/elements in an ordered fashion. Please go over the reference before we start. In this tutorial, we will learn how to create a list, add new items to a list, display list items, replace an item in the list, re…

It should have a translate option for your native language.

[SteveJG]

Here is a tutorial that shows how to place spreadsheet data into Lists without a dictionary. Retrieve location specific Phone Numbers (or other data) from an appropriate Google Spreadsheet . Some of the code may prove useful.

If you want specific advice for your Project, share some example data with the community:

• you already have your music data in a spreadsheet. Which spreadsheet? Could you provide a readable version of perhaps the first three or four items in the spreadsheet so someone could provide a working model? This needs to be either an abbreviated copy of the spreadsheet or a text file (not an image, you have already shown us that). This information will provide an idea about what might need to be changed with your data set to provide a useful display and nice presentation of the song lyrics.
  Takks skal du ha.

• Any any item that contains commas (,) like some of the song lyrics will present issues when you convert your spreadsheet to a csv (necessary to convert it to a List).

@Martin_Heggdal

I want a list from collum A
And when i press A1 it will open B1 in a text box

Yes, this is possible.

@Martin_Heggdal

a search feture since i got over a 100 songs

Yes, you can either Filter the List or search for a key word.

There are other ways to create an app like this. Another way would be to convert you lyrics to an html.

[ABG]

Here is a sample based on Gilbert and Sullivan lyrics from

Gilbert & Sullivan

downloaded as csv from this sheet:

Gilbert and Sullivan Songs

GilbertAndSullivan.aia (6.1 KB)
GilbertandSullivanSongs-Sheet1.csv (13.9 KB)

[Martin_Heggdal]

How do i fix this?

[ABG]

(Canned Reply: ABG- Export & Upload .aia)
Export your .aia file and upload it here.

[Martin_Heggdal]

Sang.aia (286.8 KB)

[SteveJG]

[Martin_Heggdal]

Nothing is showing up when i search, is something wrong?

[ABG]

Your text file does not match the CSV table format I used to load my Gilbert and Sullivan song table.

That's why you don't see a song title list.

Here are some extracts from your song dump:

To get a legal CSV table from this text, the titles need to be wrapped with " on each end.

Since you have almost 1,000 songs in your file, this should be done programmatically, not manually.

I have an idea for how this could be done (after I make the rounds of people needing easy answers.)

[SteveJG]

@Martin_Heggdal

Nothing is showing up when i search, is something wrong?

loads this when you build the app but not when you use Companion.

[Martin_Heggdal]

Got it to work, thank you so much for the help. You guys are awesome

[SteveJG]

You probably made these changes and a little bit more work. Congratulations.

[ABG]

You are quicker than me.

Here's how I wrestled with your text file ...

Sang.aia (287.5 KB)