Hi,
I have an embedded view on a page. The view is within a Section with a title “Headlines”. I have a code in the Section ‘s “Hide if formula is true”. The code does a Dbcolumn look up to a hidden view. If there is no document in the view the section should be hidden, if there is a document in the view the section should be displayed.
It works but I always have to exit and re-enter the database. How do I refresh so that the section hides immediately if no documents are in the view or displays immediately if there are without having to exit and re-enter the database?
Thanks!
Subject: Thoughts regarding this issue
Hi, Tomi. I am not sure what type of controlled access section you have. Try making the section Computed for Display if it is some other type. Also, it may be that the lookup view is not refreshing. Is the view Refresh setting set to Auto or Auto, after first use and is the On Refresh setting for the view set to one of the Refresh display options? Lastly, please make sure that the @DbColumn in the hide when formula is using NoCache as its cache parameter.
Subject: RE: Thoughts regarding this issue
Thanks a lot Dave! I will check everything you suggested. I really appreciate your time. I will let you know how it goes.