HELP - Need help with Dblookup validation formula

HCL Domino Domino Forum
1

I need assistance with Lotus Notes Domino coding. I am trying to write a command that use the current field (@thisfield) which contains a date to lookup the value in a view prior to saving the form. If the value found in the view has a number greater than four in the key column, then the user can’t save the form and has exceeded the daily limit. Please help. I have a project about to start and need this formula in place to avoid overscheduling.

Here’s my formula:

supgrades:=((@DbLookup(“”:“NoCache”;“”:“”;“Upgrades”;“TotalUpgrades”;“UpgradeDate”;“”)));

PerDay:=@DbColumn(“”:“NoCache”;“”:“”;“_Admin\UnitsPerDay”;1);

@If((SUpgrades *>PerDay);@Failure(“Exceeds Daily limit of 4 per day. Please choose another Ship Date.”);@Success)

2

Subject: @DbLookup

Sure there are double quotes around TotalUpgrades ? (if this refers to a field, there shouldn’t be).Besides, get rid of the optional “keywords” parameter at the end of your @DbLookup).

Thierry Cayla

http://dominoeffects.serveblog.net

3

Subject: try substituting this

supgrades:=((@DbLookup(“”:“NoCache”;“”;“Upgrades”;fieldname;“UpgradeDate”;“”)));