2017년 6월 13일 화요일

Help with condition menu's


Hi, Is anyone able to help me with information on how to program conditional menus, 

What i am trying to do is this,

I have a make, when i select the make i get models that are specific to that make, when i choose a model i want to have a data ID ( is   Ford,  Escort,  1011)   put on the screen and then press an upload button and the dtaa is sent via bluetooth to an arduino.

I have found some info on making a two level menu but i cant find a way to make the 3 level and have the data appear on the screen.

Any help appreciated

--
Why not simplify things, create a csv file and then use:


or


If you really need to use AI2 lists then read :


-- 
this would be a nice example to use the local SQLite database, see also my SQLite extension here 
SQlite Extension to access the local SQlite database
alternatively if your data changes frequently, you might want to consider a server database instead, for example a fusiontable, see the Pizza Party tutorial for details 

create a table with the following columns: make, model, dataId

then to get a list of the makes use this SELECT statement
SELECT make FROM <tablename> GROUP BY make

to get the model of a selected make use the following SELECT statement
SELECT model FROM <tablename> WHERE make = <selected make>

to get the data id fo a selected model, use the following SELECT statement
SELECT * FROM <tablename> WHERE model = <selected model>

you also could do this with data stored in JSON format and TinyDB, but this will be cumbersome, because you have to use lots of logic and blocks, see also this discussion here https://groups.google.com/d/msg/mitappinventortest/uF7G8tViRgk/w4ZVVJQiAQAJ

--
Take a look at my spreadsheet tutorial HERE to see if that helps you out.

--
But in answer to your question here are blocks and a small video





-- 
See this doc and app for how to code unlimited depth menus ...

-- 

댓글 없음:

댓글 쓰기