Manage Learn to apply best practices and optimize your operations.

RefreshFields on the Web

Some time ago I had problems with providing Web users up-to-date information generated in computed (or computed-for-display) field (named here MY_FIELD) with @DbLookup formula. Well, I didn't want to write any agents refreshing documents or something like that.

The solution of my problem was the use of a hidden computed-for-display field named e.g. "REFRESH_MY_FIELD" located at the top of the form and containing the following formula:

list:=@DBlookup("":"NoCache";server:database;view;key;field); @SetField(MY_FIELD;@If(@IsError(list);"";list))

Each time a Web user opens the document the content of MY_FIELD is being refreshed.

Dig Deeper on Domino Resources - Part 6

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...