Crash app multiscreen

[S_M]

I found the error. Screen 2 does not open because in the 4 spinners I entered too many options in each one. What way can I use if in the spinner list I have to put a lot of items?

[TIMAI2]

How many options ? (for each spinner)

can they be categorised ? You could have sub lists and dependent spinners.

[TIMAI2]

@S_M

there are 8000 options

How will this be practical for any one to select an item - 4 spinners that is 2000 options in each! Users would just give up scrolling after two or three scrolls....

You need to find another method, probably using a database with search / filtering tools.

Android runs SQLite as a local database, and there are many options for an online db.

[ABG]

This sample doc and app shows how to present huge ordered lists in List Pickers and List Views:

Ordered Search and Lookup

[S_M]

Could you give me some advice on how to do it?

[TIMAI2]

@S_M

how to do it

[FREE] SimpleSqlite - an extension for working with SQLite Databases

This is a fork/rework/remix of Tom Bennedum's open-sourced aix-SQLite extension. (all Credits to Tom!) I have stripped it back to a bare-bones/expert version, without (hopefully) affecting functionality. The key to working with this extension/sqlite is: being clear about which database file and also which database you are working with remembering to OPEN the database to carry out data operations (SELECT etc) remembering to CLOSE the database to carry out file operations (IMPORT/EXPORT etc) t…

Revival - Italo's Custom Listview Filter Bar - with Clock

With all links to Italo's guide on the above lost from appyBuilder and Thunkable, I thought I would put up a remix of the original blocks, with an aia project example. This uses a clock timer instead of a textbox extension. The only change I have made is to add an extra conditional check: does the last textbox content equal the current textbox content (if so, do nothing), to cut down on unnecessary processing. This also ensures that listview selections above the last one can be made. Clock timer…

[S_M]

I created this block to be able to read the options that can be chosen from a csv file but I can't create a search bar for a faster selection (because there are 8000 elements) and store the chosen option in the textbox. Could you kindly help me? I attach .aia file and csv file

listcsv.aia (19.7 KB)
emdncode.csv (86.5 KB)

[Boban]

Try this one listcsv1.aia (19.7 KB)

Just changed the theme and used
in your ListPicker

[S_M]

thanks a lot but it doesn't store the value i select in the textbox. How can I solve the problem?

[TIMAI2]

Use the afterPicking event to set the selection to the textbox

[S_M]

Can you use listpicker or spinner to select options (including "other") and possibly open textbox if "other" option is selected and save it? Thanks a lot

[TIMAI2]

Do not understand what it is you are attempting to do?

[S_M]

if the desired option is not present among the spinner options, is it possible to make the user write the choice? For example if I open the spinner with the choice of a name, the name I have to select is not in the list. How can I do?

[ABG]

@S_M

For example if I open the spinner with the choice of a name, the name I have to select is not in the list. How can I do?

I like to insert an extra Element to the ListPicker/ListView at slot 1, with the text "[+]" that I can test for in the Selection. If i got "[+]" I can pop up a dialog asking for the new value.

[S_M]

I have used these blocks for a listpicker, how can I use the second column of the csv file for another listpicker based on this?

[S_M]

I am attaching the csv file. How can I display the first column of the csv file in the ListPicker2 and the second column in the ListPicker3. So far I've only managed to see the first column in listpicker2.
emdncode.csv (454.9 KB)

[ABG]

Here is a snapshot of the end of your CSV file, in a spreadsheet program:

Your table has unique identifiers in column 1, and verbose multi-word descriptions of medical procedures in column 2, with occasional column 3 text too.

I am guessing you are working on a medical diagnosis or billing system, where the doctor knows the approximate procedure name but needs a fast way to look up codes for his procedure?

If you had column name headers, I could suggest building your Elements in YAML format, to contain full row data in each Element. (Alternatively, split your CSV text at \n to build Elements out of CSV rows, one row per Element.)

That would enable you to use the List Picker's filter facility to narrow down the displayed list of Elements.

Because your descriptions have lots of words in them, you might need a more general purpose filter procedure, with multiple filter criteria:

• Description CONTAINS '...' And
• Description Contains '...'
• ...

Are any of these ideas any use to you?

[S_M]

It could be useful for you to know that the first column (unique alphanumeric codes) is associated with the description of the electromedical device contained in the second column. To be precise, for example: A0101 = needles, A010101 = needles for infusion.... So if I select the code in the first column, would there be a way to load the corresponding value contained in the second column into the ListPicker or simple TextBox?

[ABG]

If you have the exact value from column 1 from the exact row, you can use the LOOKUP IN PAIRS list block to look up the column 2 value in your full table based on that column 1 value.

It should return a piece of text you can display however you want.

[S_M]

could you be more specific? which blocks are necessary to insert in order to display the corresponding value of column 2 directly in the listPicker3?