App inventor + spreadsheet

[Ezra Epriputra]

If i have db from spreadsheet then i going to show in list view.Is it possible to filter list from csv format, then show in listview, but the filter process not in the spreadsheet but in the app inventor using blocks? I already read about list of list a list but never see the tutorial about that if there any. Maybe someone know this...

[TimAI2]

Do you want to filter in the spreadsheet and not in the app?

[Ezra Epriputra]

Noo...i want to filter on app...not in the spreadsheet

[TimAI2]

What is in your table (provide example) ?

How do you want to filter, by which fields / content / etc. ?

What is to happen once the filtered list is put in a listview (e.g. after Picking) ?

[TimAI2]

Here is an example.

The table.csv contains a list of lists, on item in each list is a colour

We grab the colours and put these into a Spinner

After selecting a colour with the spinner the listview

is returned with only those names that have that colour

aia attached

SCREEN

BLOCKS

[Ezra Epriputra]

thanks for your aia...its help me alot...

this is my example

this is my table from spreadsheet

This is my Block for Screen 2 and 3

This is My Result

When i choose after pick from selection index..the index is not match with the data view in listview...maybe because on the block i still refer to variabel "global member' at the after pick listview block

i have already to change it but im stuck and confused. can you help me with this? i want after that filter, after pick always match with the listview.

thanks

[TimAI2]

Don't understand the problem, it all seems to follow through..

You pick users

Listview displays "users"

You pick on of the "users"

Returns all details about that user

??

[Ezra Epriputra]

it's not...

i will show you...this is same block as it is...

see my attached video...

when i open selvy its Brandon

when i open ronald its Edi

[TimAI2]

The problem is here:

You use the filtered shorter list index for the original longer list

What you will need to do is either add all the items (name, classification, car, hob) from the inputList for each match to the listviewlist and then replace global Member with Listview1.Elements (light green block)

or create another global list below listviewlist that has all the filtered items with all the original list items(name, classification, car, hob) in it, then use that as the list to replace global member

[Ezra Epriputra]

can you help me with the block?

im little bit confused...

im attached the aia for you

thanks

[TimAI2]

Here you are (see aia attached)

You will see on Screen 2 I have added a new variable for a list: FilteredMember

and this is added to in the same way as the listview1 list based upon "user" type

This means that both of these lists will have aligned indexes

I replaced "global Member" with "global FilteredMember" for the start value

You will see that the results on Screen 3 now match the selection on Screen 2

Not sure why you will need more than one screen for this though, please read below and look at the examples (e.g. Tabbed Screen Demo) for ideas:

Use different screens wisely

• Before starting to create another screen, first you should think about is it really necessary? 
  
• See also Building apps with many screens and SteveJG's post about advantages/disadvantages, because in only one screen you also can use vertical arrangements to simulate different screens, just set the arrangements to visible = true/false as needed... 
  
• See also Martyn_HK's example about how to use Tabs in App Inventor and another example from Cyd. and my Tabbed Screens Demo
  

If you decided to use different screens, then you should switch them correctly, else you will run out of memory after a while...      
The recommended method of switching screens in App Inventor

(Thanks Taifun)

Also see demo: multiscreen.aia

If you haven't done it already....

Read:  The FAQ  TUTORIALS  USING IMAGES  BLOCKS  COMPONENTS  EXTENSIONS  LISTS