Using Text Box Object to select items

[#1]

Hi there, I'm trying to use a text box to select a specific item.

I have a 'question_id' field with a series of question numbers to choose e.g. 6, 7, 8 ,9 see below

I would like to be able to select question_id 6

and then return the associated text string from the field 'dual_headings' in a seperat text box on the same sheet

so 'question_id' 6 returns the text 'In order to maximise...........'  from the dual_headings table below.

I'm trying to make the user interface cleaner for the selection of items on the qv sheet

Any help would be much appreciated.

Thanks

Rob

[alexandros17]

try this expression in the text box:

=if(GetSelectedCount(question_id)=1, dual_headings, null())

[Gysbert_Wassenaar]

Use as expression for the textbox: =dual_headings

[#4]

Hi Alexandros

I added this expression to the text box and it returned ' - '

[#5]

This worked for the text box I want to present the returned selected text.

Just need to sort out the selection piece.

Thanks for this

[alexandros17]

You have to click on the question_id you want

[#7]

Ah sorry, right  - what I was trying to do was use a text box which was labelled e.g. Workplace Productivity

Then sellect the text box to pull up that question_id associated with that text box e.g. question_id 6

So I think I should be using the 'actions' function in the text box.

Sorry if I have confused you.

Any suggestions based on this?

Rob

[Gysbert_Wassenaar]

Perhaps you can use a multibox control positioned just above the textbox. Add the question_id field to the multibox. You can then select the question_id in the multibox and the text for that question will be shown in the textbox below.

[alexandros17]

When you select a row in a table , you can access all the fields of that row, and this is what happens in your text box (in which you control tat only one row is selected) and show the value of the column with the description. All this is done automatically, you don't need any action to be defined.

Hope it helps

[#10]

I'm trying to use a test box as a selection of a question instead of selecting the question id in a table.

It's so I can present a short name for that question.

I can see that you can select a text box(or button) to do something.

Would using a variable work in some way.

Thanks

Rob