Field Format!!!

Hanen

Hello,

How can I define a Format for a field, My field "FieldA" depends on an other field "FieldB":

FieldA must have this format: Provider='xxxx';databaseName='xxxxx';ServerName='xxxx'... if FieldB=A
else
FieldA must have this format: Login='xxxx';Password='xxxx';Provider='xxxx';databaseName='xxxxx';ServerName='xxxx'...

how can I tell my user that the data will be on that format :oops:
Thanks for your help!!!

prabhupdesh

In the OnFormat Trigger of field B write the condition u have specified:

For example:
IF Field B = A THEN
color=#800080]FieldA must have this format: Provider='xxxx';databaseName='xxxxx';ServerName='xxxx'...
else
FieldA must have this format: Login='xxxx';Password='xxxx';Provider='xxxx';databaseName='xxxxx';ServerName='xxxx'...

Hanen

The problem is that the use must fill the FieldB with the right format the Login='xxxx' will be replaced by Login='Hanen' etc...

kine

And why do not just let user fill the data like databaseName, provider etc. and the system will create the connect string automatically?

Hanen

This is the way the user wants to be it would be much easier

kine

Are you sure that it will be easier? I think no... because if you will want to fullfill the request, you will need to do it in a way, which will work in a very strange way, because you cannot force the user to enter the value in some specific syntax by default tools in NAV.

Hanen

it would be easier if can do it in a different wya then to le the use full fill the field that's what I meant
I think I will try your manner thanks

garak

if it is a form where you store the connecting settings for an ODBC or ADO connection, why do you not create there some fields like:
Database
Server
Login
Password
etc? The user enter there the values and you build the connection string based on this values ....

David_Singleton

garak wrote:

if it is a form where you store the connecting settings for an ODBC or ADO connection, why do you not create there some fields like:
Database
Server
Login
Password
etc? The user enter there the values and you build the connection string based on this values ....

Ah you mean like Kine just suggested above. Yes that is a good idea.

garak

David Singleton wrote:

Ah you mean like Kine just suggested above. Yes that is a good idea.

Yes, i mean the same

Hanen

Yes I did it just like that, as separate fields.
Thanks for evryone's answer =D> :thumbsup: