Merge table with it's smart dropdown dataset.

[Mar Demolag]

Hi,

Is it possible to use Table Merger macro for merging two forms (f1 and f2) with a common key (name), when the key on f1 is of type Smart Dropdown that uses f2's as dataset?

this is what I currently get when attempting that:

Thanks in advance

[Alex Medved _ConfiForms_ · Accepted solution]

You can merge data from forms that share the same value (smart field and text field do not have the same value)

https://wiki.vertuna.com/display/CONFIFORMS/Merging+the+data+from+forms+with+different+structure+sharing+a+common+key

In your case with a smart dropdown - what do you merge? You can build a view over the form that has a smart dropdown and ACCESS any field value from the form that this smart dropdown is referencing. 

Alex

[Mar Demolag]

Hi,
What I'm attempting to do is a table view that shows all of the values from F2, and if they are used on the F1 form through the smart dropdown, I want their additional info (else, leave the column empty).

I though that merging the tables will give me this effect, but as you explained, the values are of different type.

[Alex Medved _ConfiForms_]

OK, I believe a TableView over the F2 is what you should be using and for the extra columns from the F1 you can use a queryAndRender function https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

id.queryAndRender(F1:@self;name:[entry.id];info;card)

Alex

[Mar Demolag]

Thanks alot!
While that answer the question I asked, I've just realized my problem is a bit more complex.
Will open a new question for that, hopefully it's possible.