Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Hide or Show a Field via Action Buttons

In Lotus Notes R5, I have a form in which I wish the user to click an Action Button to allow that a particular field would be "shown" or "hidden", ie. toggling back and forth.  This would even be on the original form before the document is saved.

I have a completely hidden field called "TicketShow" which is set to either "0" (not show) or "1" (show) via action buttons.  

The field called "Ticket#" (Text, Editable) is the one which I want to either show or not show.   It has a hide formula which says to "hide paragraph if TicketShow is 0".  

The problem is that the document has to be SAVED each time before giving the desired effect.   Is there a way to refresh the screen based on the new value of the "TicketShow" field without having to do a File Save and File Close first?

Or perhaps I am making this more complicated than it needs to be...any other approaches are welcome.  Thanks.
0
blyons48
Asked:
blyons48
  • 2
1 Solution
 
marilyngCommented:
Blyons,
Is TicketShow an editable field?
Is the form set to refresh automatically?
Are your action buttons composed in script or formula?

YOu shouldn't have to save the form after the action button is pressed, just refresh it so the hidewhen formulas fire.

If the form isn't set to refresh fields automatically (consumes more resources) you can program it to refresh via the buttons.  

Button Formula:
Field TicketShow = 1 (..etc)
@Command( [RefreshHideFormulas] )

let me know if you need the script, instead.

marilyng

0
 
blyons48Author Commented:
The @Command([RefreshHideFormulas]) which you showed in the button formula was exactly what I was looking for.  It did the trick and made my code to work as desired.  It is curious that when I did a Lotus Notes help, using the search word of "refresh" it didn't find that command.   Nevertheless, you have helped me resolve my problem and I thank you.  Excellent answer.
0
 
marilyngCommented:
happy to help!
marilyng
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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