Help Returning a label from a database join

[cazmont]

I am new a writing javasript and am wanting to know how to return the label from a database join.
I have 4 database joins on a form, each places the value from the join into an element on the form.
I want to take all the labels of that join and concatenate a string of the 4 labels.

Can any help.

 

[cheesegrits]

Use a calc element, with AJAX enabled.

The code would be something like ...

return '{table___element1} {table___element2} etc';

-- hugh

 

[cazmont]

That worked thank you, I want to also be able to save this to an element to use that concatenated string after as the label in a database join describing this record.

this code only returns me value, is there an equivalent that returns the label

var sectionlabel=Fabrik.getBlock('form_10').formElements.get('sections___SectionStyle');
alert((sectionlabel.get('value')));

 

[cazmont]

Ok I have worked out I can use that calc field then store to and element on the page elsewhere as per the script above.

something like this

var sectionnew=Fabrik.getBlock('form_10').formElements.get('sections___SectionDescriptionCalc');


var sectiondesc=Fabrik.getBlock('form_10').formElements.get('sections___SectionDescription');
sectiondesc.update(sectionnew.get('value'));

where SectionDescriptionCalc is the calc field

 

[cazmont]

Can anyone further assist me here as a solution is not being forwarded,
I am still looking for how access to group elements can be done and suming those elements on a form.

 

[cazmont]

commented on wrong thread this one is closed