by Izertis

Create documents in docx, xlsx (MS Office Word and Excel), odt, ods (LibreOffice and OpenOffice) and pdf format without MS Office or others plugins installed from any module and subpanel using templates.

Includes a 30 day guarantee
Try it Now

#1769 - Data from relationships not showing in the body section of document via [a_subX.varname]

Closed General Question created by raskew 3 years ago

When generating a document I am noticing that related data is not showing the the a body block when referenced. for instance, if the following block existed:

[a;block=w:body;sub1=relation1;sub2=relation3;sub3=relation3]

The date for {a_sub1.name] and [a_sub3.name] is not showing although it is populated. However the data for [a_sub2.name] mysteriously appears. All relations are populated. When showing the relations in a table row block on their own. The data appears, such as:

[a_sub1;block=w:tr][a_sub1.name]

  1. dharma member avatar

    Izertis Provider

    3 years ago

    Hi,

    The problem is very strange. Please, could you give us more information?. And, also, please, send us your template in order to review it.

    Regards,

    Anabel

  2. raskew member avatar

    raskew

    3 years ago

    Sure I can do that. What email address should I forward the information.

  3. raskew member avatar

    raskew

    3 years ago

    Email was sent with attachments.

  4. dharma member avatar

    Izertis Provider

    3 years ago

    Hi,

    I have just sent you an email: the problem in your template is that you have to declare blocks to obtain data from a subpanel, please, review the template example that I sent by email.

    Regards,

    Anabel

  5. raskew member avatar

    raskew

    3 years ago

    Hello Anabel.

    I understand blocks, but I don't want to display all the records from a subpanel. I only want to get 1 record from the subpanel. In the earlier example I sent you it worked for the insurance subpanel, but it didn't work for the other subpanels.

    Regards,

    Roger

  6. dharma member avatar

    Izertis Provider

    3 years ago

    Hi Roger,

    In order to have only the first record of a subpanel you can use a special tinyButStrong sintaxis. Instead to declare the variable as:
    [a_sub3;block=w:p][a_sub3.name]

    You have to declare it as:
    [a_sub3;block=w:p;when [a_sub3.#]=1][a_sub3.name]

    I have just sent a template by email,

    Regards,

    Anabel

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating

Keep up to date on the latest additions

We'll send you an email every month with handpicked add-ons, reviews, tricks and tips. Don't worry, we hate spam as much as you do.