On http://formspideronline.com/formspider/main.html?name=DemoMain#DemoGrid you have a button which opens a LOV component and when you select a value it brings it in the grid. The demo does not show how you set the grid column to get the LOV value. On the LOV example you use

<targets> <targetof lov="LOV_employees" column="FIRST_NAME"/> </targets>

On the grid though you don't have the option to choose targets. How am I support to set the column with the value i'm bringing from LOV.


asked 18 Feb '14, 08:10

chris2014's gravatar image

accept rate: 0%

Hi Christos,

You can type the target component in the second tab of the LOV Dialog. In your use case (Grid), use target type Datasource and enter [datasourceName].[columnname] in the target field. Obviously, the datasource name you should use is the datasource name of the Grid.

Kind Regards,


answered 18 Feb '14, 08:12

Yalim's gravatar image

Yalim ♦♦
accept rate: 20%

edited 18 Feb '14, 08:15

Excellent. Thanks. Is working now. Is there a way to populate LOV data based on a value that is coming from the row of the grid? For example i have materialid and then on the LOV component i need to populate materialdetailid of that materialid. How do i do that?

(18 Feb '14, 08:57) chris2014

Use a button to show the LOV and a textfield, instead of just one LOV field. Then behind the button that calls the LOV, do what you want to do and then show the LOV.

Kind Regards,

(18 Feb '14, 09:01) Yalim ♦♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 18 Feb '14, 08:10

Seen: 1,745 times

Last updated: 18 Feb '14, 09:01

© Copyright Gerger 2017