Populate Option Menu from Array [Solved]

[antrax13]

Hi I have an array that is coming from DB so every time it will be different.

When array is created I need to populate Option Menu button with these values.

My Code is:

Code: Select all

 repeat for each element title in tColumnTitles
         --answer title 
         put the text of btn "omLocation" to title
 end repeat

it will set the value always to last element in array and I would like to see all elements to be available/visible in Option Menu dropdown not just the last one

so IE if array contains Peter,John,Martin

I want to see all options in dropdown not just Martin

[jmburnod]

Hi,
What about this ?

Code: Select all

on buildMyMenu
   put "Peter,John,Martin" into tColumnTitles
   replace "," with cr in tColumnTitles
   set the text of btn "omLocation" to  tColumnTitles
end buildMyMenu

Best regards
Jean-Marc

[Klaus]

Hi antrax13,

1. welcome to the forum!

2. That depends on your Array! What format does your array have exactly?
e.g. like this:
tColumTitles[1]["Peter"]
tColumTitles[2]["John"]
tColumTitles[3]["Martin"]
...
?


Best

Klaus

[antrax13]

Code: Select all

 
local lTest
      repeat for each element lTitle in tColumnTitles
         put lTitle & cr after lTest
      end repeat
      set the text of btn "omLocation" to lTest

this did the trick and now all options are visible in option menu button

[Klaus]

Glad we could help!

[CAsba]

Where is the code put ?

[jmburnod]

Hi CAsba,

Where is the code put ?

set the text of...
Best
Jean-Marc

[CAsba]

Hi Jimburnod
Sorry, I don't get it. I have a csv array in a field, consisting of current year, current year less 1, less 2, etc., that I want to put as a list of choices for the user. How best to populate the menu choices space ?

[dunbarx]

CAsba.

So you do not have an "array", but just text in a field. Be careful, since "array" means something very specific in LiveCode.

Is your data comma delimited, as "csv' implies? if so, you can create a cascading menu to display the data.

Craig

[CAsba]

Hi Craig,
yes, it is comma seperated, in a field. I guess I don't know what an array is, then...
So, how would I proceed to set up a cascading, or other, drop down menu, with the values in the field as choices ?

[dunbarx]

It occurs to me, do you know how to create a hierarchal (cascading) menu? I ask because I am not sure that an option menu is a good choice. Each of the four menu buttons acts a little differently. Read about this in the User Guide, page 176.

Check out this stack, which has all four menu buttons. Play with it. If you need more submenus, try to make them, and come back here if you need help.

MenuTest.livecode.zip

(1.27 KiB) Downloaded 148 times

Craig

[CAsba]

Hi Craig,
True, I know very little about the various menu possibilities. But, I used the option type successfully to allow the user to choose the day and the month of the date required. The difference with the year is that the current year has to be one of the choices, with the other choices being current year -1, -2, -3 etc. So, it's a dynamic choice, which will change every year, unlike the day and month choices. So, instead of manually populating the option menu, as I did with day and month, it is necessary to get the current year listed as a reference for the choices.
So, the situation is, to recap, the option menu appears to offer the required facility, as shown in the month and year menus, but I need a way to insert, as choices, a list of years headed by the current year. I have read quite a lot about setting up menus but nothing to enlighten me re this issue.
Hoping you can help.

[dunbarx]

Keep talking.

This is simple. The keyword "dateItems" allows full control of dates and times. One can add or subtract values from the several parts of that gadget, and obtain any other date and time. Please experiment with this until you have it down. It is not complicated and actually fun to do so.

You will soon see that one can "convert" (a command), for example, today's date to "dateItems". When you get that value, add, say, 50 to the third item. (the "day of the month"). Once you do that, convert back to the long date. You will see that all the math has been done for you and the new date, over seven weeks later, is properly formatted. With that tool you can then create the list you require.

Get going, and if you need more help, come back.

Craig

[jacque]

Since you only need the year, you can get that from the date function. Either parse it out from the date or convert the date to dateitems and get item 1 of that.

After you know the current year it is easy to subtract 1 from it as many times as you need. Keep the years in a return-delimited list. When the list is ready:

Code: Select all

set the text of button "years" to tList 

[FourthWorld]

This thread is conceptually similar; would it be helpful to future readers if I merged this one with that?

https://forums.livecode.com/viewtopic.php?f=7&t=37440