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
You can merge data from forms that share the same value (smart field and text field do not have the same value)
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.