Include a button only if it's useful...

[stonerose]

I have two tables: project records and outcome recordss. Not every project produces outcomes.

I have a functioning button on the projects layout that triggers a script that finds and displays outcomes that cite the currently displayed project as their 'parent'.

I would like to exclude this button from the layout if there are no find results. (Or at the very least, change it so that it says "No related outcomes"). It's not good enough to force the user to click and be confronted with "No results".

I have two questions:

1. How do I exclude or change the button, based on the value of a variable? Note: this does need to work in IWP, so conditional formatting may not be a good option.

2. In order to determine the key "hide" or "show" variable, do I need to run the find script each time a user enters a new record and determine whether there are relevant results for that record? Or can I do this in the background somehow, and create a matrix of all records and the value of their hide/show variable?

Thanks in advance...

[natasha]

Hi,

You can changed the button's caption depending upon the condition.I have attached the solution (.fp7) file.Is attached solution file satisfied your requirement?Pls let me know...

ButtonFormatting.zip

Edited October 2, 2009 by Guest