In this topic we will look at some examples of using GetFormValue function

Simple Example

In the first example we will write down the expression that returns the warehouse on the invoices issued that can be found in Pantheon in menu in Goods | Invoices Issued Report | Invoices Issued Report/Profit Margin. The name of the window is 'PrometObracunIzdRac', the name of check box in which we select the warehouse is 'fWarehouse'.

[GetFormValue('PrometObracunIzdRac.fWarehouse')]

Second Example

The names of some document windows are composed of a base and a suffix representing the type of document. If we want to print the referent on the issue, we write down the term

[GetFormValue('PrometIzdDob3000.fReferentZap')]

It will only be printed for the document type 3000, but not for all others. In order to print for all document types, we have to write it down like this

[GetFormValue('PrometIzdDob'+<tbLookPoslDog."acDocType">+'.fReferentZap')]

Kjer dataseta tbLookPoslDog ni na voljo, lahko dobimo naziv okna iz številke dokumenta. Na naročilih kupcev zapišemo takole

Where tbLookPoslDog datase is not available, we can get the name of the window from the document number. On sale orders we write down:

[IIF(Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+4,1) ='-',
GetFormValue('Naroc'+Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+1,3)+'0.fReferentZap'),
GetFormValue('Naroc'+Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+1,4)+'.fReferentZap'))]

An example of using the GetFormValue function

In case of using the GetFormValue function, write down the term that returns the warehouse on the invoices issued thet is located in Goods | Invoices issued report | Invoices issued/Profit margin report. The name of the window is PrometObracunIzdRac, the name of the input field in which we select the warehouse is fSkladisce.

[GetFormValue('PrometObracunIzdRac.fSkladisce')]

The names of some document windows are composed of a base and a suffix representing the type of document. If we want to print the referent on the issue, we write down the term

[GetFormValue('PrometIzdDob3000.fReferentZap')]

It will only be printed for the document type 3000, but not for all others. In order to print for all document types, we have to write it down like this

[GetFormValue('PrometIzdDob'+<tbLookPoslDog."acDocType">+'.fReferentZap')]

Kjer dataseta tbLookPoslDog ni na voljo, lahko dobimo naziv okna iz številke dokumenta. Na naročilih kupcev zapišemo takole

Where tbLookPoslDog datase is not available, we can get the name of the window from the document number. On sale orders we write down:

[IIF(Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+4,1) ='-',
GetFormValue('Naroc'+Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+1,3)+'0.fReferentZap'),
GetFormValue('Naroc'+Copy(<qReportIzpisD."acKeyView">,Pos('-',
<qReportIzpisD."acKeyView">)+1,4)+'.fReferentZap'))]