Validation of two fields on form and making it mandatory

(0) Share

Report

Posted on by Saurav

230

Hi,

I have a very basic question if you can help with. I have the following form(Say form A) which has two fields(Attachment below) :

Two fields are Credit and Debit from a single datasource (Say Table B)

1832.Form.JPG

I have to fulfill the following condition:

a. If Debit is filled Credit field should become mandatory (Should not allow to close the form , which in turn save without filling Credit field)

b. If Credit is filled Debit field should become mandatory (Should not allow to close the form , which in turn save without filling Debit field)

c. If both(Debit and Credit) are left blank , should allow to save without any validation

I presume there are various way to achieve this. Please let me know both ways in form level and table level on how to write mandatory conditions. Any help will be appreciated

Regards,

Sourav

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (3)

Sort by

Verified answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

validateWrite() is the right method. If the same logic should run even if somebody uses the table in a different form (which seems likely), you should implement it on the tables. If it was logic specific to this particular form (and other forms could use the table differently), it should be implemented on the form datasource.

Was this reply helpful? Yes No
Saurav 230 on at

Like (0)

Report
Copy link

Link copied!

I wrote this code after i override Validatewrite method in the datasource:

FundSourcePosting is the table LedgerDimensionDebit and LedgerDimensionCredit are the field after super call..Not working .. Seems like i have to assign something on ret

public boolean validateWrite()

{

boolean ret;

ret = super();

if(FundSourcePosting.LedgerDimensionDebit || FundSourcePosting.LedgerDimensionCredit)

{

FundSourcePosting_ds.object(fieldnum(FundSourcePosting,LedgerDimensionDebit)).mandatory(true);

FundSourcePosting_ds.object(fieldnum(FundSourcePosting,LedgerDimensionCredit)).mandatory(true);

}

else

{

FundSourcePosting_ds.object(fieldnum(FundSourcePosting,LedgerDimensionDebit)).mandatory(false);

FundSourcePosting_ds.object(fieldnum(FundSourcePosting,LedgerDimensionCredit)).mandatory(false);

}

return ret;

}

Could you clarify..

Thanks

Sourav

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You didn't get the purpose of validateWrite(). It decides whether the record can be saved or not - it returns true if the record can be saved and false if the data isn't correct. You code wouldn't meet your requirements that the record can't be saved and the form can't be closed.

Your code should look like this (assuming that you put it on the table):

public boolean validateWrite() { boolean ret = super(); if (ret) { if ((this.LedgerDimensionDebit == 0) ^ (this.LedgerDimensionCredit == 0) { ret = false; } } return ret; }

You can also add the visual indication by setting form controls as mandatory, but the validation is much more important. It guarantees data consistency.

Was this reply helpful? Yes No
Saurav 230 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

This really worked. I have overriden the validateWrite method in table level as below:

public boolean validateWrite()
{
boolean ret;

ret = super();

//Validation for Credit and Debit account in Fund source posting
if (ret)
{
if ((this.LedgerDimensionDebit == 0) ^ (this.LedgerDimensionCredit == 0))
{
ret = false;
checkFailed("@CMC1440");
}

}

return ret;
}

Its working fine with the following message coming (Attached as infolog) on the form when i Click on Close button and the Cross button on the form.

However, when i press the key Alt+F4(Which is also a way to close the form) , the validation message comes two times as below:

This was found by my QA while doing a scenario. I have debugged it and the code is iterating two times when i click on ALT+F4 . However its only once when i close the form by clicking on Close button or click the cross button on Form. Any suggestion

Regards

Sourav

Was this reply helpful? Yes No
Saurav 230 on at

Like (0)

Report
Copy link

Link copied!

Apolozise , the code in validatewrite is as below:

public boolean validateWrite()

{

boolean ret;

ret = super();

//Validation for Credit and Debit account in Fund source posting

if (ret)

{

if ((this.LedgerDimensionDebit == 0) ^ (this.LedgerDimensionCredit == 0))

{

ret = false;

checkFailed("@CMC1440");

}

}

return ret;

}

But the ALt+F4 button while closing the form has the same behavior, throwing the validation error message twice

Was this reply helpful? Yes No
Saurav 230 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Anybody who can respond to my above issue

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,451 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What's the call stack in those two cases?

By the way, checkFailed() returns false, therefore you can simply write ret = checkFailed("@CMC1440"). It's why there is checkFailed() in addition to warning().

Was this reply helpful? Yes No