Merge table with it's smart dropdown dataset.

Mar Demolag November 21, 2024

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:

table merger dropdown dataset.jpg

Thanks in advance

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 21, 2024

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 November 28, 2024

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 28, 2024

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 November 28, 2024

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events