Drop-down list of texts for subtitle structure

[TIMAI2]

I am having a look at this, working with listviews, got first and view of second levels sorted, second level and view of third level is exponential!

[elmachi130]

I'm also working on it, but to continue, I need to get the title and subtitle in different tags.

With this, I can now link it to the screens.

[Taifun]

Let me suggest to use the local sqlite database, you can have as much columns as you like and have nested listviews with n dimensions, just store your data in a table

For example to get the first column

SELECT A FROM myTable GROIUP BY A

Then after picking an item from Listview1

SELECT B FROM myTable WHERE A = Listpicker1.Selection GROIUP BY B

Then after picking an item from the Listview2

SELECT C FROM myTable WHERE A = Listpicker1.Selection AND B = Listpicker2.Selection GROUP BY C

There is my paid sqlite extension App Inventor Extensions: SQlite | Pura Vida Apps available, which follows the KISS principle (Keep it simple stupid), there are also other sqlite extensions available

Taifun

[TIMAI2]

Try this:

expLV.aia (10.1 KB)

Uses 5 listvews, no extensions (@ABG would be proud ). In essence when an item is selected, the listview is split in two, to display the sublist between the two upper level listviews.

Not possible to set text colour of selections...

[ABG]

How do I Correctly SQL?

Here is a useful utility (Tidy) to show the structure of a given value: tidy.aia (3.6 KB) [tidy] [tidy_helper] sample output: [top of output] This works best in conjunction with the AI2 Do It debugger. P.S. These blocks can be dragged directly into your Blocks Editor workspace.

This is one way to show structure in a Label

[ABG]

How to button search for MIT in my app

This sample shows how to represent a tree structure in a table, and one way to offer navigation within the tree

[elmachi130]

It's not just the color of the selected text.

The other thing is the space generated from row to row.

It's much more voluminous.

Is there any way to reduce it?
I've already tried reducing the field in pixels and it crops it.

[TIMAI2]

If you are referring to the listviews approach, there is no method/property to reduce the padding above and below the text, you can try reducing the font size, looks like this with Font reduced from 22 to 14:

There maybe listview extensions available that can help you with this further.

[elmachi130]

I'd like to simplify the text into a single variable so I don't have to repeat it in each column.

It won't let me.

[TIMAI2]

@elmachi130

It won't let me

It will...

[elmachi130]

This time, I'm trying to set restrictions for users (A and B), for example:

User A will have access to (Column A 01).
User B will have access to (Column A 02, Column A 03).

I've already managed to hide it, but it leaves me with an empty space. What I'm looking for is:

For the text to be displayed, and for it to not have any action that would take me to the next column.

And if possible, change the color from black to gray.

Or, if not, eliminate this empty space that's creating space.

Question:
Can variables be disabled?
So as not to delete content.

Regards.

expLV (1).aia (15.1 KB)

[elmachi130]

Disable (name)
What I'm trying to do is:
When screen starts, I get the text (aaaaa) in the label (x) with the variable (name).

I try to disable (name) with the button.
Then I can enable it with another button.

I don't understand the purpose of this block.

Perhaps my approach is flawed. Could you give me an example?

[TIMAI2]

@elmachi130

Question:
Can variables be disabled?
So as not to delete content.

Store their values in tinydb
Don't use any blocks that might overwrite the content

where does this block come from ?