[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

Refreshing choices in a dialog list

I'm having an issue while trying to develop a Lotus Notes database.  I was wondering if you have seen this error in the past or if anyone knows of a way to resolve this issue.
I have created a form, Job.  Within this form I have created a field of type dialog list.  In the field properties, I have selected to use a formula to generate values for this field.  The formula is as follows:  @DbColumn("";"":"";"All Programs";1).  This formula retrieves all the values in the 1st column of the All Programs view of the current database.

I also checked the box that says: refresh choices on document refresh.  This is what is not working.

Within this Job form, I have a button which allows someone to create a new Program document.  When I create a new program, save it, return to my Job, and refresh the job document:  my choices are not updated in this program list field.  I have tried multiple different options, including adding a button which refreshes the All program view and the current document, but it does not refresh.  Even if I close the Job document and reopen it, the choices are not updated.  It only seems to refresh when I reopen the database.  Any clue why this does not work?

Thanks in advance for you help!

0
sauce12
Asked:
sauce12
1 Solution
 
HemanthaKumarCommented:
Your results are cached, so use this formula instead.

@DbColumn("Notes":"NoCache";"";"All Programs";1)

~Hemanth
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now