0

NL(Linkfield) doesnt work - syntax?

Alexandra JD

May 16, 2019 07:15

Answered

Follow

 

Dear all,

 

I try to create a simple table with

NL("Tabelle";"21 Debitorenposten";{"6 Belegnr."."3 Debitorennr."."LinkFeld"."18 Debitor"."2 Name"};"4 Buchungsdatum";$E$4;"Link=";"Debitor";"1 Nr.";"=3 Debitorennr.")

 

but it doesnt work. It is the syntax of several examples.

What am I doing wrong?

 

KR

Alexandra

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Harry Lewis May 16, 2019 14:24

  Hello Alexandra -

  I think the syntax you are wanting is this:

  NL("Tabelle";"21 Debitorenposten";{"6 Belegnr.";"3 Debitorennr.";"LinkFeld([18 Debitor];[2 Name])"};"4 Buchungsdatum";$E$4;"Link=";"18 Debitor";"1 Nr.";"=3 Debitorennr.")

  I hope that helps.

• 0
  
  Alexandra JD May 20, 2019 07:07

  Hi Harry,

  unfortunately, that doesn't work.

   

  The Error message in Germin is:

  'Linkfeld([18 Debitor];[2 Name])' ist keine gültige Syntax für ein Linkfeld.

  (in english something like: is no valid Syntax for a linkfield)

  So any other Idea? i tried thousands of possibilities with ; or , or . and with or without brackets.

   

  I dont understand it.

   

  LG

  Alex

• 0
  
  Alexandra JD May 20, 2019 07:14

  Hi Harry,

  I found the solution:

   

  NL("Tabelle";"21 Debitorenposten";{"6 Belegnr."."3 Debitorennr."."LinkFeld([18 Debitor],[2 Name])"};"4 Buchungsdatum";$E$5;"Link=";"18 Debitor";"1 Nr.";"=3 Debitorennr.")

   

  Thank you and best regards

  Alexandra