Solved

FM - Conditional Formatting to Make Buttons Invisible?

Posted on 2011-03-04
2
1,036 Views
Last Modified: 2012-05-11
I have a growing need to use conditional formatting to make things invisible.  However, conditional formatting does not have an option for that.  In certain situations, such as portal rows where I alternate the background color, I can't simply match the color to make it invisible.  

For example, currently, I have a delete button and a Related Reocrd button on every portal row, but don't like the look when it shows in the blank new-row-to-be.  Ideally, I want to use a condition that says IF the RecID is empty, be invisible.  Do you all have a workaround?
0
Comment
Question by:rvfowler2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
Will Loving earned 500 total points
ID: 35037113
Well, my primary recommendation would be to script creating a "new record" function rather using the "Allow creation of related records in this table using the relationship" option. I almost never use the "Allow creation..." option because 1) it's confusing to users to have the seemingly blank record (but with buttons as you mention) at the end of the list, 2) it's at the end of the list rather than the top, 3) it tends to result in the creation of blank records when users enter the field and then leave it after typing text, changing their mind, deleting the text but not the newly created record.

So, I recommend a scripted "New" button, possibly combined with a sort order that puts portal records missing certain values at the top of the portal row. Either that or put up a dialog that captures some or all of the values going into the portal row record which gives you more control over validation of entered data if you need it. You can also use script triggers to start the new record process depending on layout.

I know the above didn't directly answer your question, but sometimes it's good to backup a step further and look at the larger issue. Regarding making text invisible, if security is not an issue with the field contents and if background is white or an identifiable color, I will just set conditional formatting to make the text the same color as the background (usually white) and 1 point font size, but better solutions generally involve a calculated field to show the button text or graphic under specific circumstances.

By the way, if you need some nice graphics for non-commercial projects, I recommend checking out the following open source graphics libraries. Just setup a separate table for graphics and you'll improve the look of your entire interface but getting rid of those clunky gray buttons...

Tango Desktop Library: http://tango.freedesktop.org/Tango_Icon_Library

NuoveXT: http://nuovext.pwsp.net/

0
 
LVL 2

Author Closing Comment

by:rvfowler2
ID: 35037463
Thanks, Will.  Yes, I prefer someone give me a best practice rather than just answering my specific question.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

687 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question