Hi All,
I have two forms. The first forms requires an end user to submit there details and an email is sent to a member of the IT staff who are able to open the form via the DocLink.
On the same form the IT staff will then click on a button to open the second form.
The IT Staff is then required to submit for further information (in the fields provided) and again an email is generated and sent to a IT manager who again can open the same form that IT Staff had submitted via the DocLink.
On the second from I have three buttons on my form called ‘Approve’, ‘Reject’ and ‘Log Action’. These are hidden when the IT Staff opens the form as I have made use of the “Hide when paragraph document is” properties to hide the three buttons.
However, when the IT analyst opens the document via the DocLink, all three buttons appear…
I would ideally like it so that only the ‘Approve’ and ‘Reject’ button appears. If the IT Analyst then selects the ‘Approve’ button another email is forwarded to a developer who will be able to open the same form up again via the DocLink, but I would like it so the ‘Log Action’ button appears in order for additional information to be added.
If the IT Analyst selects the ‘Reject’ button then I would like the ‘Log Action’ button to remain hidden.
I am new to this and was wondering if anyone could help me create formula to my problem?
I hope I have made myself clear.
Any help would greatly be apreciated 
Many Thanks,
Sunny
Subject: Formula Help Please
I would add a Status field to the form and set the field depending on which button is clicked. Then you can hide the buttons based on the Status field.
Status could be New, Submitted to IT Staff, Submitted to Analyst, Submiitted to Developer, Approved, Rejected, Cancelled, Need Further Information and any others that you may need. Just reset the Status each time a button is clicked.
Subject: RE: Formula Help Please
Hey Sam,
I currently do have a status field called status…
and when a button is clicked the status changes.
How do i get it to hide and display the buttons accordingly?
Thanks
Subject: RE: Formula Help Please
Use RefreshHideFormulas in script OR use @Command([ViewRefreshFields]) at the end of the button formula.
Subject: RE: Formula Help Please
The properties dialog of the button has a panel for setting the hide attributes. For instance, if you want a button to be visible only if the status is “Draft”, you would write this hide formula:
Status != “Draft”
This is all you need if your buttons are action buttons (which I recommend). If they are in the body of the form, read on.
The hide properties of a button in a form do not apply to just the button, but to the entire paragraph containing the button. So if you have more than one button on the same line of the form:
[Approve] [Reject] [Submit]
they will all have the same hide formula and will either be all visible, or all hidden at the same time. You must either put them on different lines, or put them in different table cells, so that each one can have its own separate hide formula.
Subject: RE: Formula Help Please
Hi,
thanks for your reponse. Managed to get it working.
Thanks again, really appreciate it.
Sunny