Hi,
I want to take all documents from names.nsf which are shown in server/Holidays view of a server.
I created a field(its type is dialog list) called CountryName. This field takes Country(HolidayGroup) names from server/Holidays view.This is my key field.
Firstly I want to take their Start Date that was shown in the view's second coloumn.My formula was:
gcc := @DbLookup( "Notes" : "NoCache" ; "server-name" : "names.nsf" ;"Holidays";CountryName; 2) ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc )) )
In CountryName field I selected three country. And I saw that it works properly.
Then I want to take "RepeatUntil" field that was not replaced in the view. My code was:
gcc := @DbLookup( "Notes" : "NoCache" ; "server_name" : "names.nsf" ;"Holidays(view's name)" ;CountryName ; "RepeatUntil" ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc ))
I saw that this works for only first element of CountryName Field.I can't take other country's RepeatUntil dates.
Can you Help me?
Emre Erhan
I want to take all documents from names.nsf which are shown in server/Holidays view of a server.
I created a field(its type is dialog list) called CountryName. This field takes Country(HolidayGroup) names from server/Holidays view.This is my key field.
Firstly I want to take their Start Date that was shown in the view's second coloumn.My formula was:
gcc := @DbLookup( "Notes" : "NoCache" ; "server-name" : "names.nsf" ;"Holidays";CountryName; 2) ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc )) )
In CountryName field I selected three country. And I saw that it works properly.
Then I want to take "RepeatUntil" field that was not replaced in the view. My code was:
gcc := @DbLookup( "Notes" : "NoCache" ; "server_name" : "names.nsf" ;"Holidays(view's name)" ;CountryName ; "RepeatUntil" ;
@If (@IsError( gcc ) ; "" ; @Unique(@Text( gcc ))
I saw that this works for only first element of CountryName Field.I can't take other country's RepeatUntil dates.
Can you Help me?
Emre Erhan